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