Esempio n. 1
0
        public ReportUI(SalesUI frmSales)
        {
            InitializeComponent();

            ds  = new BizCareDataSet();
            rpt = new ReportDocument();
            reportRepository = new ReportRepository();

            this.frmSales = frmSales;
        }
Esempio n. 2
0
    /***********************************Function to Save Sales File into Sql Server 2000 using Bulk Copy Method***********************************/
    public string SaveSales(DataTable dt)
    {
        string lblMessage = "";

        SalesController objCont = new SalesController();
        string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString();

        //try
        //{
        //    string strDelete = "Delete from SalesTemp";
        //    objController.ExecuteQuery(strDelete);

        //    SqlConnection sqlconn = new SqlConnection(sConnectionString);
        //    sqlconn.Open();
        //    SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlconn);
        //    bulkCopy.DestinationTableName = "SalesTemp";
        //    bulkCopy.WriteToServer(dt);
        //}
        //catch
        //{
        //}
        DataTable dtMonthOC = new DataTable();
        string strMonthOCQuery = "select * from MonthOpenClose";
        dtMonthOC = objController.ExecuteQuery(strMonthOCQuery);
        DataView dvMonthOC = new DataView(dtMonthOC);
        DataTable dtFilter = new DataTable();
        string[] strFromSalesMonth = txtSalesFromDate.Text.Trim().Split('/');
        int FromMonth = Convert.ToInt16(strFromSalesMonth[1]);
        //int FromMonth = CalSalesfromDate.SelectedDate.Month;
        dvMonthOC.RowFilter = "MonthID =" + FromMonth;
        dtFilter = dvMonthOC.ToTable();

        if (dtFilter.Rows != null)
        {
            bool OCStatus = Convert.ToBoolean(dtFilter.Rows[0]["Status"]);

            if (OCStatus == false)
            {
                lblMessage = "Month is Closed, Please open month to enter data";
            }
            else
            {
                string[] strToSalesDate = txtSalesToDate.Text.Trim().Split('/');
                //int ToMonth = CalSalestoDate.SelectedDate.Month;
                int ToMonth = Convert.ToInt16(strToSalesDate[1]);
                int rcount = 0;

                foreach (DataRow dr in dt.Rows)
                {

                    int IsModelEx = 1;
                    SalesUI objUI = new SalesUI();
                    try
                    {
                        objUI.Sno = Convert.ToInt32(dr["Sno"]);
                        if (dr["Inv#No"].ToString() == "7253102")
                        {
                            string strTest = "";
                        }
                        objUI.InvoiceNo = Convert.ToInt32(dr["Inv#No"]);
                        //objUI.Date = Convert.ToString(dr["Date"]);

                        string strDate = Convert.ToString(dr["Date"]);
                        if (strDate == "" || strDate == "00.00.0000")
                        {
                            objUI.Date = Convert.ToDateTime("1/1/2001");
                        }
                        else
                        {
                            objUI.Date = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["Date"])));
                        }

                        objUI.Dealer_Code = Convert.ToString(dr["DlrCode"]);
                        objUI.Dealer_Name = Convert.ToString(dr["Dlr Name"]);
                        objUI.Blank = Convert.ToString(dr["F10"]);
                        string strMaterial = dr["F10"].ToString();

                        string strModelQuery = "Select * from ModelMapping where Material='" + strMaterial + "'";
                        DataTable dtModel = objController.ExecuteQuery(strModelQuery);

                        if (dtModel != null)
                        {
                            if (dtModel.Rows.Count > 0)
                            {
                                foreach (DataRow drModel in dtModel.Rows)
                                {
                                    objUI.ModelMappingID = Convert.ToInt32(drModel["ID"].ToString());
                                    IsModelEx = 0;
                                }

                            }

                        }

                        objUI.Model_Code = Convert.ToString(dr["Model Code"]);
                        string strQuantity = Convert.ToString(dr["Qty"]);
                        if (strQuantity == "")
                        {
                            objUI.Quantity = Convert.ToInt32(null);
                        }
                        else
                        {
                            objUI.Quantity = Convert.ToInt32(dr["Qty"]);
                        }

                        string strSaleAmt = dr["Sale Amt"].ToString();
                        if (strSaleAmt == "")
                        {
                            objUI.SalesAmount = Convert.ToDouble(null);
                        }
                        else
                        {
                            objUI.SalesAmount = Convert.ToDouble(dr["Sale Amt"]);
                        }

                        string strDiscount = Convert.ToString(dr["Discount"]);
                        if (strDiscount == "")
                        {
                            objUI.Discount = Convert.ToInt32(null);
                        }
                        else
                        {
                            objUI.Discount = Convert.ToInt32(dr["Discount"]);
                        }

                        string strSPLDIS = Convert.ToString(dr["SPL#DIS"]);
                        if (strSPLDIS == "")
                        {
                            objUI.SPLDIS = Convert.ToDouble(null);
                        }
                        else
                        {
                            objUI.SPLDIS = Convert.ToDouble(dr["SPL#DIS"]);
                        }

                        string strExciseDuty = Convert.ToString(dr["Excise Duty"]);
                        if (strExciseDuty == "")
                        {
                            objUI.ExciseDuty = Convert.ToInt32(null);
                        }
                        else
                        {
                            objUI.ExciseDuty = Convert.ToInt32(dr["Excise Duty"]);
                        }

                        //objUI.Edu_Cess = Convert.ToInt32(dr["Edu# Cess"]);
                        //objUI.HR_ECess = Convert.ToInt32(dr["Hr#ECess"]);

                        string strEdu_Cess = Convert.ToString(dr["Edu# Cess"]);
                        if (strEdu_Cess == "")
                        {
                            objUI.Edu_Cess = Convert.ToInt32(null);
                        }
                        else
                        {
                            objUI.Edu_Cess = Convert.ToInt32(dr["Edu# Cess"]);
                        }

                        string strHRECess = Convert.ToString(dr["Hr#ECess"]);
                        if (strHRECess == "")
                        {
                            objUI.HR_ECess = Convert.ToInt32(null);
                        }
                        else
                        {
                            objUI.HR_ECess = Convert.ToInt32(dr["Hr#ECess"]);
                        }

                        string strLSPD = Convert.ToString(dr["LSPD"]);
                        if (strLSPD == "")
                        {
                            objUI.LSPD = Convert.ToInt32(null);
                        }
                        else
                        {
                            objUI.LSPD = Convert.ToInt32(dr["LSPD"]);
                        }

                        string strMSPSD = Convert.ToString(dr["MSPSD"]);
                        if (strMSPSD == "")
                        {
                            objUI.MSPSD = Convert.ToInt32(null);
                        }
                        else
                        {
                            objUI.MSPSD = Convert.ToInt32(dr["MSPSD"]);
                        }

                        string strDHC = Convert.ToString(dr["DHC"]);
                        if (strDHC == "")
                        {
                            objUI.DHC = Convert.ToInt32(null);
                        }
                        else
                        {
                            objUI.DHC = Convert.ToInt32(dr["DHC"]);
                        }

                        string strTaxable = Convert.ToString(dr["Taxable"]);
                        if (strTaxable == "")
                        {
                            objUI.Taxable = Convert.ToDouble(null);
                        }
                        else
                        {
                            objUI.Taxable = Convert.ToDouble(dr["Taxable"]);
                        }

                        string strCST = Convert.ToString(dr["CST"]);
                        if (strCST == "")
                        {
                            objUI.CST = Convert.ToDouble(null);
                        }
                        else
                        {
                            objUI.CST = Convert.ToDouble(dr["CST"]);
                        }

                        string strLST = Convert.ToString(dr["LST"]);
                        if (strLST == "")
                        {
                            objUI.LST = Convert.ToDouble(null);
                        }
                        else
                        {
                            objUI.LST = Convert.ToDouble(dr["LST"]);
                        }

                        string strSurch = Convert.ToString(dr["Surch"]);
                        if (strSurch == "")
                        {
                            objUI.Surch = Convert.ToInt32(null);
                        }
                        else
                        {
                            objUI.Surch = Convert.ToInt32(dr["Surch"]);
                        }

                        string strDely_Chgs = Convert.ToString(dr["Dely Chgs"]);
                        if (strDely_Chgs == "")
                        {
                            objUI.Dely_Chgs = Convert.ToInt32(null);
                        }
                        else
                        {
                            objUI.Dely_Chgs = Convert.ToInt32(dr["Dely Chgs"]);
                        }

                        string strEntityTot = Convert.ToString(dr["Enty/TOT"]);
                        if (strEntityTot == "")
                        {
                            objUI.EntityTot = Convert.ToDouble(null);
                        }
                        else
                        {
                            objUI.EntityTot = Convert.ToDouble(dr["Enty/TOT"]);
                        }

                        string strFreight = Convert.ToString(dr["Freight"]);
                        if (strFreight == "")
                        {
                            objUI.Freight = Convert.ToDouble(null);
                        }
                        else
                        {
                            objUI.Freight = Convert.ToDouble(dr["Freight"]);
                        }
                        string strNetAmount = Convert.ToString(dr["Net Amount"]);
                        if (strNetAmount == "")
                        {
                            objUI.Net_Amount = Convert.ToDouble(null);
                        }
                        else
                        {
                            objUI.Net_Amount = Convert.ToDouble(dr["Net Amount"]);
                        }

                        string strCost = Convert.ToString(dr["Cost"]);
                        if (strCost == "")
                        {
                            objUI.Cost = Convert.ToInt32(null);
                        }
                        else
                        {
                            objUI.Cost = Convert.ToInt32(dr["Cost"]);
                        }
                        objUI.SOff = Convert.ToString(dr["S#Off"]);
                        //objUI.FromDate = CalSalesfromDate.SelectedDate;
                        //objUI.ToDate = CalSalestoDate.SelectedDate;
                        objUI.FromDate = Convert.ToDateTime(objUtility.ConvertDateTime(txtSalesFromDate.Text.Trim()));
                        objUI.ToDate = Convert.ToDateTime(objUtility.ConvertDateTime(txtSalesToDate.Text.Trim()));

                        if (IsModelEx == 0)
                        {
                            objCont.SaveSales(objUI);
                            rcount++;
                        }
                        else
                        {
                            string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[IsApproved],[FromDate],[ToDate],IsModelEx) ";
                            strQuery += "Values ('" + dr["Sno"].ToString() + "','" + dr["Inv#No"].ToString() + "','" + dr["Date"].ToString() + "','" + dr["DlrCode"].ToString() + "','" + dr["Dlr Name"].ToString() + "','" + dr["F10"].ToString() + "','" + dr["Model Code"].ToString() + "','" + dr["Qty"].ToString() + "','" + dr["Sale Amt"].ToString() + "','" + dr["Discount"].ToString() + "','" + dr["SPL#DIS"].ToString() + "','" + dr["Excise Duty"].ToString() + "','" + dr["Edu# Cess"].ToString() + "','" + dr["Hr#ECess"].ToString() + "','" + dr["LSPD"].ToString() + "','" + dr["MSPSD"].ToString() + "','" + dr["DHC"].ToString() + "','" + dr["Taxable"].ToString() + "','" + dr["CST"].ToString() + "','" + dr["LST"].ToString() + "','" + dr["Surch"].ToString() + "','" + dr["Enty/TOT"].ToString() + "','" + dr["Dely Chgs"].ToString() + "','" + dr["Freight"].ToString() + "','" + dr["Net Amount"].ToString() + "','" + dr["Cost"].ToString() + "','" + dr["S#off"] + "',0,'" + objUtility.ConvertDateTime(txtSalesFromDate.Text.Trim()) + "','" + objUtility.ConvertDateTime(txtSalesToDate.Text.Trim()) + "'," + IsModelEx + ")";
                            objController.ExecuteQuery(strQuery);
                        }

                        lblMessage = "File Sales saved successfully;No of Rows Affected:" + rcount;
                    }
                    catch
                    {
                        lnkSalesException.Visible = true;
                        string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[IsApproved],[FromDate],[ToDate],IsModelEx) ";
                        strQuery += "Values ('" + dr["Sno"].ToString() + "','" + dr["Inv#No"].ToString() + "','" + dr["Date"].ToString() + "','" + dr["DlrCode"].ToString() + "','" + dr["Dlr Name"].ToString() + "','" + dr["F10"].ToString() + "','" + dr["Model Code"].ToString() + "','" + dr["Qty"].ToString() + "','" + dr["Sale Amt"].ToString() + "','" + dr["Discount"].ToString() + "','" + dr["SPL#DIS"].ToString() + "','" + dr["Excise Duty"].ToString() + "','" + dr["Edu# Cess"].ToString() + "','" + dr["Hr#ECess"].ToString() + "','" + dr["LSPD"].ToString() + "','" + dr["MSPSD"].ToString() + "','" + dr["DHC"].ToString() + "','" + dr["Taxable"].ToString() + "','" + dr["CST"].ToString() + "','" + dr["LST"].ToString() + "','" + dr["Surch"].ToString() + "','" + dr["Enty/TOT"].ToString() + "','" + dr["Dely Chgs"].ToString() + "','" + dr["Freight"].ToString() + "','" + dr["Net Amount"].ToString() + "','" + dr["Cost"].ToString() + "','" + dr["S#off"] + "',0,'" + objUtility.ConvertDateTime(txtSalesFromDate.Text.Trim()) + "','" + objUtility.ConvertDateTime(txtSalesToDate.Text.Trim()) + "'," + IsModelEx + ")";
                        objController.ExecuteQuery(strQuery);
                    }

                }

            }
        }
        return lblMessage;
    }
