public ActionResult CreateLevelWithTab(tbl_MCE_Levels MCE_Level)
 {
     _level.AddLevel(MCE_Level);
     TempData["Success"] = "Data Inserted Successfully";
     ModelState.Clear();
     return(View());
 }
 public ActionResult EditLevel(tbl_MCE_Levels mce_Levels)
 {
     _level.EditLevel(mce_Levels);
     TempData["Success"] = "Data Updated Successfully";
     return(RedirectToAction("ViewLevelsDatatableWithTab", "Level"));
     //return View();
 }
        public ActionResult DeleteLevel(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tbl_MCE_Levels level = _level.LevelDetails((int)id);

            return(View(level));
        }
        public string AddLevel(tbl_MCE_Levels mce_Levels)
        {
            DynamicParameters param = new DynamicParameters();

            param.Add("@P_CHRACTION", "LEVELINSERT");
            param.Add("@P_intLevelID", mce_Levels.intLevelID);
            param.Add("@P_vchLevelName", mce_Levels.vchLevelName);
            param.Add("@P_vchRemarks", mce_Levels.vchRemarks);

            param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
            return(DapperORM.ExecuteDML("SP_MCE_Level_DLM", param, "@P_VCHMSGOUT"));
        }
        public string DeleteLevel(tbl_MCE_Levels mce_Levels)
        {
            DynamicParameters param = new DynamicParameters();

            param.Add("@P_CHRACTION", "LEVELDELETE");
            param.Add("@P_intLevelID", mce_Levels.intLevelID);


            param.Add("@P_intCreatedBy", mce_Levels.intCreatedBy);


            param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
            return(DapperORM.ExecuteDML("SP_MCE_Level_DLM", param, "@P_VCHMSGOUT"));
        }
 public ActionResult DeleteLevel(tbl_MCE_Levels mce_Levels)
 {
     _level.DeleteLevel(mce_Levels);
     TempData["Success"] = "Data Deleted Successfully";
     return(RedirectToAction("ViewLevelsDatatableWithTab", "Level"));
 }