public static T_LMS_Master_AnnualLeaveCollection Search(SearchFilter SearchKey) { T_LMS_Master_AnnualLeaveCollection collection = new T_LMS_Master_AnnualLeaveCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_LMS_Master_AnnualLeave_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey))) { while (reader.Read()) { T_LMS_Master_AnnualLeave obj = new T_LMS_Master_AnnualLeave(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_LMS_Master_AnnualLeaveCollection GetbyUser(string CreatedUser) { T_LMS_Master_AnnualLeaveCollection collection = new T_LMS_Master_AnnualLeaveCollection(); T_LMS_Master_AnnualLeave obj; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_LMS_Master_AnnualLeave_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser))) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_LMS_Master_AnnualLeaveCollection GetAllItem() { T_LMS_Master_AnnualLeaveCollection collection = new T_LMS_Master_AnnualLeaveCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_LMS_Master_AnnualLeave_GetAll", null)) { while (reader.Read()) { T_LMS_Master_AnnualLeave obj = new T_LMS_Master_AnnualLeave(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }