public List <LeaveType> getLeaveType(string cleaveType)
{
List <LeaveType> leaveTypeList = new List <LeaveType>();
string sql = "SELECT * FROM hr_tm_LeaveType WHERE cCode='" + cleaveType + "'";
DataSet ds = db.Query(sql);
if (ds != null)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
LeaveType leaveType = new LeaveType();
PropertyInfo[] propertys = leaveType.GetType().GetProperties();
int i = 0;
foreach (PropertyInfo prop in propertys)
{
string filename = ds.Tables[0].Columns[i].ColumnName;
if (prop.Name.ToLower().Equals(filename.ToLower()))
{
var x = dr[filename] == null ? "" : dr[filename].ToString();
prop.SetValue(leaveType, x, null);
}
i++;
}
leaveTypeList.Add(leaveType);
}
}
return(leaveTypeList);
}
