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()); }
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 ActionResult Quatation() { SmartFarmingEntities db = new SmartFarmingEntities(); var dealerId = Convert.ToInt32(HttpContext.Session["UserId"]); Quatation model = new Quatation(); var seedlist = (from m in db.Quotations join s in db.Seeds on m.seed_id equals s.id where m.dealer_id == dealerId select new QuatationSeed() { id = m.id, SeedName = s.SeedName, Quantity = m.Quantity, Unit = m.Unit, ContactNo = m.ContactNo }).ToList(); var pesticideList = (from m in db.Quotations join p in db.Pesticides on m.pesticide_id equals p.id where m.dealer_id == dealerId select new QuatationPesticide() { id = m.id, PesticideName = p.PesticideName, Quantity = m.Quantity, Unit = m.Unit, ContactNo = m.ContactNo }).ToList(); var fertilizerList = (from m in db.Quotations join f in db.Fertilizers on m.fertilizer_id equals f.id where m.dealer_id == dealerId select new QuatationFertilizer() { id = m.id, FertilizerName = f.FertilizerName, Quantity = m.Quantity, Unit = m.Unit, ContactNo = m.ContactNo }).ToList(); model.seedlist = seedlist; model.pesticidelist = pesticideList; model.fertilizerlist = fertilizerList; return(View(model)); }
public JsonResult <Quatation> NewQuatation() { Quatation QT = new Quatation(); try { QT.QTCode = new QuationOperations().getNextQTCode(); QT.Owner = "Ushan Blinds"; QT.Deposite = "00"; QuatationLines QTLine = new QuatationLines(); QTLine.Margin = "10"; List <QuatationLines> _qtline = new List <QuatationLines>(); _qtline.Add(QTLine); QT.QuatationLines = new List <QuatationLines>(_qtline); } catch (Exception ex) { } return(Json <Quatation>(QT)); }
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()); }