Esempio n. 3
0
    public string SaveSales(DataTable dt)
    {
        string lblMessage = "";

        SalesController objCont = new SalesController();
        string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString();

        int rcount = 0;

        foreach (DataRow dr in dt.Rows)
        {

            int IsModelEx = 1;
            int SalesID = Convert.ToInt32(dr["ID"].ToString());
            SalesUI objUI = new SalesUI();
            try
            {
                objUI.Sno = Convert.ToInt32(dr["Sno"]);
                objUI.InvoiceNo = Convert.ToInt32(dr["Inv#No"]);
                string strDate = Convert.ToString(dr["Date"]);
                if (strDate == "" || strDate == "00.00.0000")
                {
                    objUI.Date = Convert.ToDateTime("1/1/2001");
                }
                else
                {
                    objUI.Date = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["Date"])));
                }

                objUI.Dealer_Code = Convert.ToString(dr["DlrCode"]);
                objUI.Dealer_Name = Convert.ToString(dr["Dlr Name"]);
                objUI.Blank = Convert.ToString(dr["F10"]);
                string strMaterial = dr["F10"].ToString();

                string strModelQuery = "Select * from ModelMapping where Material='" + strMaterial + "'";
                DataTable dtModel = objQueryController.ExecuteQuery(strModelQuery);

                if (dtModel != null)
                {
                    if (dtModel.Rows.Count > 0)
                    {
                        foreach (DataRow drModel in dtModel.Rows)
                        {
                            objUI.ModelMappingID = Convert.ToInt32(drModel["ID"].ToString());
                            IsModelEx = 0;
                        }

                    }

                }

                objUI.Model_Code = Convert.ToString(dr["Model Code"]);
                objUI.Quantity = Convert.ToInt32(dr["Qty"]);
                objUI.SalesAmount = Convert.ToDouble(dr["Sale Amt"]);

                string strDiscount = Convert.ToString(dr["Discount"]);
                if (strDiscount == "")
                {
                    objUI.Discount = Convert.ToInt32(null);
                }
                else
                {
                    objUI.Discount = Convert.ToInt32(dr["Discount"]);
                }

                string strSPLDIS = Convert.ToString(dr["SPL#DIS"]);
                if (strSPLDIS == "")
                {
                    objUI.SPLDIS = Convert.ToDouble(null);
                }
                else
                {
                    objUI.SPLDIS = Convert.ToDouble(dr["SPL#DIS"]);
                }

                string strExciseDuty = Convert.ToString(dr["Excise Duty"]);
                if (strExciseDuty == "")
                {
                    objUI.ExciseDuty = Convert.ToInt32(null);
                }
                else
                {
                    objUI.ExciseDuty = Convert.ToInt32(dr["Excise Duty"]);
                }

                objUI.Edu_Cess = Convert.ToInt32(dr["Edu# Cess"]);
                objUI.HR_ECess = Convert.ToInt32(dr["Hr#ECess"]);

                string strLSPD = Convert.ToString(dr["LSPD"]);
                if (strLSPD == "")
                {
                    objUI.LSPD = Convert.ToInt32(null);
                }
                else
                {
                    objUI.LSPD = Convert.ToInt32(dr["LSPD"]);
                }

                string strMSPSD = Convert.ToString(dr["MSPSD"]);
                if (strMSPSD == "")
                {
                    objUI.MSPSD = Convert.ToInt32(null);
                }
                else
                {
                    objUI.MSPSD = Convert.ToInt32(dr["MSPSD"]);
                }

                string strDHC = Convert.ToString(dr["DHC"]);
                if (strDHC == "")
                {
                    objUI.DHC = Convert.ToInt32(null);
                }
                else
                {
                    objUI.DHC = Convert.ToInt32(dr["DHC"]);
                }

                string strTaxable = Convert.ToString(dr["Taxable"]);
                if (strTaxable == "")
                {
                    objUI.Taxable = Convert.ToDouble(null);
                }
                else
                {
                    objUI.Taxable = Convert.ToDouble(dr["Taxable"]);
                }

                string strCST = Convert.ToString(dr["CST"]);
                if (strCST == "")
                {
                    objUI.CST = Convert.ToDouble(null);
                }
                else
                {
                    objUI.CST = Convert.ToDouble(dr["CST"]);
                }

                string strLST = Convert.ToString(dr["LST"]);
                if (strLST == "")
                {
                    objUI.LST = Convert.ToDouble(null);
                }
                else
                {
                    objUI.LST = Convert.ToDouble(dr["LST"]);
                }

                string strSurch = Convert.ToString(dr["Surch"]);
                if (strSurch == "")
                {
                    objUI.Surch = Convert.ToInt32(null);
                }
                else
                {
                    objUI.Surch = Convert.ToInt32(dr["Surch"]);
                }

                string strDely_Chgs = Convert.ToString(dr["Dely Chgs"]);
                if (strDely_Chgs == "")
                {
                    objUI.Dely_Chgs = Convert.ToInt32(null);
                }
                else
                {
                    objUI.Dely_Chgs = Convert.ToInt32(dr["Dely Chgs"]);
                }

                string strEntityTot = Convert.ToString(dr["Enty/TOT"]);
                if (strEntityTot == "")
                {
                    objUI.EntityTot = Convert.ToInt32(null);
                }
                else
                {
                    objUI.EntityTot = Convert.ToInt32(dr["Enty/TOT"]);
                }

                string strFreight = Convert.ToString(dr["Freight"]);
                if (strFreight == "")
                {
                    objUI.Freight = Convert.ToDouble(null);
                }
                else
                {
                    objUI.Freight = Convert.ToDouble(dr["Freight"]);
                }
                objUI.Net_Amount = Convert.ToDouble(dr["Net Amount"]);
                objUI.Cost = Convert.ToInt32(dr["Cost"]);
                objUI.SOff = Convert.ToString(dr["S#Off"]);
                objUI.FromDate = Convert.ToDateTime(dr["FromDate"].ToString());
                objUI.ToDate = Convert.ToDateTime(dr["ToDate"].ToString());

                if (IsModelEx == 0)
                {
                    objCont.SaveSales(objUI);
                    rcount++;
                }
                else
                {
                    string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[IsApproved],[FromDate],[ToDate],IsModelEx) ";
                    strQuery += "Values ('" + dr["Sno"].ToString() + "','" + dr["Inv#No"].ToString() + "','" + dr["Date"].ToString() + "','" + dr["DlrCode"].ToString() + "','" + dr["Dlr Name"].ToString() + "','" + dr["F10"].ToString() + "','" + dr["Model Code"].ToString() + "','" + dr["Qty"].ToString() + "','" + dr["Sale Amt"].ToString() + "','" + dr["Discount"].ToString() + "','" + dr["SPL#DIS"].ToString() + "','" + dr["Excise Duty"].ToString() + "','" + dr["Edu# Cess"].ToString() + "','" + dr["Hr#ECess"].ToString() + "','" + dr["LSPD"].ToString() + "','" + dr["MSPSD"].ToString() + "','" + dr["DHC"].ToString() + "','" + dr["Taxable"].ToString() + "','" + dr["CST"].ToString() + "','" + dr["LST"].ToString() + "','" + dr["Surch"].ToString() + "','" + dr["Enty/TOT"].ToString() + "','" + dr["Dely Chgs"].ToString() + "','" + dr["Freight"].ToString() + "','" + dr["Net Amount"].ToString() + "','" + dr["Cost"].ToString() + "','" + dr["S#off"] + "',0,'" + dr["FromDate"].ToString() + "','" + dr["ToDate"].ToString() + "'," + IsModelEx + ")";
                    objQueryController.ExecuteQuery(strQuery);
                }

                lblMessage = "File Sales saved successfully;No of Rows Affected:" + rcount;
            }
            catch
            {
                string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[IsApproved],[FromDate],[ToDate],IsModelEx) ";
                strQuery += "Values ('" + dr["Sno"].ToString() + "','" + dr["Inv#No"].ToString() + "','" + dr["Date"].ToString() + "','" + dr["DlrCode"].ToString() + "','" + dr["Dlr Name"].ToString() + "','" + dr["F10"].ToString() + "','" + dr["Model Code"].ToString() + "','" + dr["Qty"].ToString() + "','" + dr["Sale Amt"].ToString() + "','" + dr["Discount"].ToString() + "','" + dr["SPL#DIS"].ToString() + "','" + dr["Excise Duty"].ToString() + "','" + dr["Edu# Cess"].ToString() + "','" + dr["Hr#ECess"].ToString() + "','" + dr["LSPD"].ToString() + "','" + dr["MSPSD"].ToString() + "','" + dr["DHC"].ToString() + "','" + dr["Taxable"].ToString() + "','" + dr["CST"].ToString() + "','" + dr["LST"].ToString() + "','" + dr["Surch"].ToString() + "','" + dr["Enty/TOT"].ToString() + "','" + dr["Dely Chgs"].ToString() + "','" + dr["Freight"].ToString() + "','" + dr["Net Amount"].ToString() + "','" + dr["Cost"].ToString() + "','" + dr["S#off"] + "',0,'" + dr["FromDate"].ToString() + "','" + dr["ToDate"].ToString() + "'," + IsModelEx + ")";
                objQueryController.ExecuteQuery(strQuery);
            }

            string strDeleteQuery = "Delete from SalesTemp where [ID]=" + SalesID;
            objQueryController.ExecuteQuery(strDeleteQuery);

        }

        return lblMessage;
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        SalesController objCont = new SalesController();
        int rcount = 0;
        foreach (GridViewRow gr in grdSalesException.Rows)
        {
            bool Discard = ((CheckBox)gr.FindControl("chkDiscard")).Checked;
            string str = ((HiddenField)gr.FindControl("hdnID")).Value;
            if (Discard == true)
            {
                string strDiscardQuery = "Delete from SalesTemp where ID=" + Convert.ToInt16(str);
                objQueryController.ExecuteQuery(strDiscardQuery);

                string strQuery = "Select * from SalesTemp";
                DataTable dt = new DataTable();
                dt = objQueryController.ExecuteQuery(strQuery);

                grdSalesException.DataSource = dt;
                grdSalesException.DataBind();
            }
            else
            {
                SalesUI objUI = new SalesUI();
                try
                {
                    objUI.Sno = Convert.ToInt16(((TextBox)gr.FindControl("txtSno")).Text);
                    objUI.InvoiceNo = Convert.ToInt32(((TextBox)gr.FindControl("txtInvoiceNo")).Text);
                    //objUI.Date = Convert.ToString(((TextBox)gr.FindControl("txtDate")).Text);
                    string strDate = Convert.ToString(((TextBox)gr.FindControl("txtDate")).Text);
                    if (strDate == "" || strDate == "00.00.0000")
                    {
                        objUI.Date = Convert.ToDateTime("1/1/2001");
                    }
                    else
                    {
                        objUI.Date = Convert.ToDateTime(ConvertDateTime(((TextBox)gr.FindControl("txtDate")).Text));
                    }
                    objUI.Dealer_Code = Convert.ToString(((TextBox)gr.FindControl("txtDealerCode")).Text);
                    objUI.Dealer_Name = Convert.ToString(((TextBox)gr.FindControl("txtDealerName")).Text);
                    objUI.Blank = Convert.ToString(((TextBox)gr.FindControl("txtBlank")).Text);
                    string strMaterial = Convert.ToString(((TextBox)gr.FindControl("txtBlank")).Text);
                    objUI.Model_Code = Convert.ToString(((TextBox)gr.FindControl("txtModelCode")).Text);
                    objUI.Quantity = Convert.ToInt16(((TextBox)gr.FindControl("txtQuantity")).Text);
                    objUI.SalesAmount = Convert.ToDouble(((TextBox)gr.FindControl("txtSalesAmt")).Text);

                    string strDiscount = Convert.ToString(((TextBox)gr.FindControl("txtDiscount")).Text);
                    if (strDiscount == "")
                    {
                        objUI.Discount = Convert.ToInt32(null);
                    }
                    else
                    {
                        objUI.Discount = Convert.ToInt32(((TextBox)gr.FindControl("txtDiscount")).Text);
                    }

                    string strSPLDIS = Convert.ToString(((TextBox)gr.FindControl("txtSPLDIS")).Text);
                    if (strSPLDIS == "")
                    {
                        objUI.SPLDIS = Convert.ToDouble(null);
                    }
                    else
                    {
                        objUI.SPLDIS = Convert.ToDouble(((TextBox)gr.FindControl("txtSPLDIS")).Text);
                    }

                    string strExciseDuty = Convert.ToString(((TextBox)gr.FindControl("txtExciseDuty")).Text);
                    if (strExciseDuty == "")
                    {
                        objUI.ExciseDuty = Convert.ToInt16(null);
                    }
                    else
                    {
                        objUI.ExciseDuty = Convert.ToInt16(((TextBox)gr.FindControl("txtExciseDuty")).Text);
                    }

                    objUI.Edu_Cess = Convert.ToInt16(((TextBox)gr.FindControl("txtEduCess")).Text);
                    objUI.HR_ECess = Convert.ToInt16(((TextBox)gr.FindControl("txtHrECess")).Text);

                    string strLSPD = Convert.ToString(((TextBox)gr.FindControl("txtLSPD")).Text);
                    if (strLSPD == "")
                    {
                        objUI.LSPD = Convert.ToInt16(null);
                    }
                    else
                    {
                        objUI.LSPD = Convert.ToInt16(((TextBox)gr.FindControl("txtLSPD")).Text);
                    }

                    string strMSPSD = Convert.ToString(((TextBox)gr.FindControl("txtMSPSD")).Text);
                    if (strMSPSD == "")
                    {
                        objUI.MSPSD = Convert.ToInt16(null);
                    }
                    else
                    {
                        objUI.MSPSD = Convert.ToInt16(((TextBox)gr.FindControl("txtMSPSD")).Text);
                    }

                    string strDHC = Convert.ToString(((TextBox)gr.FindControl("txtDHC")).Text);
                    if (strDHC == "")
                    {
                        objUI.DHC = Convert.ToInt16(null);
                    }
                    else
                    {
                        objUI.DHC = Convert.ToInt16(((TextBox)gr.FindControl("txtDHC")).Text);
                    }

                    string strTaxable = Convert.ToString(((TextBox)gr.FindControl("txtTaxable")).Text);
                    if (strTaxable == "")
                    {
                        objUI.Taxable = Convert.ToDouble(null);
                    }
                    else
                    {
                        objUI.Taxable = Convert.ToDouble(((TextBox)gr.FindControl("txtTaxable")).Text);
                    }

                    string strCST = Convert.ToString(((TextBox)gr.FindControl("txtCST")).Text);
                    if (strCST == "")
                    {
                        objUI.CST = Convert.ToDouble(null);
                    }
                    else
                    {
                        objUI.CST = Convert.ToDouble(((TextBox)gr.FindControl("txtCST")).Text);
                    }

                    string strLST = Convert.ToString(((TextBox)gr.FindControl("txtLST")).Text);
                    if (strLST == "")
                    {
                        objUI.LST = Convert.ToDouble(null);
                    }
                    else
                    {
                        objUI.LST = Convert.ToDouble(((TextBox)gr.FindControl("txtLST")).Text);
                    }

                    string strSurch = Convert.ToString(((TextBox)gr.FindControl("txtSurch")).Text);
                    if (strSurch == "")
                    {
                        objUI.Surch = Convert.ToInt16(null);
                    }
                    else
                    {
                        objUI.Surch = Convert.ToInt16(((TextBox)gr.FindControl("txtSurch")).Text);
                    }

                    string strDely_Chgs = Convert.ToString(((TextBox)gr.FindControl("txtDelyChgs")).Text);
                    if (strDely_Chgs == "")
                    {
                        objUI.Dely_Chgs = Convert.ToInt16(null);
                    }
                    else
                    {
                        objUI.Dely_Chgs = Convert.ToInt16(((TextBox)gr.FindControl("txtDelyChgs")).Text);
                    }

                    string strEntityTot = Convert.ToString(((TextBox)gr.FindControl("txtEntityTot")).Text);
                    if (strEntityTot == "")
                    {
                        objUI.EntityTot = Convert.ToInt16(null);
                    }
                    else
                    {
                        objUI.EntityTot = Convert.ToInt16(((TextBox)gr.FindControl("txtEntityTot")).Text);
                    }

                    string strFreight = Convert.ToString(((TextBox)gr.FindControl("txtFreight")).Text);
                    if (strFreight == "")
                    {
                        objUI.Freight = Convert.ToDouble(null);
                    }
                    else
                    {
                        objUI.Freight = Convert.ToDouble(((TextBox)gr.FindControl("txtFreight")).Text);
                    }
                    objUI.Net_Amount = Convert.ToDouble(((TextBox)gr.FindControl("txtNetAmt")).Text);
                    objUI.Cost = Convert.ToInt16(((TextBox)gr.FindControl("txtCost")).Text);
                    objUI.SOff = Convert.ToString(((TextBox)gr.FindControl("txtSOff")).Text);
                    objUI.FromDate = Convert.ToDateTime(gr.Cells[27].Text);
                    objUI.ToDate = Convert.ToDateTime(gr.Cells[28].Text);
                    string strModelQuery = "Select * from ModelMapping where Material='" + strMaterial + "'";
                    DataTable dtModel = objQueryController.ExecuteQuery(strModelQuery);
                    if (dtModel != null)
                    {
                        if (dtModel.Rows.Count > 0)
                        {
                            foreach (DataRow drModel in dtModel.Rows)
                            {
                                objUI.ModelMappingID = Convert.ToInt32(drModel["ID"].ToString());
                            }

                            objCont.SaveSales(objUI);
                            rcount++;
                        }
                        else
                        {
                            string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[FromDate],[ToDate])";
                            strQuery += "Values ('" + ((TextBox)gr.FindControl("txtSno")).Text + "','" + ((TextBox)gr.FindControl("txtInvoiceNo")).Text + "','" + ((TextBox)gr.FindControl("txtDate")).Text + "','" + ((TextBox)gr.FindControl("txtDealerCode")).Text + "','" + ((TextBox)gr.FindControl("txtDealerName")).Text + "','" + ((TextBox)gr.FindControl("txtBlank")).Text + "','" + ((TextBox)gr.FindControl("txtModelCode")).Text + "','" + ((TextBox)gr.FindControl("txtQuantity")).Text + "','" + ((TextBox)gr.FindControl("txtSalesAmt")).Text + "','" + ((TextBox)gr.FindControl("txtDiscount")).Text + "','" + ((TextBox)gr.FindControl("txtSPLDIS")).Text + "','" + ((TextBox)gr.FindControl("txtExciseDuty")).Text + "','" + ((TextBox)gr.FindControl("txtEduCess")).Text + "','" + ((TextBox)gr.FindControl("txtHrECess")).Text + "','" + ((TextBox)gr.FindControl("txtLSPD")).Text + "','" + ((TextBox)gr.FindControl("txtMSPSD")).Text + "','" + ((TextBox)gr.FindControl("txtDHC")).Text + "','" + ((TextBox)gr.FindControl("txtTaxable")).Text + "','" + ((TextBox)gr.FindControl("txtCST")).Text + "','" + ((TextBox)gr.FindControl("txtLST")).Text + "','" + ((TextBox)gr.FindControl("txtSurch")).Text + "','" + ((TextBox)gr.FindControl("txtEntityTot")).Text + "','" + ((TextBox)gr.FindControl("txtDelyChgs")).Text + "','" + ((TextBox)gr.FindControl("txtFreight")).Text + "','" + ((TextBox)gr.FindControl("txtNetAmt")).Text + "','" + ((TextBox)gr.FindControl("txtCost")).Text + "','" + ((TextBox)gr.FindControl("txtSOff")).Text + "','" + Convert.ToDateTime(gr.Cells[27].Text) + "','" + Convert.ToDateTime(gr.Cells[28].Text) + "')";
                            objQueryController.ExecuteQuery(strQuery);
                        }

                    }
                    else
                    {
                        string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[FromDate],[ToDate])";
                        strQuery += "Values ('" + ((TextBox)gr.FindControl("txtSno")).Text + "','" + ((TextBox)gr.FindControl("txtInvoiceNo")).Text + "','" + ((TextBox)gr.FindControl("txtDate")).Text + "','" + ((TextBox)gr.FindControl("txtDealerCode")).Text + "','" + ((TextBox)gr.FindControl("txtDealerName")).Text + "','" + ((TextBox)gr.FindControl("txtBlank")).Text + "','" + ((TextBox)gr.FindControl("txtModelCode")).Text + "','" + ((TextBox)gr.FindControl("txtQuantity")).Text + "','" + ((TextBox)gr.FindControl("txtSalesAmt")).Text + "','" + ((TextBox)gr.FindControl("txtDiscount")).Text + "','" + ((TextBox)gr.FindControl("txtSPLDIS")).Text + "','" + ((TextBox)gr.FindControl("txtExciseDuty")).Text + "','" + ((TextBox)gr.FindControl("txtEduCess")).Text + "','" + ((TextBox)gr.FindControl("txtHrECess")).Text + "','" + ((TextBox)gr.FindControl("txtLSPD")).Text + "','" + ((TextBox)gr.FindControl("txtMSPSD")).Text + "','" + ((TextBox)gr.FindControl("txtDHC")).Text + "','" + ((TextBox)gr.FindControl("txtTaxable")).Text + "','" + ((TextBox)gr.FindControl("txtCST")).Text + "','" + ((TextBox)gr.FindControl("txtLST")).Text + "','" + ((TextBox)gr.FindControl("txtSurch")).Text + "','" + ((TextBox)gr.FindControl("txtEntityTot")).Text + "','" + ((TextBox)gr.FindControl("txtDelyChgs")).Text + "','" + ((TextBox)gr.FindControl("txtFreight")).Text + "','" + ((TextBox)gr.FindControl("txtNetAmt")).Text + "','" + ((TextBox)gr.FindControl("txtCost")).Text + "','" + ((TextBox)gr.FindControl("txtSOff")).Text + "','" + Convert.ToDateTime(gr.Cells[27].Text) + "','" + Convert.ToDateTime(gr.Cells[28].Text) + "')";
                        objQueryController.ExecuteQuery(strQuery);
                    }

                }
                catch
                {
                    string strQuery = "Insert into SalesTemp ([Sno],[Inv#No],[Date],[DlrCode],[Dlr Name],[F10],[Model Code],[Qty],[Sale Amt],[Discount],[SPL#DIS],[Excise Duty],[Edu# Cess],[Hr#ECess],[LSPD],[MSPSD],[DHC],[Taxable],[CST],[LST],[Surch],[Enty/TOT],[Dely Chgs],[Freight],[Net Amount],[Cost],[S#off],[FromDate],[ToDate])";
                    strQuery += "Values ('" + ((TextBox)gr.FindControl("txtSno")).Text + "','" + ((TextBox)gr.FindControl("txtInvoiceNo")).Text + "','" + ((TextBox)gr.FindControl("txtDate")).Text + "','" + ((TextBox)gr.FindControl("txtDealerCode")).Text + "','" + ((TextBox)gr.FindControl("txtDealerName")).Text + "','" + ((TextBox)gr.FindControl("txtBlank")).Text + "','" + ((TextBox)gr.FindControl("txtModelCode")).Text + "','" + ((TextBox)gr.FindControl("txtQuantity")).Text + "','" + ((TextBox)gr.FindControl("txtSalesAmt")).Text + "','" + ((TextBox)gr.FindControl("txtDiscount")).Text + "','" + ((TextBox)gr.FindControl("txtSPLDIS")).Text + "','" + ((TextBox)gr.FindControl("txtExciseDuty")).Text + "','" + ((TextBox)gr.FindControl("txtEduCess")).Text + "','" + ((TextBox)gr.FindControl("txtHrECess")).Text + "','" + ((TextBox)gr.FindControl("txtLSPD")).Text + "','" + ((TextBox)gr.FindControl("txtMSPSD")).Text + "','" + ((TextBox)gr.FindControl("txtDHC")).Text + "','" + ((TextBox)gr.FindControl("txtTaxable")).Text + "','" + ((TextBox)gr.FindControl("txtCST")).Text + "','" + ((TextBox)gr.FindControl("txtLST")).Text + "','" + ((TextBox)gr.FindControl("txtSurch")).Text + "','" + ((TextBox)gr.FindControl("txtEntityTot")).Text + "','" + ((TextBox)gr.FindControl("txtDelyChgs")).Text + "','" + ((TextBox)gr.FindControl("txtFreight")).Text + "','" + ((TextBox)gr.FindControl("txtNetAmt")).Text + "','" + ((TextBox)gr.FindControl("txtCost")).Text + "','" + ((TextBox)gr.FindControl("txtSOff")).Text + "','" + Convert.ToDateTime(gr.Cells[27].Text) + "','" + Convert.ToDateTime(gr.Cells[28].Text) +"')";
                    objQueryController.ExecuteQuery(strQuery);
                }

                string strDeleteQuery = "Delete from SalesTemp where ID=" + Convert.ToInt16(str);
                objQueryController.ExecuteQuery(strDeleteQuery);

                string strGridQuery = "Select * from SalesTemp";
                DataTable dt = new DataTable();
                dt = objQueryController.ExecuteQuery(strGridQuery);

                grdSalesException.DataSource = dt;
                grdSalesException.DataBind();

            }
        }
    }