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