public string SaveDesignationGroup(Common_DesignationGroup objDesignationGroup) { string rv = ""; try { Insert_Update_DesignationGroup("sp_Insert_DesignationGroup", "saveDesignationGroupinfo", objDesignationGroup); rv = Operation.Success.ToString(); } catch (Exception ex) { rv = ex.Message; } return(rv); }
public DataTable Insert_Update_DesignationGroup(string procedure, string callname, Common_DesignationGroup objDesignationGroup) { 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_DesGroupID", objDesignationGroup.DesGroupID)); cmd.Parameters.Add(new SqlParameter("@p_DesGroupName", objDesignationGroup.DesGroupName)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }
public string SaveDesignationGroup(Common_DesignationGroup objDesignationGroup) { return(_DesignationGroupDataService.SaveDesignationGroup(objDesignationGroup)); }