private void btnCreate_Click(object sender, EventArgs e)
{
try
{
if (cmbLedgerDR.Text == string.Empty || cmbLedgerDR.SelectedIndex == 0)
{
errorProvider1.Clear();
errorProvider1.SetError(cmbLedgerDR, "Enter Dr Ledger");
cmbLedgerDR.Focus();
panel3.Visible = true;
lblError.Text = "Enter Dr Ledger.";
}
else if (cmbLedgerCR.Text == string.Empty || cmbLedgerCR.SelectedIndex == 0)
{
errorProvider1.Clear();
errorProvider1.SetError(cmbLedgerCR, "Enter Cr Ledger");
cmbLedgerCR.Focus();
panel3.Visible = true;
lblError.Text = "Enter Cr Ledger.";
}
else if (txtAmt.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtAmt, "Enter amount");
txtAmt.Focus();
panel3.Visible = true;
lblError.Text = "Enter amount.";
}
else
{
if (btnCreate.Text == "Create")
{
//Payment Entries
_entities = new MicroAccountsEntities1();
tbl_Entry pms = new tbl_Entry();
var checkId = _entities.tbl_Entry.OrderByDescending(x => x.voucherRefNo).FirstOrDefault();
if (checkId == null)
{
pms.voucherRefNo = 1;
}
else
{
pms.voucherRefNo = (checkId.voucherRefNo) + 1;
}
//Condition to set the entry type
if (passedVoucherType == 1) //Payment
{
pms.entryType = 1;
}
else if (passedVoucherType == 2) //Receipt
{
pms.entryType = 2;
}
else if (passedVoucherType == 3) //Journal
{
pms.entryType = 3;
}
else //Contra
{
pms.entryType = 4;
}
pms.crId = _entities.tbl_AccLedger.Where(x => x.ledgerName == cmbLedgerCR.Text).FirstOrDefault().Id;
pms.drId = _entities.tbl_AccLedger.Where(x => x.ledgerName == cmbLedgerDR.Text).FirstOrDefault().Id;
pms.date = DateTime.Now.Date;
pms.amt = Convert.ToDecimal(txtAmt.Text);
pms.stringDate = dateTimePicker1.Text.ToString();
pms.createdDate = DateTime.Now;
pms.updatedDate = DateTime.Now;
_entities.tbl_Entry.Add(pms);
_entities.SaveChanges();
TransactionEntryClass tcs = new TransactionEntryClass();
string transType = "";
if (passedVoucherType == 1)
{
transType = "Payment";
}
else if (passedVoucherType == 2)
{
transType = "Receipt";
}
else if (passedVoucherType == 3)
{
transType = "Journal";
}
else if (passedVoucherType == 4)
{
transType = "Contra";
}
tcs.addRecord(transType, Convert.ToDecimal(txtAmt.Text), cmbLedgerCR.Text, cmbLedgerDR.Text);
MessageBox.Show("Record Successfully Saved");
}
else
{
//Update Code
_entities = new MicroAccountsEntities1();
var data = _entities.tbl_Entry.Where(x => x.voucherRefNo == updateVouId).FirstOrDefault();
data.crId = _entities.tbl_AccLedger.Where(x => x.ledgerName == cmbLedgerCR.Text).FirstOrDefault().Id;
data.drId = _entities.tbl_AccLedger.Where(x => x.ledgerName == cmbLedgerDR.Text).FirstOrDefault().Id;
data.date = DateTime.Now.Date;
data.amt = Convert.ToDecimal(txtAmt.Text);
data.stringDate = dateTimePicker1.Text.ToString();
data.updatedDate = DateTime.Now;
_entities.SaveChanges();
// pm.updatePaymentRecord(data);
TransactionEntryClass tcs = new TransactionEntryClass();
string transType = "";
if (passedVoucherType == 1)
{
transType = "Payment";
}
else if (passedVoucherType == 2)
{
transType = "Receipt";
}
else if (passedVoucherType == 3)
{
transType = "Journal";
}
else if (passedVoucherType == 4)
{
transType = "Contra";
}
tcs.updateRecord(updateVouId, transType, Convert.ToDecimal(txtAmt.Text), cmbLedgerCR.Text, cmbLedgerDR.Text);
MessageBox.Show("Record Successfully Updated");
}
datagridBind();
clear();
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
try
{
if (txtBillNo.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtBillNo, "Enter bill number.");
txtBillNo.Focus();
panel3.Visible = true;
lblError.Text = "Enter bill 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 (txtTotalMaking.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtTotalMaking, "Enter total making.");
txtTotalMaking.Focus();
panel3.Visible = true;
lblError.Text = "Enter total making.";
}
else if (txtTotalRate.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtTotalRate, "Enter total rate.");
txtTotalRate.Focus();
panel3.Visible = true;
lblError.Text = "Enter total rate.";
}
else
{
if (btnCreate.Text == "Create")
{
//Save Code
_entities = new MicroAccountsEntities1();
tbl_SalesMaster salesData = new tbl_SalesMaster();
salesData.billNo = txtBillNo.Text.Trim().ToString();
salesData.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == txtLedgerName.Text.Trim().ToString()).FirstOrDefault().Id;
DateTime date = DateTime.ParseExact(dateTimePicker1.Text, "dd-MM-yyyy", null);
salesData.date = Convert.ToDateTime(date);
salesData.totalWeight = Convert.ToDecimal(txtTotalWeight.Text);
salesData.unit = lblUnit.Text;
salesData.totalKarat = 0;
salesData.totalMaking = Convert.ToDecimal(txtTotalMaking.Text);
salesData.totalAmt = Convert.ToDecimal(txtTotalRate.Text);
salesData.remarks = txtRemark.Text.ToString();
salesData.createdDate = DateTime.Now;
salesData.updateDate = DateTime.Now;
_entities.tbl_SalesMaster.Add(salesData);
_entities.SaveChanges();
//add data to purchase detials
addPurchaseDetailsData();
//Add data to transaction table
TransactionEntryClass tcs = new TransactionEntryClass();
tcs.addRecord("Sales", Convert.ToDecimal(txtTotalRate.Text), txtLedgerName.Text, "Sales Account");
MessageBox.Show("Record Successfull Saved");
}
else
{
//Update Code
_entities = new MicroAccountsEntities1();
var salesDataUpdate = _entities.tbl_SalesMaster.Where(x => x.sId == passedSid).FirstOrDefault();
salesDataUpdate.billNo = txtBillNo.Text.Trim().ToString();
salesDataUpdate.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == txtLedgerName.Text.Trim().ToString()).FirstOrDefault().Id;
DateTime date = DateTime.ParseExact(dateTimePicker1.Text, "dd-MM-yyyy", null);
salesDataUpdate.date = Convert.ToDateTime(date);
salesDataUpdate.totalWeight = Convert.ToDecimal(txtTotalWeight.Text);
salesDataUpdate.unit = lblUnit.Text;
salesDataUpdate.totalKarat = 0;
salesDataUpdate.totalMaking = Convert.ToDecimal(txtTotalMaking.Text);
salesDataUpdate.totalAmt = Convert.ToDecimal(txtTotalRate.Text);
salesDataUpdate.remarks = txtRemark.Text.ToString();
salesDataUpdate.updateDate = DateTime.Now;
_entities.SaveChanges();
var salesDetailsUpdate = _entities.tbl_SalesDetails.Where(x => x.salesId == passedSid).ToList();
foreach (var item in salesDetailsUpdate)
{
_entities.tbl_SalesDetails.Remove(item);
_entities.SaveChanges();
}
addPurchaseDetailsData(); //grid data entry in purchse details
//Update transaction
TransactionEntryClass tcs = new TransactionEntryClass();
tcs.updateRecord(passedSid, "Sales", Convert.ToDecimal(txtTotalRate.Text), txtLedgerName.Text, "Sales Account");
MessageBox.Show("Record Successfull Updated");
}
clear();
clearDetails();
count = 0;
passedSid = 0;
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
