public string SaveDesignation(Common_Designation objDesignation)
{
string rv = "";
try
{
Insert_Update_Designation("sp_Insert_Designation", "saveDesignationinfo", objDesignation);
rv = Operation.Success.ToString();
}
catch (Exception ex)
{
rv = ex.Message;
}
return(rv);
}
public ActionResult SaveDesignation(Common_Designation objDesignation)
{
var res = _designationRepository.SaveDesignation(objDesignation);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public DataTable Insert_Update_Designation(string procedure, string callname, Common_Designation objDesignation)
{
dbConn = new SqlConnection(ConnectionString);
dbConn.Open();
cmd = new SqlCommand(procedure, dbConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@call_name", callname));
cmd.Parameters.Add(new SqlParameter("@p_DesignationId", objDesignation.DesignationID));
cmd.Parameters.Add(new SqlParameter("@p_DesignationName", objDesignation.DesignationName));
cmd.Parameters.Add(new SqlParameter("@p_DesignationNameBan", objDesignation.DesignationNameBan));
cmd.Parameters.Add(new SqlParameter("@p_DesGroupID", objDesignation.DesGroupID));
cmd.Parameters.Add(new SqlParameter("@p_Grade", objDesignation.Grade));
cmd.Parameters.Add(new SqlParameter("@p_OrderBy", objDesignation.OrderBy));
cmd.Parameters.Add(new SqlParameter("@p_IsActive", objDesignation.IsActive));
cmd.Parameters.Add(new SqlParameter("@p_IsDelete", objDesignation.IsDelete));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public string SaveDesignation(Common_Designation objDesignation)
{
return(_dataService.SaveDesignation(objDesignation));
}
