public string AddPODETAIL(PODETAIL _PODETAIL) { string Result = "Success"; try { poDb.PODETAILs.Add(_PODETAIL); poDb.SaveChanges(); } catch (Exception ex) { Result = ex.Message; } return(Result); }
public string UpdatePODETAIL(PODETAIL _PODETAIL) { string Result = "Success"; try { Purchase_Order_Processing_System.PODETAIL _podetail = poDb.PODETAILs.Where(x => x.PONO == _PODETAIL.PONO).ToList().FirstOrDefault(); _podetail.ITCODE = _PODETAIL.ITCODE; _podetail.ITEM = _PODETAIL.ITEM; _podetail.POMASTER = _PODETAIL.POMASTER; _podetail.QTY = _PODETAIL.QTY; poDb.SaveChanges(); } catch (Exception ex) { Result = ex.Message; } return(Result); }
public void UpdatePurchaseOrder(PurchaseOrderModel POModel) { var dbMaster = new POMASTER { PONO = POModel.PONumber, PODATE = POModel.Date, SUPLNO = POModel.SupplierNumber }; var dbDetail = new PODETAIL { PONO = POModel.PONumber, ITCODE = POModel.ItemCode, QTY = POModel.Quantity }; dbContext.Entry(dbMaster).State = EntityState.Modified; dbContext.Entry(dbDetail).State = EntityState.Modified; dbContext.SaveChanges(); }
/////////////// public void CreatePurchaseOrder(PurchaseOrderModel POModel) { var dbMaster = new POMASTER { PONO = POModel.PONumber, PODATE = POModel.Date, SUPLNO = POModel.SupplierNumber }; var dbDetail = new PODETAIL { PONO = POModel.PONumber, ITCODE = POModel.ItemCode, QTY = POModel.Quantity }; dbContext.POMASTER.Add(dbMaster); dbContext.PODETAIL.Add(dbDetail); dbContext.SaveChanges(); }