//public static TimeLogCollection GetAllItem()
//{
// TimeLogCollection collection = new TimeLogCollection();
// using (var reader = SqlHelper.ExecuteReader("TimeLog_GetAll", null))
// {
// while (reader.Read())
// {
// TimeLog obj = new TimeLog();
// obj = GetItemFromReader(reader);
// collection.Add(obj);
// }
// }
// return collection;
//}
public static TimeLogCollection Search(SearchFilter SearchKey)
{
TimeLogCollection collection = new TimeLogCollection();
using (var reader = SqlHelper.ExecuteReader("TimeLog_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey)))
{
while (reader.Read())
{
TimeLog obj = new TimeLog();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static T_CMS_Master_EmploymentTypeCollection Search(SearchFilter SearchKey)
{
T_CMS_Master_EmploymentTypeCollection collection = new T_CMS_Master_EmploymentTypeCollection();
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_EmploymentType_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey)))
{
while (reader.Read())
{
T_CMS_Master_EmploymentType obj = new T_CMS_Master_EmploymentType();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static T_CMS_InterfaceLacviet_WorkingHoursCollection Search(SearchFilter SearchKey)
{
T_CMS_InterfaceLacviet_WorkingHoursCollection collection = new T_CMS_InterfaceLacviet_WorkingHoursCollection();
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_InterfaceLacviet_WorkingHours_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey)))
{
while (reader.Read())
{
T_CMS_InterfaceLacviet_WorkingHours obj = new T_CMS_InterfaceLacviet_WorkingHours();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static ls_PayrollDOWS_RBVHCollection Search(SearchFilter SearchKey)
{
ls_PayrollDOWS_RBVHCollection collection = new ls_PayrollDOWS_RBVHCollection();
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "ls_PayrollDOWS_RBVH_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey)))
{
while (reader.Read())
{
ls_PayrollDOWS_RBVH obj = new ls_PayrollDOWS_RBVH();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}