//----------------------->>>>>Add quotation and services here.....
public JsonResult AddQuotation(srv[] ar, quotation ob)
{
if (ModelState.IsValid)
{
return this.Json("-------", JsonRequestBehavior.AllowGet);
}
try
{
Quotation obj = new Quotation();
obj.Date = ob.date;
obj.ShipperId = ob.shipperid;
obj.ComodityId = ob.comodityid;
obj.Quantity = ob.quantity;
obj.PackingId = ob.packingid;
obj.Weight = ob.weight;
obj.LoadingPort = ob.loadingport;
obj.DischargePort = ob.dischargeport;
obj.FlightNo = ob.flightno;
obj.SailingDate = ob.sailingdate;
obj.ArrivalDate = ob.arrivaldate;
obj.ConsigneeId = ob.consigneeid;
obj.Status = "inactive";
obj.PayedAmount = 0;
db.Quotations.Add(obj);
db.SaveChanges();
int id = obj.Id;
ServiceForQuotation sample = new ServiceForQuotation();
foreach (var a in ar)
{
sample.Quantity = a.quantity;
sample.UnitPrice = a.price;
sample.QuotationId = id;
sample.ServiceId = a.id;
db.ServiceForQuotations.Add(sample);
db.SaveChanges();
}
return this.Json("success", JsonRequestBehavior.AllowGet);
}
catch(Exception e)
{
return this.Json("-------", JsonRequestBehavior.AllowGet);
}
}
public JsonResult EditQuotation(srv[] ar, quotation ob)
{
try
{
Quotation obj = new Quotation();
obj.Id = ob.id;
obj.Date = ob.date;
obj.ShipperId = ob.shipperid;
obj.ComodityId = ob.comodityid;
obj.Quantity = ob.quantity;
obj.PackingId = ob.packingid;
obj.Weight = ob.weight;
obj.LoadingPort = ob.loadingport;
obj.DischargePort = ob.dischargeport;
obj.FlightNo = ob.flightno;
obj.SailingDate = ob.sailingdate;
obj.ArrivalDate = ob.arrivaldate;
obj.ConsigneeId = ob.consigneeid;
obj.Status = ob.status;
obj.PayedAmount = ob.payedamount;
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
int id = obj.Id;
var list = db.ServiceForQuotations.Where(x => x.QuotationId == id).Select(x => x).ToList();
foreach (var a in list)
{
db.ServiceForQuotations.Remove(a);
db.SaveChanges();
}
ServiceForQuotation sample = new ServiceForQuotation();
foreach (var a in ar)
{
sample.Quantity = a.quantity;
sample.UnitPrice = a.price;
sample.QuotationId = id;
sample.ServiceId = a.id;
db.ServiceForQuotations.Add(sample);
db.SaveChanges();
}
return this.Json("success", JsonRequestBehavior.AllowGet);
}catch(Exception e)
{
return this.Json("----",JsonRequestBehavior.AllowGet);
}
}