//public JsonResult GetVendorTerminations1(Guid vendorId, int pageSize, int currentPage)
//{
// TGFContext db = new TGFContext();
// db.Configuration.ProxyCreationEnabled = false;
// var terminationsQuery = db.VendorTerminations.Include("Division1").Include("TerminationReason1").Where(c => c.VendorID == vendorId);
// var rowCount = terminationsQuery.Count();
// var terminations = terminationsQuery.OrderByDescending(s => s.TerminationDate).Skip((currentPage - 1) * pageSize).Take(pageSize).ToList();
// return Json(new { Data = terminations, VirtualRowCount = rowCount }, JsonRequestBehavior.AllowGet);
//}
public JsonResult SaveVendorTermination(VendorTermination termination)
{
var result = false;
if (ModelState.IsValid)
{
using (this.UoW)
{
if (termination.VendorTerminationID == Guid.Empty)
{
termination.InputDate = DateTime.Now;
termination.LastModifiedDate = DateTime.Now;
termination.VendorTerminationID = Guid.NewGuid();
this.UoW.VendorTerminations.Insert(termination);
result = this.UoW.Commit() > 0;
}
else
{
TGFContext db = new TGFContext();
termination.LastModifiedDate = DateTime.Now;
this.UoW.VendorTerminations.Update(termination);
result = this.UoW.Commit() > 0;
}
}
return(Json(new { Success = result, VendorShipTo = termination }));
}
else
{
return(Json(new { Success = result, Message = "Invalid Model" }));
}
}
//----------------------------
protected void CreateDbContext()
{
DbContext = new TGFContext();
// Do NOT enable proxied entities, else serialization fails
DbContext.Configuration.ProxyCreationEnabled = false;
// Load navigation properties explicitly (avoid serialization trouble)
DbContext.Configuration.LazyLoadingEnabled = false;
// Because Web API will perform validation, we don't need/want EF to do so
DbContext.Configuration.ValidateOnSaveEnabled = false;
//DbContext.Configuration.AutoDetectChangesEnabled = false;
}
public EFRepository(TGFContext context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
