public static IEnumerable <ls_PayrollDOWS_RBVH> GetSearch(SearchFilter value)
{
using (var reader = SqlHelper.ExecuteReader("ls_PayrollDOWS_RBVH", SearchFilterManager.SqlSearchDynParam(value)))
{
return(CommonHelper.DataReaderToList <ls_PayrollDOWS_RBVH>(reader));
}
}
/// <summary>
///
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public virtual IEnumerable <DNHLanguage> GetSearch(SearchFilter value)
{
using (var reader = SqlHelper.ExecuteReader("DNHLanguage_Search", SearchFilterManager.SqlSearchDynParam(value)))
{
return(CommonHelper.DataReaderToList <DNHLanguage>(reader));
}
}
//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 BranchCollection Search(SearchFilter SearchKey)
{
BranchCollection collection = new BranchCollection();
using (var reader = SqlHelper.ExecuteReader("Branch_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
Branch obj = new Branch();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static CompanyTreeMemberCollection Search(SearchFilter SearchKey)
{
CompanyTreeMemberCollection collection = new CompanyTreeMemberCollection();
using (var reader = SqlHelper.ExecuteReader("CompanyTreeMember_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
CompanyTreeMember obj = new CompanyTreeMember();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static ARCustomerWLTranCollection Search(SearchFilter SearchKey)
{
ARCustomerWLTranCollection collection = new ARCustomerWLTranCollection();
using (var reader = SqlHelper.ExecuteReader("ARCustomerWLTran_Search", SearchFilterManager.SqlSearchDynParam(SearchKey)))
{
while (reader.Read())
{
ARCustomerWLTran obj = new ARCustomerWLTran();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static ProviderRateCollection Search(SearchFilter SearchKey)
{
ProviderRateCollection collection = new ProviderRateCollection();
using (var reader = SqlHelper.ExecuteReader("ARProviderRate_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
ProviderRate obj = new ProviderRate();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static CustomerClassCollection Search(SearchFilter SearchKey)
{
CustomerClassCollection collection = new CustomerClassCollection();
using (var reader = SqlHelper.ExecuteReader("CustomerClass_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
CustomerClass obj = new CustomerClass();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static QueuedEmailCollection Search(SearchFilter SearchKey)
{
QueuedEmailCollection collection = new QueuedEmailCollection();
using (var reader = SqlHelper.ExecuteReader("QueuedEmail_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
QueuedEmail obj = new QueuedEmail();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static ScheduleTaskCollection Search(SearchFilter SearchKey)
{
ScheduleTaskCollection collection = new ScheduleTaskCollection();
using (var reader = SqlHelper.ExecuteReader("ScheduleTask_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
ScheduleTask obj = new ScheduleTask();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static UsersInRolesCollection Search(SearchFilter SearchKey)
{
UsersInRolesCollection collection = new UsersInRolesCollection();
using (var reader = SqlHelper.ExecuteReader("UsersInRoles_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
UsersInRoles obj = new UsersInRoles();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static UserInfoCollection Search(SearchFilter SearchKey)
{
UserInfoCollection collection = new UserInfoCollection();
using (var reader = SqlHelper.ExecuteReader("UserInfo_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
UserInfo obj = new UserInfo();
obj = GetItemFromReader(reader);
obj.userLogin.Password = "******";
collection.Add(obj);
}
}
return(collection);
}
public static T_TMS_External_Atd_ScanTimeCollection Search(SearchFilter SearchKey)
{
T_TMS_External_Atd_ScanTimeCollection collection = new T_TMS_External_Atd_ScanTimeCollection();
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_TMS_External_Atd_ScanTime_Search", SearchFilterManager.SqlSearchConditionNoCompany(SearchKey)))
{
while (reader.Read())
{
T_TMS_External_Atd_ScanTime obj = new T_TMS_External_Atd_ScanTime();
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);
}
/// <summary>
///
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public virtual IEnumerable <DNHUserInRoles> GetSearch(SearchFilter value)
{
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "DNHUserInRoles_Search", SearchFilterManager.SqlSearchDynParam(value)))
{
return(CommonHelper.DataReaderToList <DNHUserInRoles>(reader));
}
}
public static T_LMS_Trans_LeaveStoryCollection Search(SearchFilter SearchKey)
{
T_LMS_Trans_LeaveStoryCollection collection = new T_LMS_Trans_LeaveStoryCollection();
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_LMS_Trans_LeaveStory_Search", SearchFilterManager.SqlSearchConditionNoCompany(SearchKey)))
{
while (reader.Read())
{
T_LMS_Trans_LeaveStory obj = new T_LMS_Trans_LeaveStory();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
/// <summary>
///
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public virtual IEnumerable <T_TMS_EmployeeTimesheetWeeklyDetails> GetSearch(SearchFilter value)
{
using (var reader = SqlHelper.ExecuteReader("T_TMS_EmployeeTimesheetWeeklyDetails_Search", SearchFilterManager.SqlSearchDynParam(value)))
{
return(CommonHelper.DataReaderToList <T_TMS_EmployeeTimesheetWeeklyDetails>(reader));
}
}
public static LocaleStringResourceCollection Search(SearchFilter SearchKey)
{
LocaleStringResourceCollection collection = new LocaleStringResourceCollection();
using (var reader = SqlHelper.ExecuteReader("DNHLocaleStringResource_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
LocaleStringResource obj = new LocaleStringResource();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
