public void CreateItem(ITEM item) { var model = new PODbModel(); model.ITEMs.Add(item); model.SaveChanges(); }
public void CreateSupplier(SUPPLIER supplier) { var model = new PODbModel(); model.SUPPLIERs.Add(supplier); model.SaveChanges(); }
public void DeleteItem(string code) { var model = new PODbModel(); var item = model.ITEMs.FirstOrDefault(x => x.ITCODE == code); if (item != null) { model.ITEMs.Remove(item); model.SaveChanges(); } }
public void DeleteSupplier(string code) { var model = new PODbModel(); var supplier = model.SUPPLIERs.FirstOrDefault(x => x.SUPLNO == code); if (supplier != null) { model.SUPPLIERs.Remove(supplier); model.SaveChanges(); } }
public void UpdateItem(ITEM item) { var model = new PODbModel(); var oldItem = model.ITEMs.FirstOrDefault(x => x.ITCODE == item.ITCODE); if (oldItem != null) { oldItem.ITDESC = item.ITDESC; oldItem.ITRATE = item.ITRATE; model.SaveChanges(); } }
public void UpdateSupplier(SUPPLIER supplier) { var model = new PODbModel(); var oldSupplier = model.SUPPLIERs.FirstOrDefault(x => x.SUPLNO == supplier.SUPLNO); if (oldSupplier != null) { oldSupplier.SUPLNAME = supplier.SUPLNAME; oldSupplier.SUPLADDR = supplier.SUPLADDR; model.SaveChanges(); } }