private void btnSave_Click(object sender, EventArgs e)
{
string billSno = "";
try
{
if (grdPurchaseBillDetailsDET.Rows.Count == 0)
{
MessageBox.Show("Please Add Details");
}
if (CheckRequiredField(ddlPurchaseAccount))
{
return;
}
using (PurelifeErpClient.PurelifeErpClient purelifeErpClient = new PurelifeErpClient.PurelifeErpClient())
{
#region masters
PurelifeErpClient.MSTPurchaseBillDTO objPurchaseBillDOMST = new PurelifeErpClient.MSTPurchaseBillDTO();
objPurchaseBillDOMST.Id = Code;
objPurchaseBillDOMST.SerialBillNo = billSno;
objPurchaseBillDOMST.Entrydate = txtEntryDate.Text.ToDateTime();
objPurchaseBillDOMST.Entrydate = txtEntryDate.Text.ToDateTime();
objPurchaseBillDOMST.BillNo = txtBillNo.Text.Trim();
objPurchaseBillDOMST.BillDate = txtBillDate.Text.ToDateTime();
objPurchaseBillDOMST.Narration = txtNarration.Text.Trim();
objPurchaseBillDOMST.PurchaseCategy = GetInt(ddlPurchaseCategory.SelectedValue);
objPurchaseBillDOMST.PurchaseType = GetInt(ddlPurchaseType.SelectedValue);
objPurchaseBillDOMST.PurchaseAcc = GetInt(ddlPurchaseAccount.SelectedValue);
objPurchaseBillDOMST.ExciseNo = txtExcise.Text.ToFloat();// Excise Duty against form 'CT1'
objPurchaseBillDOMST.Cess = txtCess.Text.ToFloat();
objPurchaseBillDOMST.HECess = txtHECess.Text.ToFloat();
objPurchaseBillDOMST.AddExcise = ddlAddExcise.SelectedValue.ToString() == "0" ? false : true;
objPurchaseBillDOMST.ExciseReg = txtExciseReg.Text.ToFloat();
//objPurchaseBillDOMST.ExciseNo = txtExciseNo.Text.ToFloat();
objPurchaseBillDOMST.Transport = txtTransport.Text.Trim();
objPurchaseBillDOMST.Carrier = txtCarrier.Text.Trim();
objPurchaseBillDOMST.Remarks = txtRemark.Text.Trim();
objPurchaseBillDOMST.TotalAmount = txtMSTTotalAmount.Text.ToFloat();
objPurchaseBillDOMST.Freightnsurance = txtFrieghtInsurance.Text.Trim();
objPurchaseBillDOMST.PackingForwarding = txtPackingForword.Text.Trim();
objPurchaseBillDOMST.SaleTax = txtSaleTax.Text.ToFloat(); //Sales Tax against form 'H'
objPurchaseBillDOMST.SurchargeTax = txtSurchargeTax.Text.ToFloat();
objPurchaseBillDOMST.BillAmount = txtBillAmount.Text.ToFloat();
objPurchaseBillDOMST.MakeIssueToProductionBill = ddlIssueToProduction.SelectedValue.ToString() == "0" ? false : true;
objPurchaseBillDOMST.Type = 1;//
PurelifeErpClient.ERPDTOBase objERPDOBase = objPurchaseBillDOMST as PurelifeErpClient.ERPDTOBase;
PurelifeErpClient.Result res = purelifeErpClient.Save(PurelifeErpClient.PageName.MSTPurchaseBill, objERPDOBase);
int i = 4 - res.Id.ToString().Length;
string result = new string('0', i);
string prefix = "PB/" + DateTime.Now.Year.ToString().Substring(2) + "-" + DateTime.Now.AddYears(1).Year.ToString().Substring(2) + "/";
billSno = string.Format("{0}{1}{2}", prefix, result, res.Id);
#endregion
#region Details
if (res.Id > 0)
{
for (int sno = 0; sno < grdPurchaseBillDetailsDET.Rows.Count; sno++)
{
PurelifeErpClient.DETPurchaseBillDTO objPurchaseBillDO = new PurelifeErpClient.DETPurchaseBillDTO();
objPurchaseBillDO.Id = res.Id;
objPurchaseBillDO.SNo = grdPurchaseBillDetailsDET.Rows[sno].Cells["SNo"].Value.ToInt();
objPurchaseBillDO.MaterialDesc = grdPurchaseBillDetailsDET.Rows[sno].Cells["ItemId"].Value.ToInt();
objPurchaseBillDO.UMOId = grdPurchaseBillDetailsDET.Rows[sno].Cells["UOMId"].Value.ToInt();
objPurchaseBillDO.Qty = grdPurchaseBillDetailsDET.Rows[sno].Cells["Qty"].Value.ToFloat();
objPurchaseBillDO.Rate = grdPurchaseBillDetailsDET.Rows[sno].Cells["Rate"].Value.ToFloat();
objPurchaseBillDO.TotalAmount = grdPurchaseBillDetailsDET.Rows[sno].Cells["Amount"].Value.ToFloat();
//objPurchaseBillDO.DiscPerc = grdPurchaseBillDetailsDET.Rows[sno].Cells["DiscPerc"].Value.ToFloat();
// objPurchaseBillDO.DicsAmount = grdPurchaseBillDetailsDET.Rows[sno].Cells["DicsAmount"].Value.ToFloat();
// objPurchaseBillDO.ExciseDuty = grdPurchaseBillDetailsDET.Rows[sno].Cells["ExciseDuty"].Value.ToFloat();
//objPurchaseBillDO.ECess = grdPurchaseBillDetailsDET.Rows[sno].Cells["ECess"].Value.ToFloat();
// objPurchaseBillDO.HECessPerc = grdPurchaseBillDetailsDET.Rows[sno].Cells["HECessPerc"].Value.ToFloat();
// objPurchaseBillDO.HECessAmount = grdPurchaseBillDetailsDET.Rows[sno].Cells["HECessAmount"].Value.ToFloat();
// objPurchaseBillDO.InvoiceDate = grdPurchaseBillDetailsDET.Rows[sno].Cells["InvoiceDate"].Value.ToDateTime();
// objPurchaseBillDO.ETADate = grdPurchaseBillDetailsDET.Rows[sno].Cells["ETADate"].Value.ToDateTime();
// objPurchaseBillDO.Specs = grdPurchaseBillDetailsDET.Rows[sno].Cells["Specs"].Value.ToString();
// objPurchaseBillDO.Tariff = grdPurchaseBillDetailsDET.Rows[sno].Cells["Tariff"].Value.ToString();
// objPurchaseBillDO.CVDAmount = grdPurchaseBillDetailsDET.Rows[sno].Cells["CVDAmount"].Value.ToFloat();
// objPurchaseBillDO.TotalAmount = grdPurchaseBillDetailsDET.Rows[sno].Cells["TotalAmount"].Value.ToFloat();
PurelifeErpClient.ERPDTOBase objERPDOBaseDET = objPurchaseBillDO as PurelifeErpClient.ERPDTOBase;
purelifeErpClient.Save(PurelifeErpClient.PageName.DETPurchaseBill, objERPDOBaseDET);
}
}
#endregion
purelifeErpClient.Close();
//txtSerialBillNo.Text = (Convert.ToInt32(txtSerialBillNo.Text + 1)).ToString();
//txtSerialBillNo.Text = (int.Parse(txtSerialBillNo.Text) + 1).ToString();
if (Code > 0)
{
ShowMessage("Updated successfully");
viewForm.BindData();
Close();
}
else
{
ShowMessage(String.Format("Saved successfully, Your Serial No is {0}", billSno));
viewForm.BindData();
ResetMasterControls();
ResetDetailControls();
this.grdPurchaseBillDetailsDET.DataSource = null;
grdPurchaseBillDetailsDET.Rows.Clear();
// SerialBillNo();
//txtSerialBillNo.Text = (int.Parse(txtSerialBillNo.Text) + 1).ToString();
}
}
}
catch (Exception exception)
{
ErrorLog.LogErrorInTxtFormat(exception);
}
}
//private void SetDetailValue(int sno)
//{
// if (sno <= 0 || sno > (grdPurchaseBillDetailsDET.Rows.Count))
// { return; }
// txtDSno.Text = grdPurchaseBillDetailsDET.Rows[sno - 1].Cells["SNO"].Value.ToString();
// txtDItemCode.Text = grdPurchaseBillDetailsDET.Rows[sno - 1].Cells["AliasItemCode"].Value.ToString();
// ddlDItemDesc.SelectedValue = grdPurchaseBillDetailsDET.Rows[sno - 1].Cells["ItemDecsId"].Value.ToString();
// ddlDUMO.SelectedValue = grdPurchaseBillDetailsDET.Rows[sno - 1].Cells["UOMId"].Value.ToString();
// txtDQuantity.Text = grdPurchaseBillDetailsDET.Rows[sno - 1].Cells["Qty"].Value.ToString();
// txtDRate.Text = grdPurchaseBillDetailsDET.Rows[sno - 1].Cells["Rate"].Value.ToString();
// txtDTotalAmt.Text = grdPurchaseBillDetailsDET.Rows[sno - 1].Cells["TotalAmount"].Value.ToString();
//}
private void btnSave_Click_1(object sender, EventArgs e)
{
string billSno = "";
try
{
if (grdPurchaseBillDetailsDET.Rows.Count == 0)
{
MessageBox.Show("Please Add Details ");
}
#region Validation
//if (CheckRequiredField(txtSerialBillNo))
// return;
// if (CheckRequiredField(ddlItemDesc))
//return;
if (CheckRequiredField(ddlPurchaseAccount))
{
return;
}
//if (CheckRequiredField(ddlPurchaseBill))
//{
// return;
//}
//if (CheckRequiredField(ddlPurchaseType))
//{
// return;
//}
//if (CheckRequiredField(ddlUMO))
//{
// return;
//}
#endregion
if (grdPurchaseBillDetailsDET.Rows.Count == 0)
{
MessageBox.Show("Please add information");
//return;
}
using (PurelifeErpClient.PurelifeErpClient purelifeErpClient = new PurelifeErpClient.PurelifeErpClient())
{
#region masters
PurelifeErpClient.MSTPurchaseBillDTO objPurchaseBillDOMST = new PurelifeErpClient.MSTPurchaseBillDTO();
objPurchaseBillDOMST.Id = Code;
objPurchaseBillDOMST.SerialBillNo = txtSerialBillNo.Text.Trim();
objPurchaseBillDOMST.Entrydate = txtEntryDate.Text.ToDateTime().Date;
objPurchaseBillDOMST.BillNo = txtBillNo.Text.Trim();
objPurchaseBillDOMST.BillDate = txtBillDate.Text.ToDateTime().Date;
//objPurchaseBillDO.Supplier = GetInt(ddlSupplier.SelectedValue);
objPurchaseBillDOMST.Narration = txtNarration.Text.Trim();
objPurchaseBillDOMST.PurchaseCategy = GetInt(ddlPurchaseCategory.SelectedValue);
objPurchaseBillDOMST.PurchaseType = GetInt(ddlPurchaseType.SelectedValue);
objPurchaseBillDOMST.PurchaseAcc = GetInt(ddlPurchaseAccount.SelectedValue);
objPurchaseBillDOMST.TotalAmount = txtTotalAmount.Text.ToFloat();
objPurchaseBillDOMST.Type = 2;
PurelifeErpClient.ERPDTOBase objERPDOBase = objPurchaseBillDOMST as PurelifeErpClient.ERPDTOBase;
PurelifeErpClient.Result res = purelifeErpClient.Save(PurelifeErpClient.PageName.MSTPurchaseBill, objERPDOBase);
int i = 4 - res.Id.ToString().Length;
string result = new string('0', i);
string prefix = "DE/" + DateTime.Now.Year.ToString().Substring(2) + "-" + DateTime.Now.AddYears(1).Year.ToString().Substring(2) + "/";
billSno = string.Format("{0}{1}{2}", prefix, result, res.Id);
#endregion
#region Details
if (res.Id > 0)
{
for (int sno = 0; sno < grdPurchaseBillDetailsDET.Rows.Count; sno++)
{
try
{
PurelifeErpClient.DETPurchaseBillDTO objPurchaseBillDO = new PurelifeErpClient.DETPurchaseBillDTO();
objPurchaseBillDO.Id = res.Id;
objPurchaseBillDO.SNo = grdPurchaseBillDetailsDET.Rows[sno].Cells["SNo"].Value.ToInt();
objPurchaseBillDO.MaterialDesc = grdPurchaseBillDetailsDET.Rows[sno].Cells["ItemId"].Value.ToInt();
objPurchaseBillDO.UMOId = grdPurchaseBillDetailsDET.Rows[sno].Cells["UOMId"].Value.ToInt();
objPurchaseBillDO.Qty = grdPurchaseBillDetailsDET.Rows[sno].Cells["Qty"].Value.ToFloat();
objPurchaseBillDO.Rate = grdPurchaseBillDetailsDET.Rows[sno].Cells["Rate"].Value.ToFloat();
objPurchaseBillDO.TotalAmount = grdPurchaseBillDetailsDET.Rows[sno].Cells["Amount"].Value.ToFloat();
PurelifeErpClient.ERPDTOBase objERPDOBaseDET = objPurchaseBillDO as PurelifeErpClient.ERPDTOBase;
purelifeErpClient.Save(PurelifeErpClient.PageName.DETPurchaseBill, objERPDOBaseDET);
}
catch (Exception ex)
{
ErrorLog.LogErrorInTxtFormat(ex);
}
}
}
#endregion
purelifeErpClient.Close();
if (Code > 0)
{
ShowMessage("Updated successfully");
viewForm.BindData();
Close();
}
else
{
ShowMessage(String.Format("Saved successfully, Your Serial No is {0}", billSno));
// ShowMessage("Saved successfully");
viewForm.BindData();
ResetMasterControls();
ResetDetailControls();
grdPurchaseBillDetailsDET.Rows.Clear();
}
}
}
catch (Exception exception)
{
ErrorLog.LogErrorInTxtFormat(exception);
}
}
