public ActionResult EditDesignation(tbl_MCE_Designations mce_Designations)
{
_designation.EditDesignation(mce_Designations);
TempData["Success"] = "Data Updated Successfully";
return(RedirectToAction("ViewDesignationDataTableWithTab", "Designation"));
//return View();
}
public ActionResult CreateDesignationWithTab(tbl_MCE_Designations MCE_Designation)
{
_designation.AddDesignation(MCE_Designation);
TempData["Success"] = "Data Inserted Successfully";
//To clear the model
ModelState.Clear();
return(View());
}
public ActionResult DeleteDesignation(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_MCE_Designations designation = _designation.DesignationDetails((int)id);
return(View(designation));
}
public string AddDesignation(tbl_MCE_Designations mce_Designations)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "DESIGNATIONINSERT");
param.Add("@P_intDesignationID", mce_Designations.intDesignationID);
param.Add("@P_vchDesignation", mce_Designations.vchDesignation);
param.Add("@P_vchDesignationDescription", mce_Designations.vchDesignationDescription);
param.Add("@P_vchRemarks", mce_Designations.vchRemarks);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Designation_DLM", param, "@P_VCHMSGOUT"));
}
public string DeleteDesignation(tbl_MCE_Designations mce_Designations)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "DESIGNATIONDELETE");
param.Add("@P_intDesignationID", mce_Designations.intDesignationID);
param.Add("@P_intCreatedBy", mce_Designations.intCreatedBy);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Designation_DLM", param, "@P_VCHMSGOUT"));
}
