public static T_CMS_Master_SalutationCollection Search(SearchFilter SearchKey) { T_CMS_Master_SalutationCollection collection = new T_CMS_Master_SalutationCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_Salutation_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey))) { while (reader.Read()) { T_CMS_Master_Salutation obj = new T_CMS_Master_Salutation(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_CMS_Master_SalutationCollection GetbyUser(string CreatedUser) { T_CMS_Master_SalutationCollection collection = new T_CMS_Master_SalutationCollection(); T_CMS_Master_Salutation obj; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_Salutation_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser))) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_CMS_Master_SalutationCollection GetAllItem() { T_CMS_Master_SalutationCollection collection = new T_CMS_Master_SalutationCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_Salutation_GetAll", null)) { while (reader.Read()) { T_CMS_Master_Salutation obj = new T_CMS_Master_Salutation(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }