public ActionResult PlanDetail(PlanDetailModel model)
{
var id = Request.Params["customerId"].ToString();
TB_PLAN_DETAIL detail = new TB_PLAN_DETAIL();
detail.N_AMOUNT = model.amount;
detail.N_CUSTOMER_ID = int.Parse(id);
detail.N_PLAN_ID = model.planId;
detail.S_DESCRIPTION = model.description;
detail.S_DETAIL = model.detail;
detail.D_EXPRIRE = model.exprireDate;
var modelDB = new CustomerDBModel();
var modelDB2 = new PlanDBModel();
modelDB.createPlanDetail(detail);
var plan = modelDB2.getPlanById(model.planId);
Random rnd = new Random();
int ramdom01 = rnd.Next(10000, 99999);
int ramdom02 = rnd.Next(10000, 99999);
TB_CUSTOMER customer = new TB_CUSTOMER();
customer.N_ID = int.Parse(id);
customer.S_CODE = plan.S_NAME[0].ToString() + ramdom01.ToString() + ramdom02.ToString();
modelDB.updateCodeById(customer);
return(RedirectToAction("List"));
}
public ActionResult PlanDetail(int customerId, int planId)
{
var planDetail = new PlanDetailModel();
planDetail.accountId = customerId;
planDetail.planId = planId;
return(View(planDetail));
}
public ActionResult Save(PlanViewModel plan, int PlanMasterId, List <PlanDetailViewModel> planDetailList)
{
if (ModelState.IsValid)
{
#region //B1: Cập nhật Master
PlanModel planModel = _context.PlanModel.Where(p => p.PlanMasterId == PlanMasterId).FirstOrDefault();
planModel.FromTime = plan.FromTime;
planModel.ToTime = plan.ToTime;
#endregion //B1: Cập nhật Master
#region //B2: Cập nhật Detail
//TH1: Cũ không có trong mới -> Delete
List <PlanDetailModel> detailList = _context.PlanDetailModel.Where(y => y.PlanMasterId == PlanMasterId).ToList();
foreach (var item in detailList)
{
PlanDetailViewModel pdVM = planDetailList.Where(z => z.PlanDetailId == item.PlanDetailId).FirstOrDefault();
if (pdVM == null)
{
_context.Entry(item).State = EntityState.Deleted;
}
}
foreach (var item in planDetailList)
{
//TH2: Mới có trong cũ -> Modify
PlanDetailModel planDetail = _context.PlanDetailModel.Where(x => x.PlanDetailId == item.PlanDetailId).FirstOrDefault();
if (planDetail != null)
{
planDetail.TimeFrame = item.TimeFrame;
planDetail.AmountOfCus = item.AmountOfCus;
_context.Entry(planDetail).State = System.Data.Entity.EntityState.Modified;
}
//TH3: Mới không có trong cũ -> Add
else
{
planDetail = new PlanDetailModel();
planDetail.PlanMasterId = PlanMasterId;
planDetail.TimeFrame = item.TimeFrame;
planDetail.AmountOfCus = item.AmountOfCus;
_context.Entry(planDetail).State = System.Data.Entity.EntityState.Added;
}
}
#endregion //B2: Cập nhật Detail
#region //B3: Cập nhật Master & Detail
_context.Entry(planModel).State = EntityState.Modified;
_context.SaveChanges();
#endregion //B3: Cập nhật Master & Detail
return(Json(new { result = true }, JsonRequestBehavior.AllowGet));
}
return(Json(new { result = false }, JsonRequestBehavior.AllowGet));
}
