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