public void BvsAllotment(DtoBvsAllotment allotment)
{
using (var transaction = _db.Database.BeginTransaction())
{
BVSAllot allot = _db.BvsAllots.FirstOrDefault(b => b.PersonId.Equals(allotment.PersonId));
if (allot != null)
{
_db.BvsAllots.Remove(allot);
_db.SaveChanges();
_db.BvsAllotServices.RemoveRange(
_db.BvsAllotServices.Where(b => b.BVSAllotId.Equals(allot.BVSAllotId)));
_db.SaveChanges();
}
BVSAllot alloted = new BVSAllot
{
ItemId = allotment.ItemId ?? 0,
PersonId = allotment.PersonId
};
_db.BvsAllots.Add(alloted);
_db.SaveChanges();
//List<BVSAllotService> dbServices = _db.
foreach (DtoBvsAllotmentServices services in allotment.AllotmentServiceses)
{
if (services.Active)
{
BVSAllotService service = new BVSAllotService
{
BVSAllotId = alloted.BVSAllotId,
BvsServiceId = services.BvsServiceId
};
_db.BvsAllotServices.Add(service);
_db.SaveChanges();
}
}
transaction.Commit();
}
}
public ActionResult BvsAllotment(DtoBvsAllotment allotment)
{
_repo.BvsAllotment(allotment);
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
