• Home
  • SQL Server
    • Articles
    • T-SQL Puzzles
    • Output Puzzles
    • Interview Questions
    • Performance Tuning
    • SQL SERVER On Linux
    • Resources
  • SSRS
    • SSRS Articles
    • Interview Questions
  • SSAS
    • SSAS Articles
    • DAX
  • SQL Puzzles
  • Interview Questions
    • SQL Interview Questions
    • Data Interview Questions
  • Python Interview Puzzles
  • New Features(SQL SERVER)
    • SQL SERVER 2017
    • SQL SERVER 2016
    • SQL SERVER On Linux
  • Social
    • Expert Exchange
      • Top Expert in SQL
      • Yearly Award
      • Certifications
      • Achievement List
      • Top Expert of the Week
    • HackerRank (SQL)
    • StackOverflow
    • About Me
      • Contact Me
      • Blog Rules

Improving my SQL BI Skills

Improving my SQL BI Skills

Category Archives: CSS

CSS Stuff

onononon

04 Saturday Sep 2010

Posted by Pawan Kumar Khowal in CSS

≈ Leave a comment


using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using AeBusinessLayer.ClassFiles;
using System.Xml.Xsl;
using System.Data.OleDb;
using System.Xml;
using System.IO;
using AeBusinessLayer;
using System.Xml.XPath;
using System.Xml.Schema;
using System.Threading;
public partial class InvoiceManagement_InvoicesCreated : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            btnCancelInvoice.Attributes.Add("onclick", "getConfirmationForDelete(‘" + this.hdnFlag.ClientID.ToString() + "’)");
            btnCancelRun.Attributes.Add("onclick", "getConfirmationForDelete(‘" + this.hdnFlag.ClientID.ToString() + "’)");
            btnExecuteRun.Attributes.Add("onclick", "getConfirmationForDelete(‘" + this.hdnFlag.ClientID.ToString() + "’)");
            btnCreateHTML.Attributes.Add("onclick", "getConfirmationForDelete(‘" + this.hdnFlag.ClientID.ToString() + "’)");
            btnCreateXml.Attributes.Add("onclick", "getConfirmationForDelete(‘" + this.hdnFlag.ClientID.ToString() + "’)");
            btnCreateInvoice.Attributes.Add("onclick", "getConfirmationForDelete(‘" + this.hdnFlag.ClientID.ToString() + "’)");
            AeSharedLibrary.clsSession.UserSession SessionStruct;
            SessionStruct = (AeSharedLibrary.clsSession.UserSession)Session["UserInformation"];
            AeBusinessLayer.ClassFiles.BatchSummary _batch = new AeBusinessLayer.ClassFiles.BatchSummary();
            DataSet _dsEmail = _batch.SelectToInvoiceDetails(SessionStruct.BillId);
            if (_dsEmail.Tables[0].Rows.Count > 0)
            {
                btnCancelInvoice.Visible = true;
                btnCreateInvoice.Visible = true;
                btnCreateXml.Visible = true;
                btnCreateHTML.Visible = true;
                btnCancelRun.Visible = true;
                gvInvoiceDetails.Visible = true;
                lblMessage.Visible = false;
                Panel8.Visible = true;
                Label1.Visible = true;
                chkBoxAlls.Visible = true;
                ViewState["EmailInvoice"] = _dsEmail.Tables[0];
                gvInvoiceDetails.DataSource = _dsEmail.Tables[0].DefaultView;
                gvInvoiceDetails.DataBind();
            }
            else
            {
                btnCancelInvoice.Visible = false;
                btnCreateInvoice.Visible = false;
                btnCreateXml.Visible = false;
                Label1.Visible = false;
                btnCreateHTML.Visible = false;
                btnCancelRun.Visible = false;
                chkBoxAlls.Visible = false;
                lblMessage.Visible = true;
                Panel8.Visible = false;
                lblMessage.Text = "Please Execute Run for creating invoices";
                gvInvoiceDetails.Visible = false;
            }
        }
    }
    protected void btnBack_Click(object sender, EventArgs e)
    {
        Server.Transfer("~/InvoiceManagement/BatchSummary.aspx");
    }
    protected void gvInvoiceDetails_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "InvoiceId")
        {
            LinkButton btn = (LinkButton)e.CommandSource;
            int TransId = Convert.ToInt32(btn.Text.ToString());
            SessionInfo(TransId, "~/InvoiceManagement/InvoicesCreated.aspx", "~/InvoiceManagement/TransactionDetails.aspx", string.Empty);
        }
    }
    protected void SessionInfo(int TransId, string PagePath, string NewPath, string MessageString)
    {
        AeSharedLibrary.clsSession.UserSession SessionStruct;
        SessionStruct = (AeSharedLibrary.clsSession.UserSession)Session["UserInformation"];
        SessionStruct.transId = TransId;
        SessionStruct.MessageString = MessageString;
        SessionStruct.PagePath = PagePath;
        Session["UserInformation"] = SessionStruct;
        Server.Transfer(NewPath);
    }
    protected void btnExecuteRun_Click(object sender, EventArgs e)
    {
        if (gvInvoiceDetails.Rows.Count == 0)
        {
            if (this.hdnFlag.Value == "OK")
            {
                AeSharedLibrary.clsSession.UserSession SessionStruct;
                SessionStruct = (AeSharedLibrary.clsSession.UserSession)Session["UserInformation"];
                int BillId = SessionStruct.BillId;
                //Add Confirmation Box here -Pawan
                AeBusinessLayer.ClassFiles.BatchSummary _batch = new AeBusinessLayer.ClassFiles.BatchSummary();
                _batch.ExecuteForBillRunToCreateInvoices(BillId);
                SessionInfo(0, "~/InvoiceManagement/InvoicesCreated.aspx", "~/Message/Message.aspx", "Execute run has been completed.");
            }
            else
            {
                //do not do anything.
            }
        }
        else if (gvInvoiceDetails.Rows.Count > 0)
        {
            if (this.hdnFlag.Value == "OK")
            {
                CheckBox chk;
                int Checked = 0;
                foreach (GridViewRow rowItem in gvInvoiceDetails.Rows)
                {
                    chk = (CheckBox)(rowItem.Cells[0].FindControl("chkBoxChild"));
                    if (chk.Checked == true)
                    {
                        Checked++;
                        int BillRunId = Convert.ToInt32(rowItem.Cells[1].Text.Trim().ToString());
                        AeBusinessLayer.ClassFiles.BatchSummary _batch = new AeBusinessLayer.ClassFiles.BatchSummary();
                        _batch.ExecuteForBillRunToCreateInvoices(BillRunId);
                    }
                }
                if (Checked == 0)
                {
                    AeSharedLibrary.clsMessage.Show("Select to Execute Bill Run");
                }
                else
                {
                    SessionInfo(0, "~/InvoiceManagement/InvoicesCreated.aspx", "~/Message/Message.aspx", "Execute run has been completed.");
                }
            }
            else
            {
                // do not do anything.
            }
        }
    }
    protected void btnCancelInvoice_Click(object sender, EventArgs e)
    {
        if (this.hdnFlag.Value == "OK")
        {
            CheckBox chk;
            int Checked = 0;
            foreach (GridViewRow rowItem in gvInvoiceDetails.Rows)
            {
                chk = (CheckBox)(rowItem.Cells[0].FindControl("chkBoxChild"));
                if (chk.Checked == true)
                {
                    Checked++;
                    LinkButton bill = (LinkButton)(rowItem.Cells[5].FindControl("lnkInvoice"));
                    int InvoiceId = Convert.ToInt32(bill.Text.Trim().ToString());
                    AeBusinessLayer.ClassFiles.BatchSummary _batch = new AeBusinessLayer.ClassFiles.BatchSummary();
                    _batch.CancelInvoices(InvoiceId);
                }
            }
            if (Checked == 0)
            {
                AeSharedLibrary.clsMessage.Show("Select to Cancel Invoice(s)");
            }
            else
            {
                SessionInfo(0, "~/InvoiceManagement/InvoicesCreated.aspx", "~/Message/Message.aspx", "Cancel Invoice has been completed.");
            }
        }
        else
        {
            //do not do anything
        }
    }
    protected void btnCancelRun_Click(object sender, EventArgs e)
    {
        if (this.hdnFlag.Value == "OK")
        {
            CheckBox chk;
            int Checked = 0;
            foreach (GridViewRow rowItem in gvInvoiceDetails.Rows)
            {
                chk = (CheckBox)(rowItem.Cells[0].FindControl("chkBoxChild"));
                if (chk.Checked == true)
                {
                    Checked++;
                    int billRunId = Convert.ToInt32(rowItem.Cells[1].Text.Trim().ToString());
                    AeBusinessLayer.ClassFiles.BatchSummary _batch = new AeBusinessLayer.ClassFiles.BatchSummary();
                    _batch.CancelBillRun(billRunId);
                }
            }
            if (Checked == 0)
            {
                AeSharedLibrary.clsMessage.Show("Select to Cancel bill run");
            }
            else
            {
                SessionInfo(0, "~/InvoiceManagement/InvoicesCreated.aspx", "~/Message/Message.aspx", "Cancel bill run has been completed.");
            }
        }
        else
        {
            // do not do anything
        }
    }
    protected void btnCreateInvoice_Click(object sender, EventArgs e)
    {
        if (this.hdnFlag.Value == "OK")
        {
            CheckBox chk;
            int Checked = 0;
            foreach (GridViewRow rowItem in gvInvoiceDetails.Rows)
            {
                chk = (CheckBox)(rowItem.Cells[0].FindControl("chkBoxChild"));
                if (chk.Checked == true)
                {
                    Checked++;
                    int billRunId = Convert.ToInt32(rowItem.Cells[1].Text.Trim().ToString());
                    string customerId = Convert.ToString(rowItem.Cells[4].Text.Trim().ToString());
                    int partnerid = Convert.ToInt32(rowItem.Cells[3].Text.Trim().ToString());
                    AeBusinessLayer.ClassFiles.BatchSummary _batch = new AeBusinessLayer.ClassFiles.BatchSummary();
                    _batch.CreateInvoice(billRunId, customerId, partnerid);
                }
            }
            if (Checked == 0)
            {
                AeSharedLibrary.clsMessage.Show("Select to Create Invoices");
            }
            else
            {
                SessionInfo(0, "~/InvoiceManagement/InvoicesCreated.aspx", "~/Message/Message.aspx", "Create Invoice(s) has been completed.");
            }
        }
        else
        {
            // do not do anything
        }
    }
    private void InsertHTMLStatus(int NoofHTMLstobeProcessed, int billRunId)
    {
        AeBusinessLayer.ClassFiles.BatchSummary _batch = new BatchSummary();
        int retValue = _batch.InsertInvoiceProcessStatusFORHTML(NoofHTMLstobeProcessed, billRunId);
        if (retValue == 1)
        {
            //AeSharedLibrary.clsMessage.Show("opps ……………………..");
        }
        else if (retValue == 0)
        {
            AeSharedLibrary.clsMessage.Show("Error has been occurred");
        }
    }
    private void InsertXMLStatus(int NoofXmlstobeProcessed, int billRunId)
    {
        AeBusinessLayer.ClassFiles.BatchSummary _batch = new BatchSummary();
        int retValue = _batch.InsertInvoiceProcessStatus(NoofXmlstobeProcessed, billRunId);
        if (retValue == 1)
        {
            //AeSharedLibrary.clsMessage.Show("opps ……………………..");
        }
        else if (retValue == 0)
        {
            AeSharedLibrary.clsMessage.Show("Error has been occurred");
        }
    }
    private void UpdateXMLStatus()
    {
        // Status ,  , XMLSProcessed , IsErrorForXML , ErrorForXML , XMLProcessStatus , ModifiedOn(getdate()) ,
        AeBusinessLayer.ClassFiles.BatchSummary _batch = new BatchSummary();
        DataSet dsInvoiceStatusId = _batch.SelectTopInvoiceStatusId();
        int Err;
        if (dsInvoiceStatusId.Tables[0].Rows.Count > 0)
        {
            int InvoiceProcessStatusId = Convert.ToInt32(dsInvoiceStatusId.Tables[0].Rows[0][0].ToString());
            int XMLSProcessed = Convert.ToInt32(dsInvoiceStatusId.Tables[0].Rows[0][1].ToString());
            int RetValue = _batch.UpdateInvoiceProcessStatus(InvoiceProcessStatusId, null, "Completed", 0, "Completed", 0, null);
            if (RetValue == 1)
            {
                //AeSharedLibrary.clsMessage.Show("opps ……………………..");
            }
            else if (RetValue == 0)
            {
                AeSharedLibrary.clsMessage.Show("Error has been occurred");
            }
        }
    }
    private void UpdateHTMLStatus()
    {
        AeBusinessLayer.ClassFiles.BatchSummary _batch = new BatchSummary();
        DataSet dsInvoiceStatusId = _batch.SelectTopInvoiceStatusId();
        int Err;
        if (dsInvoiceStatusId.Tables[0].Rows.Count > 0)
        {
            int InvoiceProcessStatusId = Convert.ToInt32(dsInvoiceStatusId.Tables[0].Rows[0][0].ToString());
            int XMLSProcessed = Convert.ToInt32(dsInvoiceStatusId.Tables[0].Rows[0][1].ToString());
            int RetValue = _batch.UpdateInvoiceProcessStatus(InvoiceProcessStatusId, null, "Completed", 0, "Completed", 0, null);
            if (RetValue == 1)
            {
                //AeSharedLibrary.clsMessage.Show("opps ……………………..");
            }
            else if (RetValue == 0)
            {
                AeSharedLibrary.clsMessage.Show("Error has been occurred");
            }
        }
    }
    protected void btnCreateXml_Click(object sender, EventArgs e)
    {
        AeBusinessLayer.ClassFiles.CreateXml _createXml = new AeBusinessLayer.ClassFiles.CreateXml();
        if (this.hdnFlag.Value == "OK")
        {
            CheckBox chk;
            int XMLStobeProcessed = 0;
            foreach (GridViewRow rowItem in gvInvoiceDetails.Rows)
            {
                chk = (CheckBox)(rowItem.Cells[0].FindControl("chkBoxChild"));
                if (chk.Checked == true)
                {
                    XMLStobeProcessed += 1;
                }
            }
            if (XMLStobeProcessed > 0)
            {
                int billRunId = Convert.ToInt32(gvInvoiceDetails.Rows[0].Cells[1].Text.Trim().ToString());
                InsertXMLStatus(XMLStobeProcessed, billRunId);
                AeBusinessLayer.ClassFiles.BatchSummary _batch = new BatchSummary();
                DataSet dsInvoiceStatusId = _batch.SelectTopInvoiceStatusId();
                int InvoiceProcessStatusId = Convert.ToInt32(dsInvoiceStatusId.Tables[0].Rows[0][0].ToString());
                Thread td = new Thread(new ThreadStart(NewThisTime));               
                td.IsBackground = true;
                td.Start();
                NewThisTime();
                AeSharedLibrary.clsSession.UserSession SessionStruct;
                SessionStruct = (AeSharedLibrary.clsSession.UserSession)Session["UserInformation"];
                SessionStruct.transId = InvoiceProcessStatusId;
                Session["UserInformation"] = SessionStruct;
                string popupScript = "<script language=javascript> window.open(‘../InvoiceManagement/ASyncXML.aspx’,’_blank’,’height=300,width=600,top=150,left=150,status=no,toolbar=no,menubar=no,location=no,scrollbars=no,resizable=no,copyhistory=false’)</script>";
                ClientScript.RegisterStartupScript(this.GetType(), "callpopup", popupScript);
            }
            else
            {
            }
        }
        else
        {
        }
    }
    protected void NewThisTime()
    {
        CheckBox chk;
        foreach (GridViewRow rowItem in gvInvoiceDetails.Rows)
        {
            chk = (CheckBox)(rowItem.Cells[0].FindControl("chkBoxChild"));
            if (chk.Checked == true)
            {
                int PartnerId = Convert.ToInt32(rowItem.Cells[3].Text.Trim().ToString());
                int billRunId = Convert.ToInt32(rowItem.Cells[1].Text.Trim().ToString());
                int billRunDetailId = Convert.ToInt32(rowItem.Cells[2].Text.Trim().ToString());
                LinkButton bill = (LinkButton)(rowItem.Cells[5].FindControl("lnkInvoice"));
                int billId = Convert.ToInt32(bill.Text);
                int InvoiceId = billId;
                string CustomerId = Convert.ToString(rowItem.Cells[4].Text.Trim());
                //Reset pool for the selected customer id here.
                AeBusinessLayer.ClassFiles.InvoiceCreated _invoice = new InvoiceCreated();
                int rtvalue = _invoice.ResetPool(CustomerId);
                if (rtvalue == 0)
                {
                    AeSharedLibrary.clsEmail.SendNewCustomerEmail("pawan.kumar@affinityexpress.co.in", "System is unable to reset the pool value", "Resetting Pool Value", null);
                }
                AeBusinessLayer.ClassFiles.XML _xml = new XML();
                _xml.CreateXML(PartnerId, InvoiceId, CustomerId, billRunId, billRunDetailId);
            }
        }
    }
    protected void btnCreateHTML_Click(object sender, EventArgs e)
    {
        if (this.hdnFlag.Value == "OK")
        {
            forhtml();
        }
    }
    protected void NewforHTML()
    {
        string _OutputDirectory = string.Empty;
        CheckBox chk;
        foreach (GridViewRow roowitem in gvInvoiceDetails.Rows)
        {
            chk = (CheckBox)(roowitem.Cells[0].FindControl("chkBoxChild"));
            if (chk.Checked == true)
            {
                LinkButton btn = (LinkButton)roowitem.Cells[5].FindControl("lnkInvoice");
                string str = btn.Text.ToString();
                int invoiceid = Convert.ToInt32(str);
                int partnerid = Convert.ToInt32(roowitem.Cells[3].Text);
                int billRunId = Convert.ToInt32(gvInvoiceDetails.Rows[0].Cells[1].Text.Trim().ToString());
                BatchSummary _incoivehtml = new BatchSummary();
                DataSet _dsinvoice = _incoivehtml.SelectinvoiceForHtmldetails(invoiceid);
                string customer_id = _dsinvoice.Tables[0].Rows[0]["customer_id"].ToString();
                DateTime dat = Convert.ToDateTime(_dsinvoice.Tables[0].Rows[0]["invoice_start_date"].ToString());
                DateTime date = dat;
                string Fillexml = string.Empty;
                try
                {
                    if (dat.Month.ToString().Length == 1)
                    {
                        if (dat.Day.ToString().Length == 1)
                            Fillexml = @"C:\Invoices\" + dat.Year + "-0" + dat.Month + "-0" + dat.Day + @"\" + partnerid + @"\" + "Inv" + invoiceid + ".xml";
                        else
                            Fillexml = @"C:\Invoices\" + dat.Year + "-0" + dat.Month + "-" + dat.Day + @"\" + partnerid + @"\" + "Inv" + invoiceid + ".xml";
                    }
                    else
                    {
                        if (dat.Day.ToString().Length == 1)
                            Fillexml = @"C:\Invoices\" + dat.Year + "-" + dat.Month + "-0" + dat.Day + @"\" + partnerid + @"\" + "Inv" + invoiceid + ".xml";
                        else
                            Fillexml = @"C:\Invoices\" + dat.Year + "-" + dat.Month + "-" + dat.Day + @"\" + partnerid + @"\" + "Inv" + invoiceid + ".xml";
                    }
                    string pathhtml = @"C:\Invoices\Emails\";
                    string targetfile = pathhtml + "\\" + date.Year + "-" + date.Month + "-" + date.Day + @"\" + partnerid + "\\" + invoiceid + ".html";
                    //string xslfile = "\\10.0.0.229\\Emails\\styleSheets\\" + "InternalToEmailFormatOne.xsl";
                    XsltArgumentList args = new XsltArgumentList();
                    args.AddParam("partnerid", "", partnerid);
                    args.AddParam("invoiceid", "", invoiceid);
                    _OutputDirectory = pathhtml + date.Year + "-" + date.Month + "-" + date.Day + @"\" + partnerid + "\\";
                    if (!Directory.Exists(_OutputDirectory))
                        Directory.CreateDirectory(_OutputDirectory);
                    //int retValue = transform(xslfile, Fillexml, args, targetfile);    — Replaced by code below Pawan.
                    XmlDocument transformDoc = new XmlDocument();
                    string str1 = @"\\10.0.0.229\\Emails\\styleSheets\\InternalToEmailFormatOne.xsl";
                    transformDoc.Load(str1);
                    XmlDocument sourceDoc = new XmlDocument();
                    sourceDoc.Load(Fillexml);
                    StreamWriter writer = new StreamWriter(targetfile, false, System.Text.Encoding.UTF8);
                    XslTransform trans = new XslTransform();
                    XmlUrlResolver resolver = new XmlUrlResolver();
                    GC.Collect();
                    trans.Load(transformDoc, resolver, System.AppDomain.CurrentDomain.Evidence);
                    trans.Transform(sourceDoc, args, writer, resolver);
                    writer.Flush();
                    writer.Close();
                    DataSet dsInvoiceStatusId = _incoivehtml.SelectTopInvoiceStatusId();
                    int Retz = _incoivehtml.UpdateInvoiceProcessStatusFORHTML(Convert.ToInt32(dsInvoiceStatusId.Tables[0].Rows[0][0].ToString()), "InProgress", 0, null, "In Progress", 0, null); 
                }
                catch (Exception exec)
                {
                    BatchSummary _bat = new BatchSummary();
                    DataSet dsInvoiceStatusId = _bat.SelectTopInvoiceStatusId();
                    BatchSummary _batch = new BatchSummary();
                    int returnValue = _batch.InsertIntoErrForHTMLGeneration(Convert.ToInt32(dsInvoiceStatusId.Tables[0].Rows[0][0].ToString()), exec.Message.ToString(), billRunId, partnerid, customer_id, invoiceid);
                }
            }
        }
    }
    protected void forhtml()
    {
        string _OutputDirectory = string.Empty;
        CheckBox chk;
        int totalNoOfHTMS = 0;
        foreach (GridViewRow roowitem in gvInvoiceDetails.Rows)
        {
            chk = (CheckBox)(roowitem.Cells[0].FindControl("chkBoxChild"));
            if (chk.Checked == true)
            {
                totalNoOfHTMS += 1;
            }
        }
        if (totalNoOfHTMS > 0)
        {
            int billRunId = Convert.ToInt32(gvInvoiceDetails.Rows[0].Cells[1].Text.Trim().ToString());
            InsertHTMLStatus(totalNoOfHTMS, billRunId);
            AeBusinessLayer.ClassFiles.BatchSummary _batch = new BatchSummary();
            DataSet dsInvoiceStatusId = _batch.SelectTopInvoiceStatusId();
            int InvoiceProcessStatusId = Convert.ToInt32(dsInvoiceStatusId.Tables[0].Rows[0][0].ToString());
            Thread td = new Thread(new ThreadStart(NewThisTime));               
            td.IsBackground = true;
            td.Start();
            NewforHTML();
            AeSharedLibrary.clsSession.UserSession SessionStruct;
            SessionStruct = (AeSharedLibrary.clsSession.UserSession)Session["UserInformation"];
            SessionStruct.transId = InvoiceProcessStatusId;
            Session["UserInformation"] = SessionStruct;
            string popupScript = "<script language=javascript> window.open(‘../InvoiceManagement/AsyncHTML.aspx’,’_blank’,’height=300,width=600,top=150,left=150,status=no,toolbar=no,menubar=no,location=no,scrollbars=no,resizable=no,copyhistory=false’)</script>";
            ClientScript.RegisterStartupScript(this.GetType(), "callpopup", popupScript);
        }
    }
    protected int transform(string xslfile, string sourcefile, XsltArgumentList args, string targetfile)
    {
        XmlDocument transformDoc = new XmlDocument();
        try
        {
            string str = @"\\10.0.0.229\\Emails\\styleSheets\\InternalToEmailFormatOne.xsl";
            transformDoc.Load(str);
            XmlDocument sourceDoc = new XmlDocument();
            sourceDoc.Load(sourcefile);
            StreamWriter writer = new StreamWriter(targetfile, false, System.Text.Encoding.UTF8);
            XslTransform trans = new XslTransform();
            XmlUrlResolver resolver = new XmlUrlResolver();
            GC.Collect();
            trans.Load(transformDoc, resolver, System.AppDomain.CurrentDomain.Evidence);
            trans.Transform(sourceDoc, args, writer, resolver);
            writer.Flush();
            writer.Close();
        }
        catch (System.Exception e)
        {
            return 0;
        }
        return 1;
    }
}

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Pages

