public Suppliers EditarProveedor(int id, ProveedoresDTO proveedorDTO)
        {
            Suppliers proveedor = new Suppliers();
            try
            {
                proveedor = ObtenerProveedor(id.ToString());
                if (proveedor != null)
                {
                    proveedor.CompanyName = proveedorDTO.CompanyName;
                    proveedor.ContactName = proveedorDTO.ContactName;
                    proveedor.ContactTitle = proveedorDTO.ContactTitle;
                    proveedor.Address = proveedorDTO.Address;
                    proveedor.City = proveedorDTO.City;
                    proveedor.Region = proveedorDTO.Region;
                    proveedor.PostalCode = proveedorDTO.PostalCode;
                    proveedor.Country = proveedorDTO.Country;
                    proveedor.Phone = proveedorDTO.Phone;
                    proveedor.Fax = proveedorDTO.Fax;
                    proveedor.HomePage = proveedorDTO.HomePage;

                    _context.SaveChanges();
                }
            }
            catch (Exception)
            {

            }
            return proveedor;
        }
        public bool AgregarProveedor(ProveedoresDTO proveedorDTO)
        {
            bool agregado = false;

            try
            {
                Suppliers proveedor = new Suppliers();

                proveedor.CompanyName = proveedorDTO.CompanyName;
                proveedor.ContactName = proveedorDTO.ContactName;
                proveedor.ContactTitle = proveedorDTO.ContactTitle;
                proveedor.Address = proveedorDTO.Address;
                proveedor.City = proveedorDTO.City;
                proveedor.Region = proveedorDTO.Region;
                proveedor.PostalCode = proveedorDTO.PostalCode;
                proveedor.Country = proveedorDTO.Country;
                proveedor.Phone = proveedorDTO.Phone;
                proveedor.Fax = proveedorDTO.Fax;
                proveedor.HomePage = proveedorDTO.HomePage;

                _context.Suppliers.Add(proveedor);

                if (_context.SaveChanges() > 0)
                    agregado = true;
            }
            catch (Exception){}

            return agregado;
        }
        protected bool DatosAControles(Suppliers proveedor)
        {
            bool conversionExitosa = false;
            try
            {
                inputCompanyName.Value = (proveedor.CompanyName != null) ? proveedor.CompanyName.ToString() : "";
                inputContactName.Value = (proveedor.ContactName != null) ? proveedor.ContactName.ToString() : "";
                inputContactTitle.Value = (proveedor.ContactTitle != null) ? proveedor.ContactTitle.ToString() : "";
                inputAdress.Value = (proveedor.Address != null) ? proveedor.Address.ToString() : "";
                inputCity.Value = (proveedor.City != null) ? proveedor.City.ToString() : "";
                inputRegion.Value = (proveedor.Region != null) ? proveedor.Region.ToString() : "";
                inputPostalCode.Value = (proveedor.PostalCode != null) ? proveedor.PostalCode.ToString() : "";
                inputCountry.Value = (proveedor.Country != null) ? proveedor.Country.ToString() : "";
                inputPhone.Value = (proveedor.Phone != null) ? proveedor.Phone.ToString() : "";
                inputFax.Value = (proveedor.Fax != null) ? proveedor.Fax.ToString() : "";
                inputHomePage.Value = (proveedor.HomePage != null) ? proveedor.HomePage.ToString() : "";

                conversionExitosa = true;
            }
            catch (Exception)
            {

            }
            return conversionExitosa;
        }