private void PurDgvintoItemsEntryUpdate()
{
int rc = dgvPurchase.Rows.Count - 1;
if (rc > 0)
{
for (int i = 0; i < rc; i++)
{
// string pno = cbxBillNo.Text;
string itemtype = dgvPurchase[1, i].Value.ToString();
string itname = dgvPurchase[2, i].Value.ToString();
// string product = dgvBilling1[2, i].Value.ToString();
string Batchno = dgvPurchase[3, i].Value.ToString();
string MRP = dgvPurchase[9, i].Value.ToString();
string SellPers = dgvPurchase[17, i].Value.ToString();
string SellAmt = dgvPurchase[19, i].Value.ToString();
double SellMorAmt =Convert .ToDouble ( dgvPurchase[18, i].Value.ToString());
double BasicRate =Convert .ToDouble ( dgvPurchase[12,i].Value.ToString());
double VatPers =Convert .ToDouble ( dgvPurchase[13, i].Value.ToString());
double netcost =Convert.ToDouble ( dgvPurchase[8, i].Value.ToString());
double DiscPers =Convert .ToDouble ( dgvPurchase[10, i].Value.ToString());
double DiscAmt =Convert .ToDouble ( dgvPurchase[11, i].Value.ToString());
double TransPers =Convert .ToDouble ( dgvPurchase[15, i].Value.ToString());
double DummyRate = Convert.ToDouble(dgvPurchase[20, i].Value.ToString());
string TStrength = dgvPurchase[26, i].Value.ToString();
string unitss = dgvPurchase[25, i].Value.ToString();
string maxqty = dgvPurchase[23, i].Value.ToString();
string minqty = dgvPurchase[24, i].Value.ToString();
// To Update Item Master Table
//ID IDs Mname ItemName MRP PurRate PurTax PurTotAmt SalesPers SalesTotAmt SalesMor DiscoPers DiscoAmt TransPers TotQty Units MaxQty MinQty DummyRate
string str = "Update T_ITEMSCOLLECTION Set MRP='"+MRP+"',PurRate='" + BasicRate + "',PurTax='" + VatPers + "',PurTotAmt='" + netcost + "',SalesPers='" + SellPers + "',SalesTotAmt='" + SellAmt + "',SalesMor='" + SellMorAmt + "',DiscoPers='" + DiscPers + "',DiscoAmt='" + DiscAmt + "',TransPers='" + TransPers + "',TotQty='" + TStrength + "',Units='" + unitss + "',MaxQty='" + maxqty + "',MinQty='" + minqty + "',DummyRate='" + DummyRate + "' where Mname='" + itemtype + "' and ItemName='" + itname + "'";// and ItemNo='" + partno + "'";//ID=" + cbxItemId.Text + "";
con = new OleDbConnection(dbCon());
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Purchase Rates Updated", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
{
int rc = dgvPurchase.Rows.Count - 1;
if (rc > 0)
{
for (int i = 0; i < rc; i++)
{
// string pno = cbxBillNo.Text;
string itemtype = dgvPurchase[1, i].Value.ToString();
string itname = dgvPurchase[2, i].Value.ToString();
// string product = dgvBilling1[2, i].Value.ToString();
string Batchno = dgvPurchase[3, i].Value.ToString();
string MRP = dgvPurchase[9, i].Value.ToString();
string SellPers = dgvPurchase[17, i].Value.ToString();
string SellAmt = dgvPurchase[19, i].Value.ToString();
double SellMorAmt =Convert .ToDouble ( dgvPurchase[18, i].Value.ToString());
double BasicRate =Convert .ToDouble ( dgvPurchase[12,i].Value.ToString());
double VatPers =Convert .ToDouble ( dgvPurchase[13, i].Value.ToString());
double netcost =Convert.ToDouble ( dgvPurchase[8, i].Value.ToString());
double DiscPers =Convert .ToDouble ( dgvPurchase[10, i].Value.ToString());
double DiscAmt =Convert .ToDouble ( dgvPurchase[11, i].Value.ToString());
double TransPers =Convert .ToDouble ( dgvPurchase[15, i].Value.ToString());
double DummyRate = Convert.ToDouble(dgvPurchase[20, i].Value.ToString());
string TStrength = dgvPurchase[26, i].Value.ToString();
string unitss = dgvPurchase[25, i].Value.ToString();
string maxqty = dgvPurchase[23, i].Value.ToString();
string minqty = dgvPurchase[24, i].Value.ToString();
// To Update Item Master Table
//ID IDs Mname ItemName MRP PurRate PurTax PurTotAmt SalesPers SalesTotAmt SalesMor DiscoPers DiscoAmt TransPers TotQty Units MaxQty MinQty DummyRate
string str = "Update T_ITEMSCOLLECTION Set MRP='"+MRP+"',PurRate='" + BasicRate + "',PurTax='" + VatPers + "',PurTotAmt='" + netcost + "',SalesPers='" + SellPers + "',SalesTotAmt='" + SellAmt + "',SalesMor='" + SellMorAmt + "',DiscoPers='" + DiscPers + "',DiscoAmt='" + DiscAmt + "',TransPers='" + TransPers + "',TotQty='" + TStrength + "',Units='" + unitss + "',MaxQty='" + maxqty + "',MinQty='" + minqty + "',DummyRate='" + DummyRate + "' where Mname='" + itemtype + "' and ItemName='" + itname + "'";// and ItemNo='" + partno + "'";//ID=" + cbxItemId.Text + "";
con = new OleDbConnection(dbCon());
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Purchase Rates Updated", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
No comments:
Post a Comment