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)); }