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