Exemple #1
0
        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);
        }
Exemple #2
0
        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);
        }
Exemple #3
0
        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);
        }