public void UpdateScheme(SchemeMasterDTO Scheme) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mystring"].ToString())) { var para = new DynamicParameters(); para.Add("@SchemeID", Scheme.SchemeID); // Normal Parameters para.Add("@SchemeName", Scheme.SchemeName); var value = con.Query <int>("sprocSchemeMasterInsertUpdateSingleItem", para, null, true, 0, CommandType.StoredProcedure); } }
public IActionResult getSchemeMasterDetailsbyId(Int64 schemeId, Int64 loanId) { SchemeMasterDTO Schememasterdetails = new SchemeMasterDTO(); try { Schememasterdetails = obschememaster.getSchemeMasterDetailsbyId(schemeId, loanId, Con); } catch (Exception ex) { throw new FinstaAppException(ex.ToString()); } return(Ok(Schememasterdetails)); }
public IActionResult saveSchemeMaster(SchemeMasterDTO schememasterlist) { bool isSaved = false; try { isSaved = obschememaster.saveSchemeMaster(schememasterlist, Con); } catch (Exception ex) { throw new FinstaAppException(ex.ToString()); } return(Ok(isSaved)); }
public IActionResult UpdateSchemeMaster(SchemeMasterDTO schememasterlist) { bool isSaved = false; try { isSaved = obschememaster.UpdateSchemeMaster(schememasterlist, Con); return(Ok(isSaved)); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError)); throw new FinstaAppException(ex.ToString()); } }
public ActionResult Create() { PlanMasterDTO objPM = new PlanMasterDTO(); List <SchemeMasterDTO> listscheme = new List <SchemeMasterDTO>(); listscheme = new List <SchemeMasterDTO>() { new SchemeMasterDTO { SchemeID = 0, SchemeName = "Select" } }; foreach (var item in objscheme.GetSchemes()) { SchemeMasterDTO sm = new SchemeMasterDTO(); sm.SchemeID = item.SchemeID; sm.SchemeName = item.SchemeName; listscheme.Add(sm); } objPM.ListScheme = listscheme; objPM.ListofPeriod = new List <SelectListItem>() { new SelectListItem { Text = "Select", Selected = true, Value = "0" }, new SelectListItem { Text = "3 Month", Selected = false, Value = "3" }, new SelectListItem { Text = "6 Month", Selected = false, Value = "6" }, new SelectListItem { Text = "1 Year", Selected = false, Value = "12" }, }; return(View(objPM)); }
public IActionResult DeleteSchemeMaster(SchemeMasterDTO schememasterlist) { bool isSaved = false; // lstLoanMasterdetails = new List<LoansMasterDTO>(); Int64 schemeid = schememasterlist.pSchemeid; int createdby = schememasterlist.pCreatedby; try { isSaved = obschememaster.DeleteSchemeMaster(schemeid, createdby, Con); } catch (Exception ex) { throw new FinstaAppException(ex.ToString()); } return(Ok(isSaved)); }
public ActionResult Create(SchemeMasterDTO objSchemeMasterDTO) { if (ModelState.IsValid) { objSchemeMasterDTO.Createdby = Session["UserID"].ToString(); objISchemeMaster.InsertScheme(objSchemeMasterDTO); TempData["Message"] = "Scheme Create Successfully."; return(RedirectToAction("Create")); } else { ModelState.AddModelError("Error", "Please enter Scheme Name "); } ModelState.Remove("SchemeName"); return(View(objSchemeMasterDTO)); }
public void EDITMethod(PlanMasterDTO objplan) { ModelState.Remove("ListScheme"); ModelState.Remove("ListofPeriod"); List <SchemeMasterDTO> listscheme = new List <SchemeMasterDTO>(); listscheme = new List <SchemeMasterDTO>() { new SchemeMasterDTO { SchemeID = 0, SchemeName = "Select" } }; foreach (var item in objscheme.GetSchemes()) { SchemeMasterDTO sm = new SchemeMasterDTO(); sm.SchemeID = item.SchemeID; sm.SchemeName = item.SchemeName; listscheme.Add(sm); } objplan.ListScheme = listscheme; objplan.SchemeID = objplan.SchemeID; objplan.ListofPeriod = new List <SelectListItem>() { new SelectListItem { Text = "Select", Selected = true, Value = "0" }, new SelectListItem { Text = "3 Month", Selected = false, Value = "3" }, new SelectListItem { Text = "6 Month", Selected = false, Value = "6" }, new SelectListItem { Text = "1 Year", Selected = false, Value = "12" }, }; objplan.PeriodID = objplan.PeriodID; }
[NonAction] // if Method is not Action method then use NonAction public List <SchemeMasterDTO> BindListScheme() { List <SchemeMasterDTO> listscheme = new List <SchemeMasterDTO>() { new SchemeMasterDTO { SchemeID = 0, SchemeName = "Select" } }; foreach (var item in objscheme.GetSchemes()) { SchemeMasterDTO sm = new SchemeMasterDTO(); sm.SchemeID = item.SchemeID; sm.SchemeName = item.SchemeName; listscheme.Add(sm); } return(listscheme); }
public ActionResult Edit(SchemeMasterDTO objSchemeMasterDTO) { objISchemeMaster.UpdateScheme(objSchemeMasterDTO); TempData["MessageUpdate"] = "Scheme Updated Successfully."; return(RedirectToAction("Details")); }