04 Saturday Sep 2010

Posted by Pawan Kumar Khowal in CSS

≈ Leave a comment


<%@ Page Language="C#" MasterPageFile="~/MasterPage_1.master" AutoEventWireup="true"
    CodeFile="InvoicesCreated.aspx.cs" Inherits="InvoiceManagement_InvoicesCreated"
    Title="Invoice Created" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <script language="javascript" type="text/javascript">
            function checkAllBoxer()
            {            
              var totalChkBoxes = parseInt(‘<%= this.gvInvoiceDetails.Rows.Count %>’);  
              var gvControl = document.getElementById(‘<%= this.gvInvoiceDetails.ClientID %>’);
              var gvChkBoxControl = "chkBoxChild"; 
              var mainChkBox = document.getElementById("ctl00_ContentPlaceHolder1_chkBoxAlls");
              var inputTypes = gvControl.getElementsByTagName("input");
              for(var i = 0; i < inputTypes.length; i++)
              {         
                 if(inputTypes[i].type == ‘checkbox’ && inputTypes[i].id.indexOf(gvChkBoxControl,0) >= 0)
                      inputTypes[i].checked = mainChkBox.checked; 
                }
            }
            function getConfirmationForDelete(hdnID)
            {
               var hdn = document.getElementById(hdnID);
               var result = confirm("Are you sure to perform the selected operation? ");
               if (result==true)
               {
                  hdn.value = "OK";
               }
               else
               {
                  hdn.value = "Cancel";
               }
               return true;
           }
    </script>
    <table>
        <tr style="border: 1px #DFDFDF solid;">
            <td class="blackBoldp" style="border: 1px #DFDFDF solid;" colspan="3">
                Invoice Detail
            </td>
            <td style="border: 1px #DFDFDF solid;">
                <asp:Button ID="btnBack" runat="server" Text="Back" CssClass="btn" OnClick="btnBack_Click" />
                <asp:Button ID="btnCreateInvoice" runat="server" Text="Create Invoice" CssClass="btn" OnClick="btnCreateInvoice_Click" />
                <asp:Button ID="btnCreateXml" runat="server" Text="Create XML" CssClass="btn" OnClick="btnCreateXml_Click" />
                <asp:Button ID="btnCreateHTML" runat="server" Text="Create HTML" CssClass="btn" OnClick="btnCreateHTML_Click" />
                <asp:Button ID="btnCancelInvoice" runat="server" Text="Cancel Invoice" CssClass="btn" OnClick="btnCancelInvoice_Click" />
                <asp:Button ID="btnExecuteRun" runat="server" Text="Execute Run" CssClass="btn" OnClick="btnExecuteRun_Click" />
                <asp:Button ID="btnCancelRun" runat="server" Text="Cancel Run" CssClass="btn" OnClick="btnCancelRun_Click" />
            </td>
        </tr>
    </table>
    <br />
    &nbsp;<input id="chkBoxAlls" type="checkbox" onclick="checkAllBoxer()" title="Select" runat="server" />
    <asp:Label ID="Label1" runat="server" Text="SelectAll"></asp:Label>
    <asp:HiddenField ID="hdnFlag" runat="server" />   
    <div id="div" style="background-color: #ffffff; -moz-border-radius: 15px; -webkit-border-radius: 15px;
        border: 1px solid #DFDFDF; padding: 5px;" runat="server">
        <%–/* #eef4fc */–%>
        <asp:Panel ID="Panel8" runat="server" Style="overflow: scroll;" Height="580px" Width="1600px">
            <asp:GridView ID="gvInvoiceDetails" runat="server" AutoGenerateColumns="False" CssClass="tableborder1"
                GridLines="None" ForeColor="Black" ShowFooter="false" OnRowCommand="gvInvoiceDetails_RowCommand">
                <Columns>
                    <asp:TemplateField HeaderText="Select">                       
                        <ItemTemplate>
                            <asp:CheckBox ID="chkBoxChild" runat="server" AutoPostBack="false" />
                        </ItemTemplate>
                        <ItemStyle CssClass="testBox1" />
                        <HeaderStyle CssClass="blackBold" />
                        <FooterStyle CssClass="testBox1" />
                    </asp:TemplateField>
                    <asp:BoundField HeaderText="Bill Run ID" DataField="BillRunId">
                        <FooterStyle CssClass="blackBoldfooter" />
                        <HeaderStyle CssClass="blackBold" />
                        <ItemStyle CssClass="testBox2" />
                        <ControlStyle CssClass="testBox2" />
                    </asp:BoundField>
                    <asp:BoundField HeaderText="Bill Run Detail Id" DataField="BillRunDetailId">
                        <FooterStyle CssClass="blackBoldfooter" />
                        <HeaderStyle CssClass="blackBold" />
                        <ItemStyle CssClass="testBox2" />
                        <ControlStyle CssClass="testBox2" />
                    </asp:BoundField>
                    <asp:BoundField HeaderText="Partner Id" DataField="PartnerId">
                        <FooterStyle CssClass="blackBoldfooter" />
                        <HeaderStyle CssClass="blackBold" />
                        <ItemStyle CssClass="testBox2" />
                        <ControlStyle CssClass="testBox2" />
                    </asp:BoundField>
                    <asp:BoundField HeaderText="Customer Id" DataField="CustomerId">
                        <FooterStyle CssClass="blackBoldfooter" />
                        <HeaderStyle CssClass="blackBold" />
                        <ItemStyle CssClass="testBox2" />
                        <ControlStyle CssClass="testBox2" />
                    </asp:BoundField>
                    <asp:TemplateField HeaderText="InvoiceId">
                        <ItemTemplate>
                            <%–<asp:LinkButton ID="lnkButton" runat="server" OnCommand="GetCustomerdetails">Details</asp:LinkButton>–%>
                            <asp:LinkButton ID="lnkInvoice" runat="server" CommandArgument="<%# Container.DisplayIndex %>"
                                Text='<%# DataBinder.Eval(Container.DataItem, "InvoiceId") %>’ CommandName="InvoiceId" />
                        </ItemTemplate>
                        <FooterStyle CssClass="blackBoldfooter" />
                        <HeaderStyle CssClass="blackBold" />
                        <ItemStyle CssClass="testBox2" />
                    </asp:TemplateField>
                    <asp:BoundField HeaderText="Status" DataField="Status">
                        <HeaderStyle CssClass="blackBold" />
                        <ItemStyle CssClass="testBox2" />
                        <ControlStyle CssClass="testBox2" />
                        <FooterStyle CssClass="blackBoldfooter" />
                    </asp:BoundField>
                    <asp:BoundField HeaderText="Initial Invoice" DataField="InitialInvoice">
                        <HeaderStyle CssClass="blackBold" />
                        <ItemStyle CssClass="testBox2" />
                        <ControlStyle CssClass="testBox2" />
                        <FooterStyle CssClass="blackBoldfooter" />
                    </asp:BoundField>
                </Columns>
                <AlternatingRowStyle CssClass="rowB" />
                <FooterStyle CssClass="blackBoldfooter" BackColor="#E3E4EA" />
                <PagerStyle CssClass="blackBoldfooter" HorizontalAlign="Left" VerticalAlign="Top" />
            </asp:GridView>
        </asp:Panel>
        <asp:Label ID="lblMessage" runat="server" Text="Label"></asp:Label>
    </div>
