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();
}
{
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