private void btnCreate_Click(object sender, EventArgs e)
{
try
{
if (txtRefNo.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtRefNo, "Enter reference number.");
txtRefNo.Focus();
panel3.Visible = true;
lblError.Text = "Enter reference number.";
}
else if (txtTotalWeight.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtTotalWeight, "Enter total weight.");
txtTotalWeight.Focus();
panel3.Visible = true;
lblError.Text = "Enter total weight.";
}
else if (txtTotalAmt.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtTotalAmt, "Enter total rate.");
txtTotalAmt.Focus();
panel3.Visible = true;
lblError.Text = "Enter total rate.";
}
else
{
if (btnCreate.Text == "Create")
{
//Save Code
_entities = new KBBQEntities();
tbl_PurchaseMaster purchaseData = new tbl_PurchaseMaster();
purchaseData.refNo = txtRefNo.Text.Trim().ToString();
DateTime date = DateTime.ParseExact(dateToday.Text, "dd-MM-yyyy", null);
purchaseData.date = date;
purchaseData.totalWeight = Convert.ToDecimal(txtTotalWeight.Text);
purchaseData.unit = lblUnit.Text;
purchaseData.totalAmt = Convert.ToDecimal(txtTotalAmt.Text);
purchaseData.remarks = txtRemark.Text.ToString();
purchaseData.createdDate = DateTime.Now;
purchaseData.updateDate = DateTime.Now;
purchaseData.partyName = txtPartyName.Text.Trim().ToString();
_entities.tbl_PurchaseMaster.Add(purchaseData);
_entities.SaveChanges();
//add data to purchase detials
addPurchaseDetailsData();
MessageBox.Show("Record Successfull Saved");
}
else
{
//Update Code
_entities = new KBBQEntities();
var purchaseDataUpdate = _entities.tbl_PurchaseMaster.Where(x => x.pId == passedPid).FirstOrDefault();
purchaseDataUpdate.refNo = txtRefNo.Text.Trim().ToString();
DateTime date = DateTime.ParseExact(dateToday.Text, "dd-MM-yyyy", null);
purchaseDataUpdate.date = Convert.ToDateTime(date);
purchaseDataUpdate.totalWeight = Convert.ToDecimal(txtTotalWeight.Text);
purchaseDataUpdate.unit = lblUnit.Text;
purchaseDataUpdate.totalAmt = Convert.ToDecimal(txtTotalAmt.Text);
purchaseDataUpdate.remarks = txtRemark.Text.ToString();
purchaseDataUpdate.updateDate = DateTime.Now;
purchaseDataUpdate.partyName = txtPartyName.Text.Trim().ToString();
_entities.SaveChanges();
var purchaseDetailsUpdate = _entities.tbl_PurchaseDetails.Where(x => x.purchaseID == passedPid).ToList();
foreach (var item in purchaseDetailsUpdate)
{
_entities.tbl_PurchaseDetails.Remove(item);
_entities.SaveChanges();
}
addPurchaseDetailsData(); //grid data entry in purchse details
//Update transaction
MessageBox.Show("Record Successfull Updated");
}
clear();
clearDetails();
count = 0;
passedPid = 0;
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
try
{
if (txtRefNo.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtRefNo, "Enter reference number.");
txtRefNo.Focus();
panel3.Visible = true;
lblError.Text = "Enter reference number.";
}
else if (txtLedgerName.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtLedgerName, "Enter party name.");
txtLedgerName.Focus();
panel3.Visible = true;
lblError.Text = "Enter party name.";
}
else if (txtTotalWeight.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtTotalWeight, "Enter total weight.");
txtTotalWeight.Focus();
panel3.Visible = true;
lblError.Text = "Enter total weight.";
}
else if (txtTotalMelting.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtTotalMelting, "Enter total melting.");
txtTotalMelting.Focus();
panel3.Visible = true;
lblError.Text = "Enter total melting.";
}
else if (txtTotalPurchMelting.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtTotalPurchMelting, "Enter total purchase melting.");
txtTotalMelting.Focus();
panel3.Visible = true;
lblError.Text = "Enter total purchase melting.";
}
else if (txtTotalFine.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtTotalFine, "Enter total fine.");
txtTotalFine.Focus();
panel3.Visible = true;
lblError.Text = "Enter total fine.";
}
else if (txtTotalAmt.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtTotalAmt, "Enter total rate.");
txtTotalAmt.Focus();
panel3.Visible = true;
lblError.Text = "Enter total rate.";
}
else
{
if (btnCreate.Text == "Create")
{
//Save Code
_entities = new MicroAccountsEntities1();
tbl_PurchaseMaster purchaseData = new tbl_PurchaseMaster();
purchaseData.refNo = txtRefNo.Text.Trim().ToString();
purchaseData.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == txtLedgerName.Text.Trim().ToString()).FirstOrDefault().Id;
DateTime date = DateTime.ParseExact(dateTimePicker1.Text, "dd-MM-yyyy", null);
purchaseData.date = Convert.ToDateTime(date);
purchaseData.totalWeight = Convert.ToDecimal(txtTotalWeight.Text);
purchaseData.unit = lblUnit.Text;
purchaseData.totalMelting = Convert.ToDecimal(txtTotalMelting.Text);
purchaseData.totalMaking = Convert.ToDecimal(txtTotalMaking.Text);
purchaseData.totalPurchaseMelting = Convert.ToDecimal(txtTotalPurchMelting.Text);
purchaseData.totalFine = Convert.ToDecimal(txtTotalFine.Text);
purchaseData.totalAmt = Convert.ToDecimal(txtTotalAmt.Text);
purchaseData.remarks = txtRemark.Text.ToString();
purchaseData.createdDate = DateTime.Now;
purchaseData.updateDate = DateTime.Now;
_entities.tbl_PurchaseMaster.Add(purchaseData);
_entities.SaveChanges();
//add data to purchase detials
addPurchaseDetailsData();
//Add data to transaction table
TransactionEntryClass tcs = new TransactionEntryClass();
tcs.addRecord("Purchase", Convert.ToDecimal(txtTotalAmt.Text), txtLedgerName.Text, "Purchase Account");
MessageBox.Show("Record Successfull Saved");
}
else
{
//Update Code
_entities = new MicroAccountsEntities1();
var purchaseDataUpdate = _entities.tbl_PurchaseMaster.Where(x => x.pId == passedPid).FirstOrDefault();
purchaseDataUpdate.refNo = txtRefNo.Text.Trim().ToString();
purchaseDataUpdate.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == txtLedgerName.Text.Trim().ToString()).FirstOrDefault().Id;
DateTime date = DateTime.ParseExact(dateTimePicker1.Text, "dd-MM-yyyy", null);
purchaseDataUpdate.date = Convert.ToDateTime(date);
purchaseDataUpdate.totalWeight = Convert.ToDecimal(txtTotalWeight.Text);
purchaseDataUpdate.unit = lblUnit.Text;
purchaseDataUpdate.totalMelting = Convert.ToDecimal(txtTotalMelting.Text);
purchaseDataUpdate.totalMaking = Convert.ToDecimal(txtTotalMaking.Text);
purchaseDataUpdate.totalPurchaseMelting = Convert.ToDecimal(txtTotalPurchMelting.Text);
purchaseDataUpdate.totalFine = Convert.ToDecimal(txtTotalFine.Text);
purchaseDataUpdate.totalAmt = Convert.ToDecimal(txtTotalAmt.Text);
purchaseDataUpdate.remarks = txtRemark.Text.ToString();
purchaseDataUpdate.updateDate = DateTime.Now;
_entities.SaveChanges();
var purchaseDetailsUpdate = _entities.tbl_PurchaseDetail.Where(x => x.purchaseID == passedPid).ToList();
foreach (var item in purchaseDetailsUpdate)
{
_entities.tbl_PurchaseDetail.Remove(item);
_entities.SaveChanges();
}
addPurchaseDetailsData(); //grid data entry in purchse details
//Update transaction
TransactionEntryClass tcs = new TransactionEntryClass();
tcs.updateRecord(passedPid, "Purchase", Convert.ToDecimal(txtTotalAmt.Text), txtLedgerName.Text, "Purchase Account");
MessageBox.Show("Record Successfull Updated");
}
clear();
clearDetails();
count = 0;
passedPid = 0;
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
