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