public ProdCatagorys GetsByString(string sString)
        {
            ProdCatagorys oProdCatagorys = new ProdCatagorys();

            try
            {
                SqlCommand cmd = new SqlCommand("SP_ProdCatagory_GetsByString", _conn);

                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add(new SqlParameter("@catId", SqlDbType.VarChar)).Value = sString;
                if (_conn.State == ConnectionState.Open)
                {
                }
                else
                {
                    cmd.Connection.Open();
                }
                IDataReader reader = cmd.ExecuteReader();

                oProdCatagorys = CreateObjects(reader);
                reader.Close();
                cmd.Dispose();
                cmd.Connection.Close();
            }
            catch (Exception e)
            {
                throw new ServiceException(e.Message, e);
            }
            return(oProdCatagorys);
        }
        public ProdCatagorys Gets()
        {
            ProdCatagorys oProdCatagorys = new ProdCatagorys();

            try
            {
                SqlCommand cmd = new SqlCommand("SP_ProdCatagory_Gets", _conn);

                cmd.CommandType = CommandType.StoredProcedure;
                if (_conn.State == ConnectionState.Open)
                {
                }
                else
                {
                    cmd.Connection.Open();
                }
                IDataReader reader = cmd.ExecuteReader();

                oProdCatagorys = CreateObjects(reader);
                reader.Close();
                cmd.Dispose();
                cmd.Connection.Close();
            }
            catch (Exception e)
            {
                throw new ServiceException(e.Message, e);
            }
            return(oProdCatagorys);
        }
        private ProdCatagorys CreateObjects(IDataReader oReader)
        {
            ProdCatagorys oProdCatagorys = new ProdCatagorys();
            NullHandler   oHandler       = new NullHandler(oReader);

            while (oReader.Read())
            {
                ProdCatagory oItem = CreateObject(oHandler);
                oProdCatagorys.Add(oItem);
            }
            return(oProdCatagorys);
        }