protected MRS.Model.MPeriod Parse(SqlDataReader Reader)
{
MRS.Model.MPeriod mPeriod = new MRS.Model.MPeriod();
mPeriod.Id = Convert.ToInt32(Reader[DSL.MPeriod.ID_FIELD]);
mPeriod.Name = Reader[DSL.MPeriod.NAME_FIELD].ToString().Trim();
mPeriod.BeginDate = Convert.ToDateTime(Reader[DSL.MPeriod.BEGIN_DATE_FIELD]);
mPeriod.EndDate = Convert.ToDateTime(Reader[DSL.MPeriod.END_DATE_FIELD].ToString().Trim());
return(mPeriod);
}
public IList <MRS.Model.MPeriod> GetMPeriod()
{
IList <MRS.Model.MPeriod> mPeriods = new List <MRS.Model.MPeriod>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, CommandText.SELECT_MPERIOD, null))
{
while (reader.Read())
{
MRS.Model.MPeriod mPeriod = Parse(reader);
mPeriods.Add(mPeriod);
}
}
return(mPeriods);
}
