Thursday, 14 August 2014

Save Code for C#.Net

 private void PurInvoiceSave()
        {
            long Pno = int.Parse(cbxID.Text);
            string Pnos = cbxID.Text;
            string mname = cbxMname.Text;
            string sname = cbxSupName.Text;
            string invNo = txtInvoiceNo.Text;
            string invDate = dtpInvDate.Text;
            string EntryDate = txtEntryDate.Text;
            string payDueDate = dtpPayDueDate.Text;
            string Editby = txtEditby.Text;          
            string NOfIt = "0.00";
            string Disc = "0.00";
            string tax = "0.00";
            string Tot = "0.00";
            string BalAmont = "0.00";
            double douNetTot = 0.00;
            double NetTot = 0.00;
            string SnetTot = "0.00";
            string ExtraWh = "0.00";
            string TotClaim =Convert .ToDouble ( txtTotClaim.Text).ToString ("N2");
            int rc = dgvPurchase.Rows.Count - 1;
            if (rc > 0)
            {
                NOfIt = txtNoOfItems.Text;
                tax = txtAgsNetCost.Text;
                Disc = txtDiscoPers.Text;
                Tot = txtInvoiceTotalRs.Text;
                douNetTot = Convert.ToDouble(lblNetInvoice.Text);
                NetTot = douNetTot;
                SnetTot = douNetTot.ToString("N2");
                BalAmont = lblNetInvoice.Text;
                if (txtExtraWh.Text != "" && txtExtraWh .Text !=".")
                {
                    ExtraWh = Convert.ToDouble(txtExtraWh.Text).ToString("N2");
                }
            }
            string  PayDueDte = Convert.ToDateTime(dtpPayDueDate.Text).ToShortDateString();
            string PurDte = txtEntryDate.Text;
            string Totvat = txtTotVatPercent.Text;
            string Totvatamt = txtTotVatAmt.Text;
            string TotDisc = txtTotDiscPer.Text;
            string TotDiscAmt = txttotDiscAmt.Text;
            string TotalQty = txtTotalTotQty.Text;

            string str = "Insert into T_PurInvoice(ID,IDs,Mname,SupName,InvoiceNo,InvDate,PurchaseDate,PaymentDueDate,Editby,NoOfItems,Total,DisCo,Taxes,NetTotal,SNetTotal,ExtraWh,BalAmount,TotDisc,TotDiscAmt,TotVat,TotVatAmt,TotalQty,TotClaim) values('" + Pno + "','" + Pnos + "','" + mname + "','" + sname + "','" + invNo + "','" + invDate + "','" + PurDte + "','" + PayDueDte + "','" + Editby + "','" + NOfIt + "','" + Tot + "','" + Disc + "','" + tax + "','" + NetTot + "','" + SnetTot + "','" + ExtraWh + "','" + BalAmont + "','" + TotDisc + "','" + TotDiscAmt + "','" + Totvat + "','" + Totvatamt + "','" + TotalQty + "','" + TotClaim + "')";

            con = new OleDbConnection(dbCon());
            OleDbCommand cmd = new OleDbCommand(str, con);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }

No comments:

Post a Comment