public IActionResult Add(PurchaseRequest PurchaseRequest, Supplier Supplier, QuatationStatus Status, DateTime Date) { int max_id = 0; try { max_id = _db.Quatations.Max((qt) => qt.Id); } catch { } Quatation qt = new Quatation() { Id = max_id + 1, PurchaseRequest = PurchaseRequest, Supplier = Supplier, Status = Status, Date = Date }; _db.Quatations.Add(qt); _db.SaveChanges(); return(Ok()); }
public IActionResult Edit(int Id, PurchaseRequest PurchaseRequest, Supplier Supplier, QuatationStatus Status, DateTime Date) { _db.Quatations.Update(new Quatation() { Id = Id, PurchaseRequest = PurchaseRequest, Supplier = Supplier, Status = Status, Date = Date }); _db.SaveChanges(); return(Ok()); }
public IActionResult Edit(int Id, Quatation Quatation, PurchaseRequestItem PurchaseRequestItem, Item Item, QuatationStatus Status, string IsSupply, string Description, int Qty, int Total, string Rate) { _db.QuatationItems.Update(new QuatationItem { Id = Id, Quatation = Quatation, PurchaseRequestItem = PurchaseRequestItem, Item = Item, Status = Status, IsSupply = IsSupply, Description = Description, Qty = Qty, Total = Total, Rate = Rate }); _db.SaveChanges(); return(Ok()); }
public IActionResult Add(Quatation Quatation, PurchaseRequestItem PurchaseRequestItem, Item Item, QuatationStatus Status, string IsSupply, string Description, int Qty, int Total, string Rate) { int max_id = 0; try { max_id = _db.QuatationItems.Max((qt) => qt.Id); } catch { } QuatationItem qt = new QuatationItem() { Id = max_id + 1, Quatation = Quatation, PurchaseRequestItem = PurchaseRequestItem, Item = Item, Status = Status, IsSupply = IsSupply, Description = Description, Qty = Qty, Total = Total, Rate = Rate }; _db.QuatationItems.Add(qt); _db.SaveChanges(); return(Ok()); }