public string AddPOMASTER(POMASTER _PODETAIL)
{
string Result = "Success";
try
{
poDb.POMASTERs.Add(_PODETAIL);
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();
}
public string UpdatePOMASTER(POMASTER _POMASTER)
{
string Result = "Success";
try
{
Purchase_Order_Processing_System.POMASTER _pomaster = poDb.POMASTERs.Where(x => x.PONO == _POMASTER.PONO).ToList().FirstOrDefault();
_pomaster.PODATE = _POMASTER.PODATE;
_pomaster.PODETAILs = _POMASTER.PODETAILs;
_pomaster.SUPLNO = _POMASTER.SUPLNO;
_pomaster.SUPPLIER = _POMASTER.SUPPLIER;
poDb.SaveChanges();
}
catch (Exception ex)
{
Result = ex.Message;
}
return(Result);
}