// GET: Discount/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DiscountMas discountMas = db.DiscountMas.Find(id);
if (discountMas == null)
{
return(HttpNotFound());
}
var buyers = (from buyermas in db.BuyerOrderMas
join factmas in db.FactoryOrderMas on buyermas.Id equals factmas.BuyerOrderMasId
join buyer in db.BuyerInfo on buyermas.BuyerInfoId equals buyer.Id
select buyer).Distinct().ToList();
ViewBag.BuyerInfoId = new SelectList(buyers.OrderBy(x => x.Name), "Id", "Name", discountMas.BuyerOrderDet.BuyerOrderMas.BuyerInfoId);
ViewBag.SupplierId = new SelectList(db.Supplier.OrderBy(x => x.Name), "Id", "Name", discountMas.BuyerOrderDet.SupplierId);
ViewBag.BuyerOrderMasId = new SelectList(db.BuyerOrderMas, "Id", "OrderRefNo", discountMas.BuyerOrderDet.BuyerOrderMas.Id);
ViewBag.BuyerOrderDetId = new SelectList(db.BuyerOrderDet, "Id", "StyleNo", discountMas.BuyerOrderDetId);
return(View(discountMas));
}
public ActionResult DeleteConfirmed(int id)
{
DiscountMas discountMas = db.DiscountMas.Find(id);
db.DiscountMas.Remove(discountMas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//// POST: Discount/Edit/5
//[HttpPost]
//[ValidateAntiForgeryToken]
//public ActionResult Edit([Bind(Include = "Id,BuyerOrderDetId,DiscountDate,IsAuth,OpBy,OpOn,AuthBy,AuthOn")] DiscountMas discountMas)
//{
// if (ModelState.IsValid)
// {
// db.Entry(discountMas).State = EntityState.Modified;
// db.SaveChanges();
// return RedirectToAction("Index");
// }
// ViewBag.BuyerOrderDetId = new SelectList(db.BuyerOrderDet, "Id", "StyleNo", discountMas.BuyerOrderDetId);
// return View(discountMas);
//}
// GET: Discount/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DiscountMas discountMas = db.DiscountMas.Find(id);
if (discountMas == null)
{
return(HttpNotFound());
}
return(View(discountMas));
}
public JsonResult SaveDiscount(IEnumerable <DiscountDet> DiscountDetail, DiscountMas discountMas)
{
var result = new
{
flag = false,
message = "Error occured. !",
Id = 0
};
try
{
var OpDate = DateTime.Now;
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
var DiscountM = new DiscountMas()
{
Id = discountMas.Id,
BuyerOrderDetId = discountMas.BuyerOrderDetId,
DiscountDate = discountMas.DiscountDate,
IsAuth = true,
OpBy = 1,
OpOn = OpDate,
AuthBy = 1,
AuthOn = OpDate
};
db.Entry(DiscountM).State = DiscountM.Id == 0 ? EntityState.Added : EntityState.Modified;
//db.DiscountMas.Add(DiscountM);
db.SaveChanges();
foreach (var item in DiscountDetail)
{
var DiscountD = new DiscountDet()
{
Id = item.Id,
DiscountMasId = DiscountM.Id,
FactoryOrderDelivDetId = item.FactoryOrderDelivDetId,
BuyerDiscount = item.BuyerDiscount,
AdjustBuyerNow = item.AdjustBuyerNow,
FactoryDiscount = item.FactoryDiscount,
AdjustFactoryNow = item.AdjustFactoryNow
};
//db.DiscountDet.Add(DiscountD);
db.Entry(DiscountD).State = DiscountD.Id == 0 ? EntityState.Added : EntityState.Modified;
//db.SaveChanges();
//if(DiscountD.FactoryDiscount > 0 && DiscountD.AdjustFactoryNow == true)
//{
// var FactoryDeliv = db.FactoryOrderDelivDet.Find(item.FactoryOrderDelivDetId);
// FactoryDeliv.DiscountFlag = true;
//}
db.SaveChanges();
}
dbContextTransaction.Commit();
result = new
{
flag = true,
message = "Saving successful!!!",
Id = DiscountM.Id
};
//Success("Record saved successfully.", true);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
result = new
{
flag = false,
message = ex.Message,
Id = 0
};
}
}
}
catch (Exception ex)
{
result = new
{
flag = false,
message = ex.Message,
Id = 0
};
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
