public List<holidayreg> FillHolidayData(RequestResponse request)
{
List<holidayreg> ListHoliday = new List<holidayreg>();
DataSet ds = null;
try
{
if (ds == null)
{
ds = new DataSet();
SqlParameter[] inputPara = new SqlParameter[2];
inputPara[0] = new SqlParameter(BALResource.PayrollResources.HolidayID, request.HollidayReg.HolidayID);
inputPara[1] = new SqlParameter(BALResource.PayrollResources.Mode, request.HollidayReg.Mode);
ds = LoadGridData(BALResource.PayrollResources.ProcedueHolidaySelectDelete, inputPara);
DataTable dt = ds.Tables[0];
HolidayReg objHoliday = new HolidayReg();
for (int row = 0; row < dt.Rows.Count; row++)
{
objHoliday = new HolidayReg();
foreach (DataColumn dc in dt.Columns)
{
foreach (PropertyInfo prop in objHoliday.GetType().GetProperties())
{
if (prop.Name == dc.ColumnName && prop.CanWrite)
{
if (dt.Rows[row][dc.ColumnName] != DBNull.Value)
{
prop.SetValue(objHoliday, dt.Rows[row][dc.ColumnName], null);
}
}
}
}
ListHoliday.Add(objHoliday);
}
}
}
catch (Exception ex)
{
throw ex;
}
return ListHoliday;
}