void AddUpateBank()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(cmbEmployee.Text.Trim()))
{
ep1.SetError(cmbEmployee, "Name is Required..");
cmbEmployee.Focus();
return;
}
if (string.IsNullOrEmpty(txtAmount.Text.Trim()))
{
ep1.SetError(txtAmount, "Amount is Required..");
txtAmount.Focus();
return;
}
int T14_WORKERID = 0, TM04_BANKID = 0;
decimal dT14_AMOUNT = 0;
int.TryParse(cmbEmployee.SelectedValue.ToString(), out T14_WORKERID);
decimal.TryParse(txtAmount.Text.Trim(), out dT14_AMOUNT);
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
int?Iout = 0;
MyDa.USP_VP_ADDUPDATE_LOAN(Datalayer.iT15_LOANID, T14_WORKERID, dtpDate.Value, dT14_AMOUNT, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout);
if (Iout > 0)
{
if (Datalayer.iT15_LOANID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
}
else
{
if (Datalayer.iT15_LOANID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpdateParty()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
ep1.SetError(txtName, "Name is Required..");
txtName.Focus();
return;
}
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
decimal T001_OPENINGBAL = 0, T001_DISCOUNT = 0;
decimal.TryParse(txtOpeningBal.Text.Trim(), out T001_OPENINGBAL);
decimal.TryParse(txtDiscount.Text.Trim(), out T001_DISCOUNT);
int TM_STATEID = 0;
int.TryParse(cmbState.SelectedValue.ToString(), out TM_STATEID);
int?Iout = 0;
MyDa.USP_VP_ADDUPDATE_ACCOUNT(Datalayer.iT001_ACCOUNTID, txtName.Text.Trim(), txtContactPerson.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), cmbType.SelectedItem.ToString(), txtCity.Text.Trim(), TM_STATEID, txtMobile1.Text.Trim(), txtMobile2.Text.Trim(), txtPhone.Text.Trim(), txtEmailID.Text.Trim(), T001_OPENINGBAL, txtGSTNo.Text.Trim(), txtTinNo.Text.Trim(), T001_DISCOUNT, Datalayer.iT001_COMPANYID, ref Iout);
if (Iout > 0)
{
if (Datalayer.iT001_ACCOUNTID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
}
else
{
if (Datalayer.iT001_ACCOUNTID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
PopualteData();
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpdateParty()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
ep1.SetError(txtName, "Name is Required..");
txtName.Focus();
return;
}
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
decimal T14_DAY_PRICE = 0, T14_HOURS_PRICE = 0;
decimal.TryParse(txtDayPrice.Text.Trim(), out T14_DAY_PRICE);
decimal.TryParse(txtHoursPrice.Text.Trim(), out T14_HOURS_PRICE);
int?Iout = 0;
MyDa.USP_VP_ADDUPDATE_WORKER(Datalayer.iT14_WORKERID, txtName.Text.Trim(), txtAddress1.Text.Trim(), txtMobile1.Text.Trim(), T14_DAY_PRICE, T14_HOURS_PRICE, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout);
if (Iout > 0)
{
if (Datalayer.iT14_WORKERID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
}
else
{
if (Datalayer.iT14_WORKERID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
PopualteData();
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpdateData()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
ep1.SetError(txtName, "Name is Required..");
txtName.Focus();
return;
}
decimal TM01_TAX_RATE = 0;
decimal.TryParse(txtTaxRate.Text.Trim(), out TM01_TAX_RATE);
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
int?Iout = 0;
MyDa.USP_VP_ADDUPDATE_PRODUCT(Datalayer.iTM01_PRODUCTID, txtNo.Text.Trim(), txtName.Text.Trim(), chkIsSet.Checked, txtHSNCode.Text.Trim(), TM01_TAX_RATE, Datalayer.iT001_COMPANYID, ref Iout);
if (Iout > 0)
{
if (Datalayer.iTM01_PRODUCTID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
}
else
{
if (Datalayer.iTM01_PRODUCTID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpdateData()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
ep1.SetError(txtName, "Name is Required..");
txtName.Focus();
return;
}
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
int?Iout = 0;
MyDa.USP_VP_ADDUPDATE_EXPENSE(Datalayer.iTM05_EXPENSEID, txtName.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout);
if (Iout > 0)
{
if (Datalayer.iTM05_EXPENSEID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
}
else
{
if (Datalayer.iTM05_EXPENSEID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpateBank()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(txtBank.Text.Trim()))
{
ep1.SetError(txtBank, "Name is Required..");
txtBank.Focus();
return;
}
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
int?Iout = 0;
MyDa.USP_VP_ADDUPDATE_BANK(Datalayer.T010_PACKINGSLIPID, txtBank.Text.Trim(), txtAccount.Text.Trim(), txtIFSC.Text.Trim(), txtBranch.Text.Trim(), txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout);
if (Iout > 0)
{
if (Datalayer.T010_PACKINGSLIPID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
}
else
{
if (Datalayer.T010_PACKINGSLIPID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpdateData()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
ep1.SetError(txtName, "Name is Required..");
txtName.Focus();
return;
}
decimal dTM02_PRICE1 = 0, dTM02_PRICE2 = 0;
decimal.TryParse(txtPrice.Text.Trim(), out dTM02_PRICE1);
int iTM02_PRODUCTSIZEID1 = 0, iTM02_PRODUCTSIZEID2 = 0;
int.TryParse(lblSizeId1.Text.Trim(), out iTM02_PRODUCTSIZEID1);
int.TryParse(lblSizeId2.Text.Trim(), out iTM02_PRODUCTSIZEID2);
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
int?Iout = 0;
MyDa.USP_VP_ADD_PRODUCT(Datalayer.iTM01_PRODUCTID, txtName.Text.Trim(), chkIsSet.Checked, txtHSNCode.Text.Trim(), dTM02_PRICE1, Datalayer.iT001_COMPANYID, ref Iout);
if (Iout > 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
PopualteData();
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpdatePurchase(bool IsPrint, bool IsPackingSlip)
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(cmbName.Text.Trim()))
{
ep1.SetError(cmbName, "This field is required.");
cmbName.Focus();
return;
}
if (string.IsNullOrEmpty(txtNetAmount.Text.Trim()))
{
ep1.SetError(txtNetAmount, "This field is required.");
txtNetAmount.Focus();
return;
}
int T007_SALEID = Datalayer.iT012_CHALLENID;
// int TM01_CUSTOMERID = 0;
string T007_NO = "", T007_DETAILS = "";
int T001_ACCOUNTID = 0;
decimal T007_TOTAL_AMT = 0, T007_DISCOUNT = 0, T007_TAX1RATE = 0, T007_TAX1AMOUNT = 0, T007_TAX2RATE = 0, T007_TAX2AMOUNT = 0, T007_NETAMOUNT = 0, T007_TAX;
DateTime T003_DATE = dtpDate.Value;
// int.TryParse(cmbCustomerName.SelectedValue.ToString(), out TM01_CUSTOMERID);
T007_NO = txtBillNo.Text.Trim();
int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID);
decimal.TryParse(txtTotalAmt.Text.Trim(), out T007_TOTAL_AMT);
decimal.TryParse(txtDiscount.Text.Trim(), out T007_DISCOUNT);
decimal.TryParse(txtTotalTaxAmount.Text.Trim(), out T007_TAX);
decimal.TryParse(txtNetAmount.Text.Trim(), out T007_NETAMOUNT);
T007_DETAILS = txtDetails.Text.Trim();
if (T007_SALEID > 0)
{
int?Iout = 0;
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
MyDa.USP_VP_DELETE_CHALLENITEM(T007_SALEID, ref Iout);
//MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
//string sSql = "DELETE FROM T003_PURCHASEITEM WHERE T002_PURCHASEID =" + T007_SALEID;
//dl.ExecuteMethod(sSql);
}
decimal dT007_PACKING = 0, dT007_FREIGHT = 0, dT007_OTHER_EXPENSE = 0;
decimal.TryParse(txtPacking.Text.Trim(), out dT007_PACKING);
decimal.TryParse(txtFreight.Text.Trim(), out dT007_FREIGHT);
decimal.TryParse(txtExpense.Text.Trim(), out dT007_OTHER_EXPENSE);
int?T007_SALEID_out = 0;
Cursor.Current = Cursors.WaitCursor;
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
MyDa.USP_VP_ADDUPATE_CHALLEN(T007_SALEID, T001_ACCOUNTID, T007_NO, T003_DATE, txtTransport1.Text.Trim(), txtLR1.Text.Trim(), txtTransport2.Text.Trim(), txtLR2.Text.Trim(), T007_TOTAL_AMT, dT007_PACKING, dT007_FREIGHT, dT007_OTHER_EXPENSE, T007_DISCOUNT, T007_TAX, T007_NETAMOUNT, T007_DETAILS, Datalayer.iT001_COMPANYID, ref T007_SALEID_out);
if (T007_SALEID_out > 0)
{
T007_SALEID = int.Parse(T007_SALEID_out.Value.ToString());
int?T002_PURCHASEITEMID_OUT = 0;
for (int i = 0; i < dgDisplayData.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_NAME"].Value)))
{
int TM01_PRODUCTID = 0, TM02_PRODUCTSIZEID = 0, T008_QTY = 0;
decimal T008_RATE = 0, T008_NET_AMOUNT = 0;
int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value), out TM01_PRODUCTID);
int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM02_PRODUCTSIZEID"].Value), out TM02_PRODUCTSIZEID);
int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_QTY"].Value), out T008_QTY);
decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_RATE"].Value), out T008_RATE);
decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_NET_AMOUNT"].Value), out T008_NET_AMOUNT);
decimal T008_TOTAL_AMT = 0, T008_DISCOUNT_PER = 0, T008_DISCOUNT_AMT = 0, T008_TAX_RATE = 0, T008_TAX_AMT = 0;
decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_TOTAL_AMT"].Value), out T008_TOTAL_AMT);
decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_DISCOUNT_PER"].Value), out T008_DISCOUNT_PER);
decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_DISCOUNT_AMT"].Value), out T008_DISCOUNT_AMT);
decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_TAX_RATE"].Value), out T008_TAX_RATE);
decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_TAX_AMT"].Value), out T008_TAX_AMT);
int?T008_SALEITEMID_Out = 0;
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
MyDa.USP_VP_ADDUPDATE_CHALLEN_ITEM(0, T007_SALEID, TM01_PRODUCTID, TM02_PRODUCTSIZEID, T008_QTY, T008_RATE, T008_TOTAL_AMT, T008_DISCOUNT_PER, T008_DISCOUNT_AMT, T008_TAX_RATE, T008_TAX_AMT, T008_NET_AMOUNT, Datalayer.iT001_COMPANYID, ref T008_SALEITEMID_Out);
}
}
if (Datalayer.iT012_CHALLENID == 0)
{
Datalayer.InsertMessageBox(sPageName);
ResteData();
if (IsPrint)
{
Datalayer.iPrintableChallenId = T007_SALEID;
frmPrintBill fmPrnt = new frmPrintBill();
fmPrnt.Show();
}
if (IsPackingSlip)
{
DAL dl = new DAL();
DataTable dt = new DataTable();
dt = dl.SelectMethod("exec USP_VP_PRINT_CHALLEN_BILL '" + T007_SALEID + "'");
if (dt.Rows.Count > 0)
{
ReportDocument RptDoc = new ReportDocument();
RptDoc.Load(Application.StartupPath + @"\Report\rptPackingSlipsOnInvoice.rpt");
RptDoc.SetDataSource(dt);
crystalReportViewer1.ReportSource = RptDoc;
crystalReportViewer1.Refresh();
crystalReportViewer1.PrintReport();
//Datalayer.RptReport = RptDoc;
//Datalayer.sReportName = "Packing Slip";
//Report.frmReportViwer fmReport = new Report.frmReportViwer();
//fmReport.Show();
}
else
{
Datalayer.InformationMessageBox("No Record..");
}
}
//DataTable dt = new DataTable();
//dt = dl.SelectMethod("exec USP_VP_GET_FULLSALEBILL '" + T003_SALEID + "'");
//if (dt.Rows.Count > 0)
//{
// ReportDocument RptDoc = new ReportDocument();
// RptDoc.Load(Application.StartupPath + @"\Report\rptRetailInvoice.rpt");
// RptDoc.SetDataSource(dt);
// Datalayer.RptReport = RptDoc;
// Datalayer.sReportName = "Invoice";
// frmReportViewer fmReport = new frmReportViewer();
// fmReport.Show();
//}
}
else
{
Datalayer.UpdateMessageBox(sPageName);
if (IsPrint)
{
Datalayer.iPrintableChallenId = T007_SALEID;
frmPrintBill fmPrnt = new frmPrintBill();
fmPrnt.Show();
}
if (IsPackingSlip)
{
DAL dl = new DAL();
DataTable dt = new DataTable();
dt = dl.SelectMethod("exec USP_VP_PRINT_CHALLEN_BILL '" + T007_SALEID + "'");
if (dt.Rows.Count > 0)
{
ReportDocument RptDoc = new ReportDocument();
RptDoc.Load(Application.StartupPath + @"\Report\rptPackingSlipsOnInvoice.rpt");
RptDoc.SetDataSource(dt);
crystalReportViewer1.ReportSource = RptDoc;
crystalReportViewer1.Refresh();
crystalReportViewer1.PrintReport();
//Datalayer.RptReport = RptDoc;
//Datalayer.sReportName = "Packing Slip";
//Report.frmReportViwer fmReport = new Report.frmReportViwer();
//fmReport.Show();
}
else
{
Datalayer.InformationMessageBox("No Record..");
}
}
}
}
else
{
if (Datalayer.iT012_CHALLENID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
return;
}
ResteData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpdateData()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(cmbItemSetName.Text.Trim()))
{
ep1.SetError(cmbItemSetName, "This field is Required..");
cmbItemSetName.Focus();
return;
}
if (string.IsNullOrEmpty(cmbItemName.Text.Trim()))
{
ep1.SetError(cmbItemName, "This field is Required..");
cmbItemName.Focus();
return;
}
if (string.IsNullOrEmpty(txtQTY.Text.Trim()))
{
ep1.SetError(txtQTY, "This field is Required..");
txtQTY.Focus();
return;
}
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
int?Iout = 0;
int TM01_MAIN_PRODUCTID = 0, TM01_PRODUCTID = 0, TM02_PRODUCTSIZEID = 0, TM02_MAIN_PRODUCTSIZEID = 0;
int.TryParse(cmbItemSetName.SelectedValue.ToString(), out TM01_MAIN_PRODUCTID);
// int.TryParse(cmbMainItemSize.SelectedValue.ToString(), out TM02_MAIN_PRODUCTSIZEID);
int.TryParse(cmbItemName.SelectedValue.ToString(), out TM01_PRODUCTID);
// int.TryParse(cmbItemSize.SelectedValue.ToString(), out TM02_PRODUCTSIZEID);
int TM03_QTY = 0;
int.TryParse(txtQTY.Text.Trim(), out TM03_QTY);
MyDa.USP_VP_ADDUPDATE_PRODUCTITEM(Datalayer.iTM03_PRODUCTITEMID, TM01_MAIN_PRODUCTID, TM01_PRODUCTID, TM03_QTY, Datalayer.iT001_COMPANYID, ref Iout);
if (Iout > 0)
{
if (Datalayer.iTM03_PRODUCTITEMID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
}
else
{
if (Datalayer.iTM03_PRODUCTITEMID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void Save()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(cmbAccount.Text.Trim()))
{
ep1.SetError(cmbAccount, "This field is required.");
cmbAccount.Focus();
return;
}
if (string.IsNullOrEmpty(cmbItemName.Text.Trim()))
{
ep1.SetError(cmbItemName, "This field is required.");
cmbItemName.Focus();
return;
}
if (string.IsNullOrEmpty(cmbMainItemSize.Text.Trim()))
{
ep1.SetError(cmbMainItemSize, "This field is required.");
cmbMainItemSize.Focus();
return;
}
if (string.IsNullOrEmpty(txtQty.Text.Trim()))
{
ep1.SetError(txtQty, "This field is required.");
txtQty.Focus();
return;
}
int T004_ORDERID = 0, T001_ACCOUNTID = 0, TM01_PRODUCTID = 0, TM02_PRODUCTSIZEID = 0, T004_QTY = 0;
string T004_DETAILS = "";
bool T004_IS_URGENT = false;
if (chkIsUrgent.Checked)
{
T004_IS_URGENT = true;
}
int.TryParse(lblId.Text.Trim(), out T004_ORDERID);
int.TryParse(cmbAccount.SelectedValue.ToString(), out T001_ACCOUNTID);
int.TryParse(cmbItemName.SelectedValue.ToString(), out TM01_PRODUCTID);
int.TryParse(cmbMainItemSize.SelectedValue.ToString(), out TM02_PRODUCTSIZEID);
int.TryParse(txtQty.Text.Trim(), out T004_QTY);
T004_DETAILS = txtDetails.Text.Trim();
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
int?T004_ORDERID_out = 0;
MyDa.USP_VP_ADDUPDATE_ORDER(T004_ORDERID, T001_ACCOUNTID, dtpDate.Value, TM01_PRODUCTID, TM02_PRODUCTSIZEID, T004_QTY, T004_IS_URGENT, T004_DETAILS, Datalayer.iT001_COMPANYID, ref T004_ORDERID_out);
if (T004_ORDERID_out > 0)
{
if (T004_ORDERID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
cmbItemName.SelectedIndex = 0;
txtQty.Text = "";
txtDetails.Text = "";
chkIsUrgent.Checked = false;
cmbItemName.Focus();
cmbAccount.SelectedValue = T001_ACCOUNTID;
PopualteData();
}
else
{
if (T004_ORDERID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpdatePackingSlip()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(cmbName.Text.Trim()))
{
ep1.SetError(cmbName, "This field is required.");
cmbName.Focus();
return;
}
if (dgDisplayData.Rows.Count == 0)
{
Datalayer.InformationMessageBox("Record is required..");
}
int T010_PACKINGSLIPID = Datalayer.T010_PACKINGSLIPID;
// int TM01_CUSTOMERID = 0;
string T010_NO = "", T010_TRANSPORT = "", T010_LRNO = "";
int T001_ACCOUNTID = 0;
DateTime T003_DATE = dtpDate.Value;
// int.TryParse(cmbCustomerName.SelectedValue.ToString(), out TM01_CUSTOMERID);
T010_NO = txtBillNo.Text.Trim();
T010_TRANSPORT = txtTransport.Text.Trim();
T010_LRNO = txtLRNo.Text.Trim();
int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID);
if (T010_PACKINGSLIPID > 0)
{
int?iDeletePurchaseItem_out = 0;
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
MyDa.USP_VP_DELETE_ALL_PACKINGSLIPORDER(T010_PACKINGSLIPID, ref iDeletePurchaseItem_out);
}
int?T010_PACKINGSLIPID_out = 0;
Cursor.Current = Cursors.WaitCursor;
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
MyDa.USP_VP_ADDUPDATE_PACKING_SLIP(T010_PACKINGSLIPID, T001_ACCOUNTID, T010_NO, T003_DATE, T010_TRANSPORT, T010_LRNO, Datalayer.iT001_COMPANYID, ref T010_PACKINGSLIPID_out);
if (T010_PACKINGSLIPID_out > 0)
{
T010_PACKINGSLIPID = int.Parse(T010_PACKINGSLIPID_out.Value.ToString());
int? @T011_PACKINGSLIPORDERID_OUT = 0;
for (int i = 0; i < dgDisplayData.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(Convert.ToString(dgDisplayData.Rows[i].Cells["T004_ORDERID"].Value)))
{
int T004_ORDERID = 0, T011_QTY = 0;
int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T004_ORDERID"].Value), out T004_ORDERID);
int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T004_PENDING_QTY"].Value), out T011_QTY);
if (T011_QTY > 0)
{
int?T002_PURCHASEITEMID_Out = 0;
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
MyDa.USP_VP_ADDUPDATE_PACKINGSLIPORDER(0, T010_PACKINGSLIPID, T004_ORDERID, T011_QTY, Datalayer.iT001_COMPANYID, ref T002_PURCHASEITEMID_Out);
}
}
}
if (Datalayer.T010_PACKINGSLIPID == 0)
{
Datalayer.InsertMessageBox(sPageName);
ResteData();
if (Datalayer.ShowQuestMsg("are you sure do you want to print this bill ?"))
{
DAL dl = new DAL();
DataTable dt = new DataTable();
dt = dl.SelectMethod("exec USP_VP_GET_PRINT_PACKING_SLIP_ONID '" + T010_PACKINGSLIPID + "'");
if (dt.Rows.Count > 0)
{
ReportDocument RptDoc = new ReportDocument();
RptDoc.Load(Application.StartupPath + @"\Report\rptPackingSlip.rpt");
RptDoc.SetDataSource(dt);
Datalayer.RptReport = RptDoc;
Datalayer.sReportName = "Packing Slip Bill";
Report.frmReportViwer fmReport = new Report.frmReportViwer();
fmReport.Show();
}
else
{
Datalayer.InformationMessageBox("No Record..");
}
}
//DataTable dt = new DataTable();
//dt = dl.SelectMethod("exec USP_VP_GET_FULLSALEBILL '" + T003_SALEID + "'");
//if (dt.Rows.Count > 0)
//{
// ReportDocument RptDoc = new ReportDocument();
// RptDoc.Load(Application.StartupPath + @"\Report\rptRetailInvoice.rpt");
// RptDoc.SetDataSource(dt);
// Datalayer.RptReport = RptDoc;
// Datalayer.sReportName = "Invoice";
// frmReportViewer fmReport = new frmReportViewer();
// fmReport.Show();
//}
}
else
{
Datalayer.UpdateMessageBox(sPageName);
this.Close();
}
}
else
{
if (Datalayer.T010_PACKINGSLIPID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
return;
}
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpdateData()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(cmbName.Text.Trim()))
{
ep1.SetError(cmbName, "Name is Required..");
cmbName.Focus();
return;
}
if (string.IsNullOrEmpty(txtPrice.Text.Trim()))
{
ep1.SetError(txtPrice, "Price is Required..");
txtPrice.Focus();
return;
}
if (string.IsNullOrEmpty(txtSize.Text.Trim()))
{
ep1.SetError(txtSize, "Size is Required..");
txtSize.Focus();
return;
}
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
int?Iout = 0;
int TM01_PRODUCTID = 0;
int.TryParse(cmbName.SelectedValue.ToString(), out TM01_PRODUCTID);
decimal TM02_PRICE = 0;
decimal.TryParse(txtPrice.Text.Trim(), out TM02_PRICE);
MyDa.USP_VP_ADDUPDATE_PRODUCTSIZE(Datalayer.iTM02_PRODUCTSIZEID, TM01_PRODUCTID, txtSize.Text.Trim(), TM02_PRICE, Datalayer.iT001_COMPANYID, ref Iout);
if (Iout > 0)
{
if (Datalayer.iTM02_PRODUCTSIZEID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
}
else
{
if (Datalayer.iTM02_PRODUCTSIZEID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpateBank()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(cmbName.Text.Trim()))
{
ep1.SetError(cmbName, "Name is Required..");
cmbName.Focus();
return;
}
if (string.IsNullOrEmpty(cmbType.Text.Trim()))
{
ep1.SetError(cmbType, "Type is Required..");
cmbType.Focus();
return;
}
if (string.IsNullOrEmpty(cmbPaymentType.Text.Trim()))
{
ep1.SetError(cmbPaymentType, "Type is Required..");
cmbPaymentType.Focus();
return;
}
if (string.IsNullOrEmpty(txtAmount.Text.Trim()))
{
ep1.SetError(txtAmount, "Amount is Required..");
txtAmount.Focus();
return;
}
int T001_ACCOUNTID = 0, TM04_BANKID = 0, T009_AMOUNT = 0;
string T009_TYPE = cmbType.SelectedItem.ToString();
string T009_PAYMENT_TYPE = cmbPaymentType.SelectedItem.ToString();
int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID);
int.TryParse(Convert.ToString(cmbBank.SelectedValue), out TM04_BANKID);
int.TryParse(txtAmount.Text.Trim(), out T009_AMOUNT);
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
int?Iout = 0;
MyDa.USP_VP_ADDUPDATE_PAYMENT(Datalayer.iT009_PURCHASEPAYMENTID, dtpDate.Value, T001_ACCOUNTID, T009_TYPE, T009_PAYMENT_TYPE, TM04_BANKID, T009_AMOUNT, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout);
if (Iout > 0)
{
if (Datalayer.iT009_PURCHASEPAYMENTID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
}
else
{
if (Datalayer.iT009_PURCHASEPAYMENTID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void AddUpateBank()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(cmbEmployee.Text.Trim()))
{
ep1.SetError(cmbEmployee, "Name is Required..");
cmbEmployee.Focus();
return;
}
if (string.IsNullOrEmpty(txtTotalDay.Text.Trim()))
{
ep1.SetError(txtTotalDay, "Amount is Required..");
txtTotalDay.Focus();
return;
}
decimal dTotal = 0, dDedaction = 0, dSalary = 0, dLoan = 0, dPaid = 0;;
int dTotalDay = 0, dTotalHours = 0;
decimal dDayPrice = 0, dHoursPrice = 0;
int.TryParse(txtTotalDay.Text.Trim(), out dTotalDay);
int.TryParse(txtTotalHours.Text.Trim(), out dTotalHours);
decimal.TryParse(lblDayPrice.Text.Trim(), out dDayPrice);
decimal.TryParse(lblHoursPrice.Text.Trim(), out dHoursPrice);
//decimal.TryParse(txtTotal.Text.Trim(), out dTotal);
// decimal.TryParse(txtTotalDedaction.Text.Trim(), out dDedaction);
decimal.TryParse(txtSalary.Text.Trim(), out dSalary);
decimal.TryParse(lblLoanAmount.Text.Trim(), out dLoan);
//ecimal.TryParse(txtPaidAmt.Text.Trim(), out dPaid);
int T14_WORKERID = 0;
int.TryParse(cmbEmployee.SelectedValue.ToString(), out T14_WORKERID);
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
int?Iout = 0;
MyDa.USP_VP_ADDUPDATES_SALARY(Datalayer.iT16_SALARYID, T14_WORKERID, dtpDate.Value, dTotalDay, dTotalHours, dDayPrice, dHoursPrice, dSalary, dLoan, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout);
if (Iout > 0)
{
if (Datalayer.iT16_SALARYID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
}
else
{
if (Datalayer.iT16_SALARYID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
ResetData();
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
void Save()
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(cmbName.Text.Trim()))
{
ep1.SetError(cmbName, "This field is required.");
cmbName.Focus();
return;
}
if (dgDisplayData.Rows.Count == 0)
{
Datalayer.InformationMessageBox("Record is required.");
return;
}
int T005_STOCKINID = 0, T001_ACCOUNTID = 0;
string T004_DETAILS = "";
T005_STOCKINID = Datalayer.iT005_STOCKINID;
int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID);
T004_DETAILS = txtDetails.Text.Trim();
if (T005_STOCKINID > 0)
{
int?Iout = 0;
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
MyDa.USP_VP_DELETE_STOCK_IN(T005_STOCKINID, ref Iout);
}
int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID);
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
int?T004_ORDERID_out = 0;
Cursor.Current = Cursors.WaitCursor;
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
MyDa.USP_VP_ADDUPDATE_STOCK_MASTER(T005_STOCKINID, dtpDate.Value, T001_ACCOUNTID, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref T004_ORDERID_out);
if (T004_ORDERID_out > 0)
{
T005_STOCKINID = int.Parse(T004_ORDERID_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 T005_WEIGHT = 0, T005_QTY = 0;
string T005_UNIT = "", T005_TYPE = "";
int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value), out TM01_PRODUCTID);
decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T005_QTY"].Value), out T005_QTY);
decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T005_WEIGHT"].Value), out T005_WEIGHT);
T005_UNIT = Convert.ToString(dgDisplayData.Rows[i].Cells["T005_UNIT"].Value);
T005_TYPE = Convert.ToString(dgDisplayData.Rows[i].Cells["T005_TYPE"].Value);
int?T008_SALEITEMID_Out = 0;
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
MyDa.USP_VP_ADDUPDATE_STOCK_IN(0, T005_STOCKINID, TM01_PRODUCTID, T005_QTY, T005_UNIT, T005_TYPE, T005_WEIGHT, Datalayer.iT001_COMPANYID, ref T004_ORDERID_out);
}
}
if (T004_ORDERID_out > 0)
{
if (Datalayer.iT005_STOCKINID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
}
ResetData();
}
else
{
if (Datalayer.iT005_STOCKINID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
}
}
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
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");
}
}
void AddUpdatePurchase(bool IsPrint)
{
try
{
ep1.Clear();
if (string.IsNullOrEmpty(cmbName.Text.Trim()))
{
ep1.SetError(cmbName, "This field is required.");
cmbName.Focus();
return;
}
if (string.IsNullOrEmpty(txtBillNo.Text.Trim()))
{
ep1.SetError(txtBillNo, "This field is required.");
txtBillNo.Focus();
return;
}
if (string.IsNullOrEmpty(cmbShippedTo.Text.Trim()))
{
ep1.SetError(cmbShippedTo, "This field is required.");
cmbShippedTo.Focus();
return;
}
if (string.IsNullOrEmpty(cmbState.Text.Trim()))
{
ep1.SetError(cmbState, "This field is required.");
cmbState.Focus();
return;
}
if (string.IsNullOrEmpty(cmbReverseCharges.Text.Trim()))
{
ep1.SetError(cmbReverseCharges, "This field is required.");
cmbReverseCharges.Focus();
return;
}
if (string.IsNullOrEmpty(txtBillNo.Text.Trim()))
{
ep1.SetError(txtBillNo, "This field is required.");
txtBillNo.Focus();
return;
}
if (string.IsNullOrEmpty(txtNetAmount.Text.Trim()))
{
ep1.SetError(txtNetAmount, "This field is required.");
txtNetAmount.Focus();
return;
}
if (dgDisplayData.Rows.Count == 0)
{
Datalayer.InformationMessageBox("Record is required.");
return;
}
int T007_SALEID = Datalayer.iT007_SALEID;
int T001_ACCOUNTID = 0, T007_SHIPPED_TO_ID = 0, T007_PLACE_OF_SUPPLY = 0;
string T007_TYPE = "", T007_NO = "", T007_TRANSPORT1 = "", T007_LR1 = "", T007_TRANSPORT2 = "", T007_LR2 = "", T007_DETAILS = "", T007_VEHICLE_NO = "", T007_IS_REVERSE_CHARGES = "", T007_E_WAY_BILL = "";
decimal T007_TOTAL_AMT = 0, T007_PACKING = 0, T007_FREIGHT = 0, T007_OTHER_EXPENSE = 0, T007_DISCOUNT = 0, T007_CGST = 0, T007_SGST = 0, T007_IGST = 0, T007_NETAMOUNT = 0, T007_REVERSE_CHARGE = 0;
decimal T007_TAXABLE_AMT = 0;
int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID);
T007_TYPE = cmbInvoiceType.SelectedItem.ToString();
T007_NO = txtBillNo.Text.Trim();
T007_TRANSPORT1 = txtTransport1.Text.Trim();
T007_LR1 = txtLR1.Text.Trim();
T007_TRANSPORT2 = txtTransport2.Text.Trim();
decimal.TryParse(txtTotalAmt.Text.Trim(), out T007_TOTAL_AMT);
decimal.TryParse(txtCGST.Text.Trim(), out T007_CGST);
decimal.TryParse(txtSGST.Text.Trim(), out T007_SGST);
decimal.TryParse(txtIGST.Text.Trim(), out T007_IGST);
decimal.TryParse(txtNetAmount.Text.Trim(), out T007_NETAMOUNT);
decimal.TryParse(txtPacking.Text.Trim(), out T007_PACKING);
decimal.TryParse(txtDiscount.Text.Trim(), out T007_DISCOUNT);
decimal.TryParse(txtTaxableAMT.Text.Trim(), out T007_TAXABLE_AMT);
T007_DETAILS = txtDetails.Text.Trim();
T007_VEHICLE_NO = txtVehicleNo.Text.Trim();
T007_IS_REVERSE_CHARGES = cmbReverseCharges.SelectedItem.ToString();
decimal.TryParse(txtReverseCharges.Text.Trim(), out T007_REVERSE_CHARGE);
T007_E_WAY_BILL = txtEWayBill.Text.Trim();
int.TryParse(cmbShippedTo.SelectedValue.ToString(), out T007_SHIPPED_TO_ID);
int.TryParse(cmbState.SelectedValue.ToString(), out T007_PLACE_OF_SUPPLY);
if (T007_NETAMOUNT <= 250000 && T007_PLACE_OF_SUPPLY == 22 && T007_TYPE == "B2CL")
{
Datalayer.InformationMessageBox("please choose correct place of supply and provide bill value more than 2.5 lakhs");
return;
}
if (T007_TYPE == "B2CS" && T007_PLACE_OF_SUPPLY != 33)
{
Datalayer.InformationMessageBox("please choose correct place of supply.");
return;
}
if (T007_SALEID > 0)
{
int?Iout = 0;
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
MyDa.USP_VP_DELETE_SALEITEM(T007_SALEID, ref Iout);
}
int?T007_SALEID_out = 0;
Cursor.Current = Cursors.WaitCursor;
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
MyDa.USP_VP_ADDUPDATE_SALE(T007_SALEID, T001_ACCOUNTID, T007_TYPE, T007_NO, dtpDate.Value, T007_TRANSPORT1, T007_LR1, T007_TRANSPORT2, T007_LR2, T007_TOTAL_AMT, T007_PACKING, T007_DISCOUNT, T007_TAXABLE_AMT, T007_CGST, T007_SGST, T007_IGST, T007_NETAMOUNT, T007_DETAILS, Datalayer.iT001_COMPANYID, T007_VEHICLE_NO, T007_IS_REVERSE_CHARGES, T007_REVERSE_CHARGE, T007_E_WAY_BILL, T007_SHIPPED_TO_ID, T007_PLACE_OF_SUPPLY, dtpLRDate.Value, txtBillPrefix.Text.Trim(), txtTotalKG.Text.Trim(), ref T007_SALEID_out);
if (T007_SALEID_out > 0)
{
T007_SALEID = int.Parse(T007_SALEID_out.Value.ToString());
int?T002_PURCHASEITEMID_OUT = 0;
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;
int T003_QTY = 0;
string T003_UNIT = "";
int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value), out TM01_PRODUCTID);
int.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_ADDPDATE_SALEITEM(0, T007_SALEID, TM01_PRODUCTID, T003_QTY, T003_RATE, T003_UNIT, T003_AMOUNT, Datalayer.iT001_COMPANYID, ref T008_SALEITEMID_Out);
}
}
if (Datalayer.iT007_SALEID == 0)
{
Datalayer.InsertMessageBox(sPageName);
}
else
{
Datalayer.UpdateMessageBox(sPageName);
Datalayer.iT007_SALEID = T007_SALEID;
}
if (IsPrint)
{
Datalayer.iT007_SALEID = T007_SALEID;
DAL dl = new DAL();
DataTable dt = new DataTable();
dt = dl.SelectMethod("exec USP_VP_PRINT_SALE_BILL '" + Datalayer.iT007_SALEID + "'");
if (dt.Rows.Count > 0)
{
//DataTable dtQTY = new DataTable();
//dtQTY = dl.SelectMethod("SELECT TM01_HSNCODE,SUM(T008_QTY)AS QTY FROM T008_SALEITEM T008 INNER JOIN TM01_PRODUCT TM01 ON TM01.TM01_PRODUCTID = T008.TM01_PRODUCTID WHERE T007_SALEID=" + Datalayer.iT007_SALEID + " GROUP BY TM01.TM01_HSNCODE ");
//if (dtQTY.Rows.Count > 0)
//{
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// if (dtQTY.Rows.Count == 1)
// {
// dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString();
// dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString();
// }
// if (dtQTY.Rows.Count == 2)
// {
// dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString();
// dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString();
// dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[1][0].ToString();
// dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[1][1].ToString();
// }
// if (dtQTY.Rows.Count == 3)
// {
// dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString();
// dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString();
// dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[1][0].ToString();
// dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[1][1].ToString();
// dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[2][0].ToString();
// dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[2][1].ToString();
// }
// }
//}
//dt.Rows[0]["BILLTYPE"] = cmbPrintMode.SelectedItem.ToString(); ;
ReportDocument RptDoc = new ReportDocument();
RptDoc.Load(Application.StartupPath + @"\Report\rptInvoice.rpt");
RptDoc.SetDataSource(dt);
crystalReportViewer1.ReportSource = RptDoc;
crystalReportViewer1.Refresh();
crystalReportViewer1.PrintReport();
//Datalayer.RptReport = RptDoc;
//Datalayer.sReportName = "Invoice Bill";
//Report.frmReportViwer fmReport = new Report.frmReportViwer();
//fmReport.Show();
}
else
{
Datalayer.InformationMessageBox("No Record..");
}
//if (Datalayer.ShowQuestMsg("are you sure do you want to print this bill ?"))
//{
// Datalayer.iPrintableBillId = T007_SALEID;
// frmPrintBill fmPrnt = new frmPrintBill();
// fmPrnt.Show();
//}
}
this.Close();
}
else
{
if (Datalayer.iT007_SALEID == 0)
{
Datalayer.DosenotInsertMessageBox(sPageName);
}
else
{
Datalayer.DosenotUpdateMessageBox(sPageName);
}
return;
}
}
catch (Exception ex)
{
Datalayer.WorningMessageBox(ex.Message.ToString(), "Error");
}
}
