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");
}
}
