public ActionResult GetSchemeById(int ID) { string operation = Session["Operation"].ToString(); ButtonVisiblity(operation); Mst_SchemeMaster tblScheme = dd._context.Mst_SchemeMaster.Where(x => x.SchemeId == ID).FirstOrDefault(); SchemeViewModel scheme = new SchemeViewModel(); scheme.SchemeId = tblScheme.SchemeId; scheme.EditID = tblScheme.SchemeId; scheme.Product = tblScheme.Product; scheme.SchemeName = tblScheme.SchemeName; // scheme.Purity = tblScheme.Purity; scheme.SchemeType = tblScheme.SchemeType; scheme.Frequency = tblScheme.Frequency; scheme.MinTenure = (int)tblScheme.MinTenure; scheme.MaxTenure = (int)tblScheme.MaxTenure; scheme.MinLoanAmount = tblScheme.MinLoanAmount; scheme.MaxLoanAmount = tblScheme.MaxLoanAmount; scheme.MinLTVPerc = tblScheme.MinLTVPerc; scheme.MaxLTVPerc = tblScheme.MaxLTVPerc; scheme.MinROIPerc = tblScheme.MinRoiPerc; scheme.MaxROIPerc = tblScheme.MaxRoiPerc; scheme.GracePeriod = tblScheme.GracePeriod; scheme.EffectiveROIPerc = tblScheme.EffectiveRoiPerc; scheme.LockInPeriod = tblScheme.LockInPeriod; scheme.ProcessingFeeType = tblScheme.ProcessingFeeType; scheme.ProcessingCharges = tblScheme.ProcessingCharges; scheme.Status = tblScheme.Status; scheme.operation = operation; List <Mst_SchemePurity> getPuritylist = dd._context.Mst_SchemePurity.Where(x => x.SchemeId == ID).ToList(); List <int> puritytlist = new List <int>(); foreach (var item in getPuritylist) { puritytlist.Add(item.PurityId); } scheme.Purity = puritytlist; Session["PurityData"] = scheme.Purity; ViewBag.PurityList = new SelectList(dd._context.Mst_PurityMaster.Where(x => x.PurityType == scheme.Product).ToList(), "Id", "PurityName"); return(View("Scheme", scheme)); }
//[ValidateAntiForgeryToken] public JsonResult CreateEdit(SchemeViewModel scheme) { scheme.CreatedBy = Convert.ToInt32(Session["UserLoginId"]); scheme.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]); Mst_SchemeMaster tblSchemeMaster = new Mst_SchemeMaster(); try { if (scheme.EditID <= 0) { scheme.SchemeId = dd._context.Mst_SchemeMaster.Any() ? dd._context.Mst_SchemeMaster.Max(m => m.SchemeId) + 1 : 1; var data = dd._context.Mst_SchemeMaster.Where(u => u.SchemeName == scheme.SchemeName && u.Status == 1).Select(x => x.SchemeName).FirstOrDefault(); if (data != null) { ModelState.AddModelError("SchemeName", "Scheme Name Already Exists"); return(Json(scheme)); } tblSchemeMaster.SchemeId = scheme.SchemeId; tblSchemeMaster.RecordCreated = DateTime.Now; tblSchemeMaster.RecordCreatedBy = scheme.CreatedBy; dd._context.Mst_SchemeMaster.Add(tblSchemeMaster); } else { tblSchemeMaster = dd._context.Mst_SchemeMaster.Where(x => x.SchemeId == scheme.SchemeId).FirstOrDefault(); } tblSchemeMaster.Product = scheme.Product; tblSchemeMaster.SchemeName = scheme.SchemeName; tblSchemeMaster.SchemeType = scheme.SchemeType; tblSchemeMaster.Frequency = scheme.Frequency; tblSchemeMaster.MinTenure = scheme.MinTenure; tblSchemeMaster.MaxTenure = scheme.MaxTenure; tblSchemeMaster.MinLoanAmount = scheme.MinLoanAmount; tblSchemeMaster.MaxLoanAmount = scheme.MaxLoanAmount; tblSchemeMaster.MinLTVPerc = scheme.MinLTVPerc; tblSchemeMaster.MaxLTVPerc = scheme.MaxLTVPerc; tblSchemeMaster.MinRoiPerc = scheme.MinROIPerc; tblSchemeMaster.MaxRoiPerc = scheme.MaxROIPerc; tblSchemeMaster.GracePeriod = scheme.GracePeriod; tblSchemeMaster.EffectiveRoiPerc = scheme.EffectiveROIPerc; tblSchemeMaster.LockInPeriod = scheme.LockInPeriod; tblSchemeMaster.ProcessingFeeType = scheme.ProcessingFeeType; tblSchemeMaster.ProcessingCharges = scheme.ProcessingCharges; tblSchemeMaster.Status = scheme.Status; tblSchemeMaster.RecordUpdated = DateTime.Now; tblSchemeMaster.RecordUpdatedBy = scheme.UpdatedBy; dd._context.SaveChanges(); int schemeid = dd._context.Mst_SchemeMaster.Max(x => x.SchemeId); if (scheme.Purity == null) { scheme.Purity = (List <int>)Session["PurityData"]; } var getrecord = dd._context.Mst_SchemePurity.Where(x => x.SchemeId == scheme.SchemeId).ToList(); if (getrecord != null) { foreach (var item1 in getrecord) { dd._context.Mst_SchemePurity.Remove(item1); dd._context.SaveChanges(); } } foreach (var item in scheme.Purity) { Mst_SchemePurity tblSchemePurity = new Mst_SchemePurity(); tblSchemePurity.SchemeId = schemeid; tblSchemePurity.PurityId = item; dd._context.Mst_SchemePurity.Add(tblSchemePurity); } dd._context.SaveChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } return(Json(scheme)); }