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); }