public ActionResult CreateJoinCategory(tbl_MCE_JoinCategory mce_JoinCategory)
{
ModelState.Clear();
_JC.AddCategory(mce_JoinCategory);
ViewBag.levelList = _levels.LevelList().ToList();
TempData["Success"] = "Category Created Successfully";
ModelState.Clear();
return(View());
}
public ActionResult JoinCategoryDetails(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_MCE_JoinCategory jc = _JC.JoinCategoryDetails((int)id);
ViewBag.levelList = _levels.LevelList().ToList();
ViewBag.DefaultLevel = jc.intLevelID;
return(View(jc));
}
public string DeleteJoinCategory(tbl_MCE_JoinCategory mce_JoinCategory)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "JOINCATEGORYDELETE");
param.Add("@P_intJoinCategoryID", mce_JoinCategory.intJoinCategoryID);
param.Add("@P_intCreatedBy", mce_JoinCategory.intCreatedBy);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_JoinCategory_DML", param, "@P_VCHMSGOUT"));
}
public string AddCategory(tbl_MCE_JoinCategory MCE_JoinCategory)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "JOINCATEGORYINSERT");
param.Add("@P_intLevelID", MCE_JoinCategory.intLevelID);
param.Add("@P_vchLevelName", MCE_JoinCategory.vchLevelName);
param.Add("@P_vchJoinCategoryType", MCE_JoinCategory.vchJoinCategoryType);
param.Add("@P_vchDescription", MCE_JoinCategory.vchDescription);
param.Add("@P_vchRemarks", MCE_JoinCategory.vchRemarks);
param.Add("@P_intCreatedBy", MCE_JoinCategory.intCreatedBy);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_JoinCategory_DML", param, "@P_VCHMSGOUT"));
}
public ActionResult DeleteJoinCategory(tbl_MCE_JoinCategory mce_JoinCategory)
{
_JC.DeleteJoinCategory(mce_JoinCategory);
TempData["Success"] = "Data Deleted Successfully";
return(RedirectToAction("JoinCategoryDataTable", "JoinCategory"));
}
