//Trae por los que sean False
#region Get all Product False
public List <ProductBE> GetProductFAll()
{
List <ProductBE> lstprodf = new List <ProductBE>();
ProductMasterEntities BDPM = new ProductMasterEntities();
try
{
lstprodf = (from Product in BDPM.Product
where Product.StateProduct == false
select new ProductBE
{
IdProduct = Product.IdProduct,
NameProduct = Product.NameProduct,
ReleaseDate = Product.ReleaseDate,
Email = Product.Email,
IdCountry = Product.IdCountry,
NameCountry = Product.Country.NameCountry,
Cost = Product.Cost,
UnitsAvailable = Product.UnitsAvailable,
SoldUnits = Product.SoldUnits,
StateProduct = Product.StateProduct
}).OrderBy(x => x.ReleaseDate).ThenBy(x => x.StateProduct).ToList();
}
catch (Exception EX)
{
}
finally
{
BDPM.Dispose();
}
return(lstprodf);
}
public ProductBE SearchIdProduct(int SEARIDPRO)
{
ProductMasterEntities BDMP = new ProductMasterEntities();
ProductBE idprod = new ProductBE();
try
{
idprod = (from Product in BDMP.Product
where Product.IdProduct == SEARIDPRO
select new ProductBE
{
IdProduct = Product.IdProduct,
NameProduct = Product.NameProduct,
ReleaseDate = Product.ReleaseDate,
Email = Product.Email,
IdCountry = Product.IdCountry,
NameCountry = Product.NameProduct,
Cost = Product.Cost,
UnitsAvailable = Product.UnitsAvailable,
SoldUnits = Product.SoldUnits,
StateProduct = Product.StateProduct,
}).FirstOrDefault();
}
catch (Exception EX)
{
}
finally
{
BDMP.Dispose();
}
return(idprod);
}
public AnswerResponseBE InsertProduct(ProductBE IPROD)
{
AnswerResponseBE AR = new AnswerResponseBE();
ProductMasterEntities BDPM = new ProductMasterEntities();
try
{
int CountProd = 0;
CountProd = BDPM.Product.Where(x => x.IdProduct == IPROD.IdProduct).ToList().Count();
if (CountProd == 0)
{
Product PROD = new Product();
PROD.IdProduct = IPROD.IdProduct;
PROD.NameProduct = IPROD.NameProduct;
PROD.ReleaseDate = IPROD.ReleaseDate;
PROD.Email = IPROD.Email;
PROD.IdCountry = IPROD.IdCountry;
PROD.Cost = IPROD.Cost;
PROD.UnitsAvailable = IPROD.UnitsAvailable;
PROD.SoldUnits = IPROD.SoldUnits;
PROD.StateProduct = IPROD.StateProduct;
BDPM.Product.Add(PROD);
BDPM.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha insertado el producto correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El producto ya existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDPM.Dispose();
}
return(AR);
}
public AnswerResponseBE UpdateProduct(ProductBE UPROD)
{
AnswerResponseBE AR = new AnswerResponseBE();
ProductMasterEntities BDPM = new ProductMasterEntities();
try
{
Product product = new Product();
product = BDPM.Product.Where(x => x.IdProduct == UPROD.IdProduct).FirstOrDefault();
if (product != null)
{
product.IdProduct = UPROD.IdProduct;
product.NameProduct = UPROD.NameProduct;
product.ReleaseDate = UPROD.ReleaseDate;
product.Email = UPROD.Email;
product.IdCountry = UPROD.IdCountry;
product.Cost = UPROD.Cost;
product.UnitsAvailable = UPROD.UnitsAvailable;
product.SoldUnits = UPROD.SoldUnits;
product.StateProduct = UPROD.StateProduct;
BDPM.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha actualizado el producto correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro no existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDPM.Dispose();
}
return(AR);
}
public List <CountryBE> GetCountryAll()
{
List <CountryBE> ltscate = new List <CountryBE>();
ProductMasterEntities BDPM = new ProductMasterEntities();
try
{
ltscate = (from Country in BDPM.Country
select new CountryBE
{
IdCountry = Country.IdCountry,
NameCountry = Country.NameCountry
}).ToList();
}
catch (Exception EX)
{
}
finally
{
BDPM.Dispose();
}
return(ltscate);
}