</asp:Content>

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Styles

04 Saturday Sep 2010

Posted by Pawan Kumar Khowal in CSS

≈ Leave a comment


/* written by Pawankkmr.com */
body{margin:0 0 10px 0; padding:0px; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
 table{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
.table-small{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
.black{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#000000; font-weight:bold; text-decoration:none;}
.red{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#FF0000; text-decoration:none;}
.subblack{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:bold; text-decoration:none;}
.blue{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333087; font-weight:bold; text-decoration:none;}
.blueNormal{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333087; font-weight:normal; text-decoration:none;}
.subblue{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333087; font-weight:bold; text-decoration:none;}
.WhiteNormal{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#ffffff; font-weight:normal; text-decoration:none;}
.WhiteBold{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#ffffff; font-weight:bold; text-decoration:none;}
.blackNormal{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; text-decoration:none;}
.gray{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#666666; font-weight:normal; text-decoration:none;}
.blackBold{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:bold; text-decoration:none;}
.Asskeykey{text-decoration:underline;}
/*links styles*/
.NormalLink:link{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#336699; font-weight:normal; text-decoration:underline;}
.NormalLink:visited{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#336699; font-weight:normal; text-decoration:underline;}
.NormalLink:hover{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#8c80b0; font-weight:normal; text-decoration:none;}
/*links styles*/
/*tab links styles*/
.tabLink:link{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#270f71; font-weight:normal; text-decoration:none;}
.tabLink:visited{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#270f71; font-weight:normal; text-decoration:none;}
.tabLink:hover{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#826ec0; font-weight:normal; text-decoration:none;}
/*tab links styles*/
/*menu styles*/
.menutable{background-color:#7a6da2; height:22px; margin-bottom:2px; border:1px #282828 solid; width:102px;}
.submenutable{ height:22px; margin-bottom:2px; border:1px #cccccc solid;  width:1002px;}
.mainmenu:link{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#ffffff; font-weight:normal; text-decoration:none; }
.mainmenu:visited{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#ffffff; font-weight:normal; text-decoration:none;}
.mainmenu:hover{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#ffffff; font-weight:normal; text-decoration:underline;}
.submainmenu:link{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
.submainmenu:visited{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
.submainmenu:hover{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#8c80b0; font-weight:normal; text-decoration:underline;}
/*menustyles*/
/*table tr td realted styles*/
/*header table reated styles*/
.table_head{margin:0px 0 0 0px; width:100px;}
.table_head_link{margin:0px 0 0 0px; width:100px;}
.table_head_logo{margin:0px 0 0 0px; width:100px;}
/*header table reated styles*/
.leftpanneltable{border:1px #CCCCCC solid; background:#efefef; margin:10px 2px 0px 11px; width:149px; height:350px;}
.Normaltable{margin:10px 0 0 10px; width:820px;}
.bodytablescroll{overflow:scroll; height:150px; width:800px; margin:0 0 0 10px;}
.tablebodyborder{border:#cccccc solid 1px; border-collapse:collapse; background:#ffffff; vertical-align:middle; margin:0 0 0 0px;   width:800px;}
.table{border:1px #CCCCCC solid; background:#efefef; margin:10px 0 0 10px; width:60$%; padding:3px;}
.tableSmall{border:1px #CCCCCC solid; background:#efefef; margin:10px 0 0 10px; width:792px; padding:3px;}
.tdBottomBorder{border-bottom:#cccccc 1px solid;}
.tableborder{border:#cccccc solid 1px; border-collapse:collapse; background:#ffffff; vertical-align:middle; margin:0 0 0 0;}
.tableborder1{border:#cccccc solid 1px; border-collapse:collapse; background:#ffffff; vertical-align:middle; margin:10px 0 0 10px; width:820px;}
.tableborder1 tr{height:24px;}
.tableborder1 td{padding-left:5px; padding-right:5px;}
.tableborder1 tr.rowB{background:#faf9ff;}
.tableborder2{border:#cccccc solid 1px; border-collapse:collapse; background:#ffffff; vertical-align:middle; margin:0px 0 0 0px; width:793px;}
.tableheader{font-family:Verdana;font-size:11px;font-weight:bold;color:#000000; background:#e4e4e4; border:#cccccc solid 1px; white-space:nowrap; }
.tableheaderadmin{font-family:Verdana;font-size:11px;font-weight:bold;color:#000000; background:#efefef; padding:5px; border:#cccccc solid 1px; border-collapse:collapse; }
.embedlinktable{ margin:10px 0px 0px 10px;}
.innertable table{width:50%;}
.innertable td{width:130px;}
.innertable td.fulllenth{width:50%;}
/*table tr td realted styles*/
/*Left Panal menu style*/
#navlist{margin:0px 0px 0px 0px; padding:0px 0px 0px 0px; list-style: none;}
#navlist li{padding:3px 0 3px 6px;}
#navlist li a:link, #navlist li a:visited{padding-left:8px;background-image: url(../images/arrow.png);background-repeat: no-repeat;background-position:0 .5em; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
#navlist li a:hover{padding-left:8px;background-image: url(../images/arrow.png);background-repeat: no-repeat;background-position:0 .5em; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#6666ff; font-weight:normal; text-decoration:none;}
#leftpannelHarizantal{ width:162px;overflow-x:auto; overflow-y:none;}
/*Left Panal menu styles*/
/*form releated styles*/
form{margin:0px; padding:0px;}
.textarea{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; color:#333333; font-weight:normal; text-decoration:none; height:35px; width:113px; border:1px #7b9ebd solid;}
.textarealarge{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; color:#333333; font-weight:normal; text-decoration:none; height:35px; width:116px; border:1px #7b9ebd solid;}
.textareanote{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; color:#333333; font-weight:normal; text-decoration:none; height:35px; width:500px; border:1px #7b9ebd solid;}
.textBoxFile{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; color:#333333; font-weight:normal; text-decoration:none; height:18px; width:188px; border:1px #7b9ebd solid;}
.testBox{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:116px; border:1px #7b9ebd solid;}
.testBoxlogin{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; color:#333333; font-weight:normal; text-decoration:none; height:13px; border:1px #767086 solid;}
.textBoxdisabled{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:116px; height:13px; background-color: #F7F7F7; border:1px #cccccc solid;}
.listBox{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:120px; height:18px; border:1px #cccccc solid;}
.listBoxDate{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:58px; height:18px; border:1px #cccccc solid;}
.listNumaric{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:55px; height:18px; border:1px #cccccc solid;}
.listBoxDateDisable{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:55px; height:18px; background-color: #F7F7F7; border:1px #cccccc solid;}
.listBoxDisabled{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:120px; height:18px;  background-color: #F7F7F7; border:1px #cccccc solid;}
.listBoxDisableddummy{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:88px; height:18px;  background-color: #F7F7F7; border:1px #cccccc solid;}
.DatetextBox{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#333333; text-decoration:none; width:97px; height:13px; border:1px #7b9ebd solid;}
.DatelistBox{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:97px; height:18px; border:1px #cccccc solid;}
.NumbertextBox{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:35px; height:13px; border:1px #7b9ebd solid;}
#btn{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; color:#242628; font-weight:normal; text-decoration:none; height:22px;}
.cursor{cursor:pointer;}
.paddingRight{padding-right:5px;}
.amount{padding-right:15px;text-align: right;}
#one,#two,#three{visibility:hidden; position: absolute;}
.td {width:30%;}
/*form realated styles*/

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

MainStyle

04 Saturday Sep 2010

Posted by Pawan Kumar Khowal in CSS

≈ Leave a comment


/* written by pawankkmr.com */
/*body{margin:0 0 10px 0; padding:0px; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:Black; font-weight:normal; text-decoration:none;}*/
table{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
table1{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
.table-small{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
.black{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#000000; font-weight:bold; text-decoration:none;}
.red{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#FF0000; text-decoration:none;}
.subblack{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:bold; text-decoration:none;}
.blue{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333087; font-weight:bold; text-decoration:none;}
.blueNormal{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333087; font-weight:normal; text-decoration:none;}
.subblue{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333087; font-weight:bold; text-decoration:none;}
.WhiteNormal{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#ffffff; font-weight:normal; text-decoration:none;}
.WhiteBold{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#ffffff; font-weight:bold; text-decoration:none;}
.blackNormal{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; text-decoration:none;}
.gray{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#000000; font-weight:normal; text-decoration:none;}
.blackBold{background-color: #E3E4EA /*#f6f6f6 -good color */;  text-decoration:none;text-align:left; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:bold;border:1px White solid; padding: 2px;}
.blackBoldfooter{background-color: #E3E4EA /*#f6f6f6 -good color */;  text-decoration:none;text-align:left; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:bold;border:1px White solid; padding: 1px; height:1px;}
.blackBold1{background-color:#eeeeee;  text-decoration:underline;text-align:center; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:bold;border:Outset 2px Gray solid;}
.Asskeykey{text-decoration:underline;}
.blackBoldp{background-color:#DFDFDF;  text-decoration:none;text-align:left; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:bold;border:1px White solid;}
.blackBoldq{background-color:#eeeeee;  text-decoration:none;text-align:left; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:lighter;border:1px White solid;}
.blackBoldq_Center{background-color:#eeeeee;  text-decoration:none;text-align:center; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:lighter;border:1px White solid;}
.blackBold2{background-color:White;  text-decoration:underline;text-align:center; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:bold;border:0px;}
/*links styles*/
/*.NormalLink:link{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#336699; font-weight:normal; text-decoration:underline;}
.NormalLink:visited{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#336699; font-weight:normal; text-decoration:underline;}
.NormalLink:hover
{
 font-family: Verdana, Arial, Helvetica, sans-serif;
 font-size: 11px;
 color: fuchsia;
 font-weight: normal;
 text-decoration: none;
}*/
.forWelcome {Border:none Font-Names:Verdana Font-Size:XX-Small;}
.Welcome {font-size:x-large; font-family: Trebuchet MS; font-variant: normal; color:Black; font-weight:600}
/*links styles*/
/*tab links styles*/
/*.tabLink:link{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#270f71; font-weight:normal; text-decoration:none;}
.tabLink:visited{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#270f71; font-weight:normal; text-decoration:none;}
.tabLink:hover{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#826ec0; font-weight:normal; text-decoration:none;}
/*tab links styles*/
/*menu styles*/
.menutable{background-color:#efefef; height:22px; margin-bottom:2px; border:1px #282828 solid; width:1002px;}
.submenutable{ height:22px; margin-bottom:2px; border:1px #cccccc solid;  width:1002px;}
.mainmenu:link{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#ffffff; font-weight:normal; text-decoration:none; }
.mainmenu:visited{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#ffffff; font-weight:normal; text-decoration:none;}
.mainmenu:hover{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#ffffff; font-weight:normal; text-decoration:underline;}
.submainmenu:link{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
.submainmenu:visited{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
.submainmenu:hover{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#8c80b0; font-weight:normal; text-decoration:underline;}
/*menustyles*/
/*table tr td realted styles*/
/*header table reated styles*/
.table_head{margin:0px 0 0 0px; width:1002px;}
.table_head_link{margin:0px 0 0 0px; width:1002px;}
.table_head_logo{margin:0px 0 0 0px; width:1002px;}
/*header table reated styles*/
.leftpanneltable{border:1px #CCCCCC solid; background:#efefef; margin:10px 2px 0px 11px; width:149px; height:350px;}
.Normaltable{margin:10px 0 0 10px; width:820px;}
.bodytablescroll{overflow:scroll; height:150px; width:800px; margin:0 0 0 10px;}
.tablebodyborder{border:#000000 solid 1px; border-collapse:collapse; background:#ffffff; vertical-align:middle; margin:0 0 0 0px;   width:800px;}
.table{border:1px #999999 solid; margin:0 0 0 0 ; width:820px; padding:3px;}
.table1{border:1px #999999 solid; margin:0 0 0 0 ; width:1150px; padding:3px;}
.tableSmall{border:1px #CCCCCC solid; background:#efefef; margin:10px 0 0 10px; width:792px; padding:3px;}
.tdBottomBorder{border-bottom:#cccccc 1px solid;}
.tableborder{border:#cccccc solid 1px; border-collapse:collapse; background:#ffffff; vertical-align:middle; margin:0 0 0 0;}
.tableborder1{text-align:left; border-collapse:collapse; background:#ffffff; vertical-align:middle; margin:0 0 0 0; width:100%;}
.tableborder1 tr{height:24px;}
.tableborder1 td{padding-left:2px; padding-right:2px;}
.tableborder1 tr.rowB{background:#faf9ff     ;}/*#faf9ff*/
/* Original table border 1
.tableborder1{border:#cccccc solid 1px; border-collapse:collapse; background:#ffffff; vertical-align:middle; margin:10px 0 0 10px; width:100%;}
.tableborder1 tr{height:24px;}
.tableborder1 td{padding-left:5px; padding-right:5px;}
.tableborder1 tr.rowB{background:#faf9ff;}
*/
.tableborder2{border:#cccccc solid 1px; border-collapse:collapse; background:#ffffff; vertical-align:middle; margin:0px 0 0 0px; width:793px;}
.tableheader{font-family:Verdana;font-size:11px;font-weight:bold;color:Gray; background:#e4e4e4; border:#cccccc solid 1px; white-space:nowrap; }
.header
  {
    font-weight:bold;
    position:fixed;  
    border :0px;  
    text-align:left;
    font-weight:bold;
    width:250px;
    height:20px;
    
 }
.tableheaderadmin{font-family:Verdana;font-size:11px;font-weight:bold;color:#000000; background:#efefef; padding:5px; border:#cccccc solid 1px; border-collapse:collapse; }
.embedlinktable{ margin:10px 0px 0px 10px;}
.innertable table{width:100%;}
.innertable td{width:130px;}
.innertable td.fulllenth{width:100%;}
/*table tr td realted styles*/
/*Left Panal menu style*/
#navlist{margin:0px 0px 0px 0px; padding:0px 0px 0px 0px; list-style: none;}
#navlist li{padding:3px 0 3px 6px;}
#navlist li a:link, #navlist li a:visited{padding-left:8px;background-image: url(../images/arrow.png);background-repeat: no-repeat;background-position:0 .5em; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none;}
#navlist li a:hover{padding-left:8px;background-image: url(../images/arrow.png);background-repeat: no-repeat;background-position:0 .5em; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#6666ff; font-weight:normal; text-decoration:none;}
#leftpannelHarizantal{ width:162px;overflow:auto;}
/*Left Panal menu styles*/
/*form releated styles*/
 form{margin:0px; padding:0px;}
.textarea{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:35px; width:113px; border:1px #7b9ebd solid;}
.textarealarge{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:35px; width:116px; border:1px #7b9ebd solid;}
.textareanote{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:35px; width:500px; border:1px #7b9ebd solid;}
.textBoxFile{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:18px; width:188px; border:1px #7b9ebd solid;}
.testBox{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:116px; border:1px #7b9ebd solid;}/*#7b9ebd*/
.testBox1{text-align: left; vertical-align:middle;  font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:Gray; font-weight:normal; text-decoration:none; height:13px; width:50px;  border:1px #eeeeee solid;}
.testBox2{ text-align:left; vertical-align:middle; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:150px;  border:1px #eeeeee solid;}
.testBox11{ text-align:left; vertical-align:middle; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:100px; border:1px #eeeeee solid;}
.testBoxx{ text-align:left; vertical-align:middle; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:250px; border:1px #eeeeee solid;}
.testBox2_Width{ text-align:left; vertical-align:middle; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:150px; border:1px Gray solid;}
.testBox2_Center{ text-align:center; vertical-align:middle; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:50px; border:1px Gray solid;}
.testBox_Height{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:50px; width:125px; border:1px #7b9ebd solid;}
.testBox22{ text-align:left; vertical-align:middle; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:300px; border:1px #eeeeee solid;}
.testBox222{ text-align:left; vertical-align:middle; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:400px; border:1px #eeeeee solid;}
.testBox3{text-align:center; text-align:left ;  vertical-align:middle; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:70px; border:1px #eeeeee solid;}
.testBox3_Center{text-align:center; vertical-align:middle; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:20px; border:1px white solid;}
.testBox4{text-align: center; vertical-align:middle;  font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:Gray; font-weight:normal; text-decoration:none; height:13px; width:90px; border:1px Gray solid;}
.table3{color:#666666; width:100%; border:1px Black solid; vertical-align:top ;text-align:left ; background-color:#EEEEEE;}
.testBox7{ text-align:center; text-align:left ;  vertical-align:middle; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:18px; width:90px; border:1px #eeeeee solid;}
.table4{color:#666666; width:100%; border:1px Gray solid; vertical-align:top ;text-align:left ; background-color:#EEEEEE;  margin:10px 10px 10px 0px ;}
.table5{color:#000000; width:100%; border:1px Gray solid; vertical-align:top ;text-align:left ; background-color:#FFFFFF; }
.testBox9{ text-align:center; text-align:left ;  vertical-align:middle; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; width:70px; border:1px Gray solid;}
.gridItemStyle{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal ;height:13px; border:1px #7b9ebd solid;}
.testBoxlogin{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#333333; font-weight:normal; text-decoration:none; height:13px; border:1px #000000 solid;}
.textBoxdisabled{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:116px; height:13px; background-color: #F7F7F7; border:1px #cccccc solid;}
.listBox{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:120px; height:18px; border:1px #cccccc solid;}
.listBox1{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:70px; height:18px; border:1px #cccccc solid;}
.listBox2{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:70px; height:21px; border:1px #cccccc solid;}
.listBox_Height{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:100px; height:100px; border:1px #cccccc solid;}
.listBoxDate{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:58px; height:18px; border:1px #cccccc solid;}
.listNumaric{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:55px; height:18px; border:1px #cccccc solid;}
.listBoxDateDisable{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:55px; height:18px; background-color: #F7F7F7; border:1px #cccccc solid;}
.listBoxDisabled{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:120px; height:18px;  background-color: #F7F7F7; border:1px #cccccc solid;}
.listBoxDisableddummy{ font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:88px; height:18px;  background-color: #F7F7F7; border:1px #cccccc solid;}
.DatetextBox{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#333333; text-decoration:none; width:97px; height:13px; border:1px #7b9ebd solid;}
.DatelistBox{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:97px; height:18px; border:1px #cccccc solid;}
.NumbertextBox{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border:0px; color:#333333; text-decoration:none; width:35px; height:13px; border:1px #7b9ebd solid;}
.newStyle1
{
 visibility: visible;
 float: none;
 
 padding: 2px; 
 background-position: left;
 background-repeat: repeat; 
 vertical-align :middle;  
 background-color:#FFFFFF;
 color:#C0C0C0;  
 /*width: 100%;
 font-family: Verdana, Arial, Helvetica, sans-serif;
 font-size: 10px;
 font-weight: bold;
 font-style: normal;*/
  
}
.newStyle2 {float:left; padding:0; margin:0;color: #C0C0C0;background: #FFFFFF;width:100%; border:solid 1px #C0C0C0;clear:both;}
 
 /*cursor: crosshair;}*/
.btn{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px; color:#242628; font-weight:normal; text-decoration:none; height:22px;}
.cursor{cursor:pointer;}
.paddingRight{padding-right:5px;}
.amount{padding-right:15px;text-align: right;}
.t{text-align:right}
#one,#two,#three{visibility:hidden; position: absolute;}
/* xp theme */
.ajax__tab_xp .ajax__tab_header {font-family:verdana,tahoma,helvetica;font-size:11px;background:url(<%=WebResource("AjaxControlToolkit.Tabs.tab-line.gif")%>) repeat-x bottom;}
.ajax__tab_xp .ajax__tab_outer {padding-right:4px;background:url(<%=WebResource("AjaxControlToolkit.Tabs.tab-right.gif")%>) no-repeat right;height:21px;}
.ajax__tab_xp .ajax__tab_inner {padding-left:3px;background:url(<%=WebResource("AjaxControlToolkit.Tabs.tab-left.gif")%>) no-repeat;}
.ajax__tab_xp .ajax__tab_tab {height:13px;padding:4px;margin:0;background:url(<%=WebResource("AjaxControlToolkit.Tabs.tab.gif")%>) repeat-x;}
.ajax__tab_xp .ajax__tab_hover .ajax__tab_outer {background:url(<%=WebResource("AjaxControlToolkit.Tabs.tab-hover-right.gif")%>) no-repeat right;}
.ajax__tab_xp .ajax__tab_hover .ajax__tab_inner {background:url(<%=WebResource("AjaxControlToolkit.Tabs.tab-hover-left.gif")%>) no-repeat;}
.ajax__tab_xp .ajax__tab_hover .ajax__tab_tab {background:url(<%=WebResource("AjaxControlToolkit.Tabs.tab-hover.gif")%>) repeat-x;}
.ajax__tab_xp .ajax__tab_active .ajax__tab_outer {background:url(<%=WebResource("AjaxControlToolkit.Tabs.tab-active-right.gif")%>) no-repeat right;}
.ajax__tab_xp .ajax__tab_active .ajax__tab_inner {background:url(<%=WebResource("AjaxControlToolkit.Tabs.tab-active-left.gif")%>) no-repeat;}
.ajax__tab_xp .ajax__tab_active .ajax__tab_tab {background:url(<%=WebResource("AjaxControlToolkit.Tabs.tab-active.gif")%>) repeat-x;}
.ajax__tab_xp .ajax__tab_body {font-family:verdana,tahoma,helvetica;font-size:10pt;border:1px solid #999999;border-top:0;padding:8px;background-color:#ffffff;}
.ContextMenuPanel
{
 border: 1px solid;
 z-index: 500; 
 cursor: default;
 /*padding: 1px 1px 0px 1px;*/
 font-size: 11px;
}
.ContextMenuBreak
{
 margin:1px 1px 1px 32px;
 padding:0;
 height:1px;
 overflow:hidden;
 display:block;
 border-top: 1px solid #C5C5C5; 
}
.ContextMenuItem
{
 margin: 1px 0 1px 0;
 display: block;
 color: #003399;
 text-decoration: none;
 cursor: pointer; 
 padding: 4px 19px 4px 33px;
 white-space: nowrap;
}
.ContextMenuItem-Selected
{
 font-weight: normal;
}
.ContextMenuItem:hover
{
 background-color: #FFE6A0;
 color: #003399;
 border: 1px solid #D2B47A;
 padding: 3px 18px 3px 32px;
}
 
/*Parent SubMenu Table*/
.ParentSubTab{
     background-color:Silver;
     border:outset 2px #efefef;
}
/*Parent SubMenu Td*/
.ParentSubTd{
     padding:2px;
}
/*SubMenu Table*/
.SubTab{
     color:Black;
     cursor:default;
}
/*SubMenu Tr UnOvered*/
.SubTrd{
}
/*SubMenu Tr Overed*/
.SubTre{
 
     color:white;
     background-color:#0A246A;
}
.progress
{
    display: block;
    position: absolute;
    padding: 2px 3px;
}
.container
{
    border: solid 1px #808080;
    border-width: 1px 0px;
}
.header
{
    background: url(img/sprite.png) repeat-x 0px 0px;
    border-color: #808080 #808080 #ccc;
    border-style: solid;
    border-width: 0px 1px 1px;
    padding: 0px 10px;
    color: #000000;
    font-size: 9pt;
    font-weight: bold;
    line-height: 1.9; 
    font-family: arial,helvetica,clean,sans-serif;
}
.body
{
    background-color: #f2f2f2;
    border-color: #808080;
    border-style: solid;
    border-width: 0px 1px;
    padding: 10px;
}

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Default CSS StyleSheet

04 Saturday Sep 2010

Posted by Pawan Kumar Khowal in CSS

≈ Leave a comment


/* Default CSS Stylesheet for a new Web Application project */
a:hover
{
color: Blue;
}
.BodyText
{
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #555555;
}
.WrapperDiv {
width:505px;height:400px;border: 1px solid black;
}
.Small
{
font-size: 11px;
}
.White
{
color: white;
}
.Black
{
color:Black;
}
.DarkColor
{
color: #004566;
}
.H1
{
font-size: 18px;
font-weight: bold;
color: #004566;
}
.H2
{
font-size: 14px;
font-weight: bold;
}

.H3
{
color: #004566;
font-size: 12px;
font-weight: bold;
}
.H4
{
color: #004566;
font-size: 12px;
font-weight: bold;

}
.H6
{
color: #004566;
font-size: 10px;
font-weight: normal;

}

.MenuText
{
font-size:11px;
font-weight: bold;
}
.NoUnderline
{
text-decoration: none;
}
.Warning
{
color: #8c2235;
}
.HiddenText label
{
display:none;
}
/* Styles dealing with HTML elements like drop down lists and textboxes */
.TextBoxText
{
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #004566;
background-color: White;
}
.ButtonText
{
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #004566;
background-color: White;
}
.DropDownListText
{
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #004566;
background-color: White;
}
.CheckBoxListText
{
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #555555;
}
/* Styles dealing with backgrounds and borders */
.DatagridHeader
{
color: #555555;
font-size: 13;
}
.DatagridBody
{
color: #366AB3;
background-color: #EFEFEF;
}
.DatagridBodyAlt
{
color: #366AB3;
background-color: White;
}
.DatagridMouseOver
{
background-color: #DFDFDF;
}
.ContentAlignment
{
width: 100%;
height: 100%;
text-align: left;
}
.labelClock
{
/*font-family: Verdana, Arial, Helvetica, sans-serif; */
font-family: “Lucida Sans Unicode”, sans-serif, Arial, Helvetica;
font-weight:  bold; color: #D0FD78;
font-size: 14.5pt;
vertical-align: middle;
}
.SectionDarkGrey
{
background-color: #999999;
border: 1px white solid;
padding: 10;
}
.SectionDarkGreyNoBorder
{
background-color: #999999;
border: 0px white solid;
padding: 10;
}
.SectionMediumGrey
{
background-color: #DDDDDD;
border: 1px white solid;
padding: 10;
}
.SectionMediumGreyNoBorder
{
background-color: #DDDDDD;
border: 0px white solid;
padding: 10;
}
.SectionLightGrey
{
background-color: #F1F1F1;
border: 1px white solid;
padding: 10;
}
.SectionLightGreyNoBorder
{
background-color: #F1F1F1;
border: 0px white solid;
padding: 10;
}
.SectionLightGreyNoBorderNoPad
{
background-color: #F1F1F1;
border: 0px white solid;
padding: 2;
}
.SectionDarkColor
{
background-color: #B4CCEB;
border: 1px white solid;
padding: 10;
}
.SectionDarkColorNoBorder
{
background-color: #B4CCEB;
border: 0px white solid;
padding: 10;
}
.SectionLightColor
{
background-color: #EEF2F7;
border: 1px white solid;
padding: 10;
}
.SectionLightColorNoBorder
{
background-color: #EEF2F7;
border: 0px white solid;
padding: 10;
}
.SectionClear
{
border: 1px #DDDDDD solid;
padding: 10;
}
.HeaderFooterDark
{
background-color: #B4CCEB;
}
.HeaderFooterLight
{
background-color: #E5EEF9;
}
.HeaderBackground
{
background-color: White;
}
.BodyBackground
{
background-color: #FFFFFF;
}
BODY
{
background-color: #FFFFFF;
margin: 0;
border: 0;
}
.MainBackground
{
margin: 0;
}
.BodyBackgroundAlt
{
background-color: #CCFFFF;
}
.BodyBackgroundAccent
{
}
.SecondaryTabCell
{
background-image: url(../img/subTabBackground.gif);
background-repeat: repeat-x;
height: 20px;
}
.SecondaryTabCellSelected
{
font-style: italic;
font-weight: bold;
}
/* Style Panel Black Simple */
.StyledPanel_TL_BlackSimple
{
background-color: black;
background-image: url(StyledPanel_TL_BlackSimple.gif);
background-repeat: no-repeat;
width: 5px;
height: 5px;
}
.StyledPanel_T_BlackSimple
{
background-color: black;
background-image: url(StyledPanel_T_BlackSimple.gif);
background-repeat: repeat-x;
width: 100%;
height: 5px;
}
.StyledPanel_TR_BlackSimple
{
background-color: black;
background-image: url(StyledPanel_TR_BlackSimple.gif);
background-repeat: no-repeat;
width: 5px;
height: 5px;
}
.StyledPanel_HL_BlackSimple
{
background-color: black;
background-image: url(StyledPanel_HL_BlackSimple.gif);
width: 5px;
}
.StyledPanel_H_BlackSimple
{
background-color: black;
width: 100%;
}
.StyledPanel_HR_BlackSimple
{
background-color: black;
background-image: url(StyledPanel_HR_BlackSimple.gif);
width: 5px;
}
.StyledPanel_L_BlackSimple
{
background-image: url(StyledPanel_L_BlackSimple.gif);
background-repeat: repeat-y;
width: 5px;
height: 100%;
}
.StyledPanel_Content_BlackSimple
{
background-color: white;
color: White;
width: 100%;
}

.StyledPanel_R_BlackSimple
{
background-image: url(StyledPanel_R_BlackSimple.gif);
background-repeat: repeat-y;
width: 5px;
height: 100%;

}

.StyledPanel_BL_BlackSimple
{
background-image: url(StyledPanel_BL_BlackSimple.gif);
width: 5px;
height: 5px;
}
.StyledPanel_B_BlackSimple
{
background-image: url(StyledPanel_B_BlackSimple.gif);
background-repeat: repeat-x;
width: 100%;
height: 5px;
}
.StyledPanel_BR_BlackSimple
{
background-image: url(StyledPanel_BR_BlackSimple.gif);
width: 5px;
height: 5px;
}
.StyledPanel_HeadingText_BlackSimple
{
background-color: black;
padding-left: 10px;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
color: #444;
font-style: italic;
color: White;
}
.btn{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; color:#242628; font-weight:normal; text-decoration:none; height:22px;}

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email
← Older posts

Blog Stats

  • 1,074,528 hits

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,131 other subscribers

Pawan Khowal

502 SQL Puzzles with answers

Achievement - 500 PuzzlesJuly 18, 2018
The big day is here. Finally presented 500+ puzzles for SQL community.

200 SQL Server Puzzle with Answers

The Big DayAugust 19, 2016
The big day is here. Completed 200 SQL Puzzles today

Archives

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Oct    

Top Articles

  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…

Archives

  • October 2020 (29)
  • September 2018 (2)
  • August 2018 (6)
  • July 2018 (25)
  • June 2018 (22)
  • May 2018 (24)
  • April 2018 (33)
  • March 2018 (35)
  • February 2018 (53)
  • January 2018 (48)
  • December 2017 (32)
  • November 2017 (2)
  • October 2017 (20)
  • August 2017 (8)
  • June 2017 (2)
  • March 2017 (1)
  • February 2017 (18)
  • January 2017 (2)
  • December 2016 (5)
  • November 2016 (23)
  • October 2016 (2)
  • September 2016 (14)
  • August 2016 (6)
  • July 2016 (22)
  • June 2016 (27)
  • May 2016 (15)
  • April 2016 (7)
  • March 2016 (5)
  • February 2016 (7)
  • December 2015 (4)
  • October 2015 (23)
  • September 2015 (31)
  • August 2015 (14)
  • July 2015 (16)
  • June 2015 (29)
  • May 2015 (25)
  • April 2015 (44)
  • March 2015 (47)
  • November 2012 (1)
  • July 2012 (8)
  • September 2010 (26)
  • August 2010 (125)
  • July 2010 (2)

Article Categories

  • Analysis Services (6)
    • DAX (6)
  • Data (2)
    • Data warehousing (2)
  • Integration Services (2)
  • Magazines (3)
  • Python (29)
  • Reporting Services (4)
  • SQL SERVER (820)
    • Download SQL Interview Q's (212)
    • SQL Concepts (323)
    • SQL Performance Tuning (155)
    • SQL Puzzles (331)
    • SQL SERVER 2017 Linux (6)
    • SQL Server Interview Questions (308)
    • SQL SERVER Puzzles (332)
    • T SQL Puzzles (547)
    • Tricky SQL Queries (439)
  • UI (30)
    • ASP.NET (5)
    • C# (13)
    • CSS (9)
    • OOPS (3)
  • Uncategorized (5)

Recent Posts

  • Python | The Print and Divide Puzzle October 30, 2020
  • Python | Count consecutive 1’s from a list of 0’s and 1’s October 30, 2020
  • Python | How to convert a number into a list of its digits October 26, 2020
  • Python | Validate an IP Address-IPV6(Internet Protocol version 6) October 26, 2020
  • Python | Print the first non-recurring element in a list October 26, 2020
  • Python | Print the most recurring element in a list October 26, 2020
  • Python | Find the cumulative sum of elements in a list October 26, 2020
  • Python | Check a character is present in a string or not October 26, 2020
  • Python | Check whether a string is palindrome or not October 26, 2020
  • Python | Find the missing number in the array of Ints October 26, 2020
  • Python | How would you delete duplicates in a list October 26, 2020
  • Python | Check whether an array is Monotonic or not October 26, 2020
  • Python | Check whether a number is prime or not October 26, 2020
  • Python | Print list of prime numbers up to a number October 26, 2020
  • Python | Print elements from odd positions in a list October 26, 2020
  • Python | Print positions of a string present in another string October 26, 2020
  • Python | How to sort an array in ascending order October 26, 2020
  • Python | How to reverse an array October 26, 2020
  • Python | Find un-common words from two strings October 26, 2020
  • Python | How to convert a string to a list October 26, 2020
  • Python | Find unique words from a string October 26, 2020
  • Python | Calculate average word length from a string October 26, 2020
  • Python | Find common words from two strings October 26, 2020
  • Python | Find the number of times a substring present in a string October 26, 2020
  • Python | Find maximum value from a list October 26, 2020
  • Python | How to find GCF of two numbers October 26, 2020
  • Python | How to find LCM of two numbers October 26, 2020
  • Python | How to convert a list to a string October 26, 2020
  • Python | Replace NONE by its previous NON None value October 26, 2020
  • Microsoft SQL Server 2019 | Features added to SQL Server on Linux September 26, 2018

Create a website or blog at WordPress.com

  • Follow Following
    • Improving my SQL BI Skills
    • Join 231 other followers
    • Already have a WordPress.com account? Log in now.
    • Improving my SQL BI Skills
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar