private void Save()
{
if (isNew)
{
ledger.CreatedBy = 1;
ledger.CreatedDate = DateTime.Now;
contxt.SupplierLedgers.Add(ledger);
contxt.Entry(ledger).State = System.Data.Entity.EntityState.Added;
contxt.SaveChanges();
contxt.Entry(ledger).Reload();
sessionList.Add(ledger);
}
if (isEdit)
{
SupplierLedger led = contxt.SupplierLedgers.FirstOrDefault(o => o.id == ledger.id);
if (led != null)
{
led.ModifiedBy = 1;
led.ModifiedDate = DateTime.Now;
led.ProductId = ledger.ProductId;
led.Quantity = ledger.Quantity;
led.Ref01 = ledger.Ref01;
led.Ref02 = ledger.Ref02;
led.SupplierId = ledger.SupplierId;
led.TotalPrice = ledger.TotalPrice;
led.TrnDate = ledger.TrnDate;
led.UnitPrice = ledger.UnitPrice;
contxt.Entry(led).State = System.Data.Entity.EntityState.Modified;
contxt.SaveChanges();
contxt.Entry(ledger).Reload();
}
}
ShowSession();
}
private void FormImportTrn_Load(object sender, EventArgs e)
{
contxt = new PMModel();
ledger = new SupplierLedger();
ledgerMaster = new RouteQty();
route = new AddressBook();
}
private void dgvSes_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
ledger = (SupplierLedger)dgvSes.Rows[e.RowIndex].DataBoundItem;
ShowContents();
isNew = false; isEdit = true;
state = FORMSTATE.EDIT;
panelMid.Enabled = true;
SetButtons();
}
private void btnSave_Click(object sender, EventArgs e)
{
FillObjects();
try
{
Save();
MessageBox.Show("Data saving was successful");
ledger = new SupplierLedger();
isEdit = false; isNew = false;
state = FORMSTATE.NOOP;
SetButtons();
ClearControls();
panelMid.Enabled = false;
btnAdd.Focus();
}catch (Exception ex)
{
MessageBox.Show(" Data saving returned an error \n" + ex.Message + "\n" + ex.InnerException.InnerException.Message);
}
}
private void FormTransaction_Load(object sender, EventArgs e)
{
contxt = new PMModel();
partners = new List <AddressBook>();
partner = new AddressBook();
products = new List <Product>();
ledger = new SupplierLedger();
sessionList = new List <SupplierLedger>();
GetTrnType();
GetProducts();
state = FORMSTATE.NOOP;
SetButtons();
isEdit = false; isNew = false;
panelMid.Enabled = false;
dtTrnDate.Value = DateTime.Now;
GetCurrentMonthTrn();
isFormLoading = false;
SetGridProperties();
}
