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