void AddUpdatePurchase() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbName.Text.Trim())) { ep1.SetError(cmbName, "This field is required."); cmbName.Focus(); return; } if (string.IsNullOrEmpty(txtFinalAmount.Text.Trim())) { ep1.SetError(txtFinalAmount, "This field is required."); txtFinalAmount.Focus(); return; } int T002_PURCHASEID = Datalayer.iT002_PURCHASEID; // int TM01_CUSTOMERID = 0; string T002_NO = "", T002_DETAILS = ""; int T001_ACCOUNTID = 0, T007_PLACE_OF_SUPPLY = 0; decimal T002_TOTAL_AMT = 0, T002_DISCOUNT = 0, T002_TAX1RATE = 0, T002_TAX1AMOUNT = 0, T002_TAX2RATE = 0, T002_TAX2AMOUNT = 0, T002_TAX3RATE = 0, T002_TAX3AMOUNT = 0, T002_NETAMOUNT = 0; DateTime T003_DATE = dtpDate.Value; T002_NO = txtBillNo.Text.Trim(); int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID); int.TryParse(cmbState.SelectedValue.ToString(), out T007_PLACE_OF_SUPPLY); decimal.TryParse(txtTotalAmt.Text.Trim(), out T002_TOTAL_AMT); decimal.TryParse(txtCGST.Text.Trim(), out T002_TAX1RATE); decimal.TryParse(lblCGSTAmount.Text.Trim(), out T002_TAX1AMOUNT); decimal.TryParse(txtSGST.Text.Trim(), out T002_TAX2RATE); decimal.TryParse(lblSGSTAmount.Text.Trim(), out T002_TAX2AMOUNT); decimal.TryParse(txtIGST.Text.Trim(), out T002_TAX3RATE); decimal.TryParse(lblIGSTAmount.Text.Trim(), out T002_TAX3AMOUNT); decimal.TryParse(txtFinalAmount.Text.Trim(), out T002_NETAMOUNT); T002_DETAILS = txtDetails.Text.Trim(); if (T002_PURCHASEID > 0) { int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_DELETE_PURCHASE_ITEM(T002_PURCHASEID, ref Iout); } int?T002_PURCHASEID_out = 0; Cursor.Current = Cursors.WaitCursor; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPDATE_PURCHASE(T002_PURCHASEID, T001_ACCOUNTID, T002_NO, T003_DATE, T002_TOTAL_AMT, T002_DISCOUNT, T002_TAX1RATE, T002_TAX1AMOUNT, T002_TAX2RATE, T002_TAX2AMOUNT, T002_TAX3RATE, T002_TAX3AMOUNT, T002_NETAMOUNT, T002_DETAILS, Datalayer.iT001_COMPANYID, T007_PLACE_OF_SUPPLY, ref T002_PURCHASEID_out); if (T002_PURCHASEID_out > 0) { T002_PURCHASEID = int.Parse(T002_PURCHASEID_out.Value.ToString()); for (int i = 0; i < dgDisplayData.Rows.Count; i++) { if (!string.IsNullOrEmpty(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value))) { int TM01_PRODUCTID = 0; decimal T003_RATE = 0, T003_AMOUNT = 0, T003_QTY = 0; string T003_UNIT = ""; int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value), out TM01_PRODUCTID); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T003_QTY"].Value), out T003_QTY); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T003_RATE"].Value), out T003_RATE); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T003_AMOUNT"].Value), out T003_AMOUNT); T003_UNIT = Convert.ToString(dgDisplayData.Rows[i].Cells["T003_UNIT"].Value); int?T008_SALEITEMID_Out = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPDATE_PURCHASEITEM(0, T002_PURCHASEID, TM01_PRODUCTID, T003_QTY, T003_UNIT, T003_RATE, T003_AMOUNT, 0, Datalayer.iT001_COMPANYID, ref T008_SALEITEMID_Out); } } if (Datalayer.iT002_PURCHASEID == 0) { Datalayer.InsertMessageBox(sPageName); ResteData(); } else { Datalayer.UpdateMessageBox(sPageName); ResteData(); } } else { if (Datalayer.iT002_PURCHASEID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } return; } } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }