public TrainPlanStatus GetTrainPlanStatusInfo(int trainPlanStatusID)
{
TrainPlanStatus obj = new TrainPlanStatus();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_PLAN_STATUS_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_train_plan_status_id", DbType.Int32, trainPlanStatusID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
obj = CreateModelObject(dataReader);
}
}
return(obj);
}
public IList <TrainPlanStatus> GetAllTrainPlanStatusInfo()
{
IList <TrainPlanStatus> objPlanList = new List <TrainPlanStatus>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_PLAN_STATUS_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_train_plan_status_id", DbType.Int32, 0);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
TrainPlanStatus obj = CreateModelObject(dataReader);
objPlanList.Add(obj);
}
}
return(objPlanList);
}
