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());
}
