public static CustomResponsibility GetCustomResponsibilityByCustomResponsibilityId(int customResponsibilityId) { Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement"); string sqlCommand = "GetCustomResponsibilityByCustomResponsibilityId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@CustomResponsibilityId", DbType.Int32, customResponsibilityId); db.AddOutParameter(dbCommand, "@Description", DbType.String, 50); db.ExecuteNonQuery(dbCommand); CustomResponsibility customResponsibility = new CustomResponsibility(); customResponsibility.CustomResponsibilityId = customResponsibilityId; customResponsibility.Description = db.GetParameterValue(dbCommand, "Description").ToString(); return(customResponsibility); }
public static List <CustomResponsibility> GetCustomResponsibilityList() { List <CustomResponsibility> list = new List <CustomResponsibility>(); Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement"); string sqlCommand = "GetCustomResponsibilityList"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { CustomResponsibility customResponsibility = new CustomResponsibility(); customResponsibility.CustomResponsibilityId = Convert.ToInt32(dataReader["CustomResponsibilityId"]); customResponsibility.Description = dataReader["Description"].ToString(); list.Add(customResponsibility); } } return(list); }