public string Delete(ProductType oProductType, int nUserID)
        {
            string sReturnMessage = "";

            Connection.Open();
            Command.CommandText = ProductTypeDA.IUD(oProductType, EnumDBOperation.Delete, nUserID);
            try
            {
                Command.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                sReturnMessage = e.Message.Split('~')[0];
            }
            Connection.Close();
            return(sReturnMessage);
        }
        public ProductType IUD(ProductType oProductType, EnumDBOperation eDBAction, int nUserID)
        {
            Connection.Open();
            Command.CommandText = ProductTypeDA.IUD(oProductType, eDBAction, nUserID);

            SqlDataReader reader = Command.ExecuteReader();

            ProductType _oProductType = new ProductType();

            if (reader.HasRows)
            {
                _oProductType = MakeObject(reader);
            }
            reader.Close();

            Connection.Close();
            return(_oProductType);
        }