public void Insert(LoadClientRequest request)
{
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
ClientsEntity clientEntity = new ClientsEntity()
{
Name = request.Name,
Surname = request.Surname,
IdentificationNumber = request.IdentificationNumber,
IdTypeIdentification = request.IdTypeIdentification,
HomeStreet = request.HomeStreet,
HomeHeigth = request.HomeHeigth,
IdPostalCode = request.IdPostalCode,
Email = request.Email,
Phone = request.Phone
};
context.ClientsEntity.Add(clientEntity);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("ClientDataAccess.Insert : ERROR : " + ex.Message);
throw;
}
}
public GetClientResponse GetByEmail(GetClientRequest request)
{
GetClientResponse clientResponse = new GetClientResponse();
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
var query = context.ClientsEntity.Where
(c => c.Email == request.Email).FirstOrDefault();
GetClientResponse clientEntity = new GetClientResponse()
{
IdClient = query.IdClient,
Name = query.Name,
Surname = query.Surname,
IdentificationNumber = query.IdentificationNumber,
IdTypeIdentification = query.IdTypeIdentification,
HomeStreet = query.HomeStreet,
HomeHeigth = query.HomeHeigth,
IdPostalCode = query.IdPostalCode,
Email = query.Email,
Phone = query.Phone
};
clientResponse = clientEntity;
}
catch (Exception ex)
{
Console.WriteLine("ProductDataAccess.GetByEmail : ERROR : " + ex.Message);
throw;
}
return(clientResponse);
}
public void Insert(LoadProductRequest request)
{
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
ProductsEntity productEntity = new ProductsEntity()
{
Description = request.Description,
Name = request.Name,
IdMarca = request.idMarca,
Stock = request.Stock,
Price = request.Price,
IdCategory = request.IdCategory,
IdSubCategory = request.IdSubCategory,
Recipe = request.Recipe,
IdResoruce = request.IdResoruce
};
context.ProductsEntity.Add(productEntity);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("ProductDataAccess.Insert : ERROR : " + ex.Message);
throw;
}
}
public List <ProductDataAccessResponse> GetCatalogFilter(GetCatalogRequest request)
{
List <ProductDataAccessResponse> _dataAccessResponse = new List <ProductDataAccessResponse>();
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
var query = from p in context.ProductsEntity
join m in context.MarcasEntity on p.IdMarca equals m.IdMarca
join path in context.ResourcesEntity on p.IdResoruce equals path.IdResource
join cat in context.CategorysEntity on p.IdCategory equals cat.IdCategory
join subcat in context.SubCategorysEntity on p.IdSubCategory equals subcat.IdSubCategory
where (p.Price > request.PriceMin && p.Price < request.PriceMax && p.Stock > 0)
select new
{
ProductDataAccessResponse = new ProductDataAccessResponse
{
ProductCard = new ProductCardResponse
{
IdProduct = p.IdProduct,
Name = p.Name,
Marca = m.Description,
Price = p.Price,
Path = path.Path
},
CategoryUsed = new CategorysEntity
{
IdCategory = p.IdCategory,
Description = cat.Description
},
SubCategoryUsed = new SubCategorysEntity
{
IdSubCategory = p.IdSubCategory,
Description = subcat.Description,
IdCategory = subcat.IdCategory
},
MarcaUsed = new MarcasEntity
{
IdMarca = m.IdMarca,
Description = m.Description
}
}
};
if (query != null)
{
foreach (var obj in query)
{
_dataAccessResponse.Add(obj.ProductDataAccessResponse);
}
}
}
catch (Exception ex)
{
Console.WriteLine("ProductDataAccess.GetCatalogAll : ERROR : " + ex.Message);
throw;
}
return(_dataAccessResponse);
}
public List <ProductDataAccessResponse> GetFilters()
{
List <ProductDataAccessResponse> _dataAccessResponse = new List <ProductDataAccessResponse>();
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
var query = from p in context.ProductsEntity
join cat in context.CategorysEntity on p.IdCategory equals cat.IdCategory
join subcat in context.SubCategorysEntity on p.IdSubCategory equals subcat.IdSubCategory
join m in context.MarcasEntity on p.IdMarca equals m.IdMarca
where (p.Stock > 0)
select new
{
ProductDataAccessResponse = new ProductDataAccessResponse
{
CategoryUsed = new CategorysEntity
{
IdCategory = p.IdCategory,
Description = cat.Description
},
SubCategoryUsed = new SubCategorysEntity
{
IdSubCategory = p.IdSubCategory,
Description = subcat.Description,
IdCategory = subcat.IdCategory
},
MarcaUsed = new MarcasEntity
{
IdMarca = p.IdMarca,
Description = m.Description
}
}
};
if (query != null)
{
foreach (var obj in query)
{
_dataAccessResponse.Add(obj.ProductDataAccessResponse);
}
}
}
catch (Exception ex)
{
Console.WriteLine("ProductDataAccess.GetFilters : ERROR : " + ex.Message);
throw;
}
return(_dataAccessResponse);
}
public void ExportDate(LoadBuyRequest request)
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
var sendEmailSale = new SendEmailEntity()
{
Email = "*****@*****.**",
NameEmail = "Venta",
Subject = "Orden de compra n° " + request.IdOrder,
Body = "Nueva Venta! /br {Obj}"
};
sendEmailSale.Body = sendEmailSale.Body.Replace("{OrderNumber}", request.IdOrder.ToString());
sendEmailSale.Body = sendEmailSale.Body.Replace("{Obj}", request.ToString());
_mailer.SendEmailAsync(sendEmailSale);
}
public async Task <IActionResult> ExportDate()
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
var query = context.EmailsFormatEntity.Find(1);
var sendEmailEntity = new SendEmailEntity()
{
Email = "*****@*****.**",
NameEmail = "Remitente",
Subject = "Orden de compra n°" + 0001,
Body = query.Format
};
await _mailer.SendEmailAsync(sendEmailEntity);
return(NoContent());
}
public GetClientsResponse GetClients()
{
GetClientsResponse clientsResponse = new GetClientsResponse();
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
var query = context.ClientsEntity.ToList();
clientsResponse.ClientsEntities = query;
}
catch (Exception ex)
{
Console.WriteLine("ProductDataAccess.GetClients : ERROR : " + ex.Message);
throw;
}
return(clientsResponse);
}
public void LoadMarca(LoadMarcaRequest request)
{
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
MarcasEntity marcaEntity = new MarcasEntity()
{
Description = request.Description
};
context.MarcasEntity.Add(marcaEntity);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("ProductDataAccess.LoadMarca : ERROR : " + ex.Message);
throw;
}
}
public void LoadSubCategory(LoadSubCategoryRequest request)
{
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
SubCategorysEntity subCategoryEntity = new SubCategorysEntity()
{
Description = request.Description
};
context.SubCategorysEntity.Add(subCategoryEntity);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("ProductDataAccess.LoadSubCategory : ERROR : " + ex.Message);
throw;
}
}
public void Insert(LoadRecipeRequest request)
{
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
RecipesEntity recipe = new RecipesEntity()
{
Path = request.Path
};
context.RecipesEntity.Add(recipe);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("RecipeDataAccess.Insert : ERROR : " + ex.Message);
throw;
}
}
public void LoadNewsLetter(LoadNewsLetterRequest request)
{
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
NewsletterEntity newsletterEntity = new NewsletterEntity()
{
Email = request.Email,
Phone = request.Phone
};
context.NewsletterEntity.Add(newsletterEntity);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("ClientDataAccess.LoadNewsLetter : ERROR : " + ex.Message);
throw;
}
}
public void InsertDetail(BuyDetailRequest request)
{
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
BuysDetailsEntity buysDetailsEntity = new BuysDetailsEntity()
{
IdProduct = request.IdProduct,
Quantity = request.Quantity,
IdBuy = request.IdBuy
};
context.BuysDetailsEntity.Add(buysDetailsEntity);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("BuyDataAccess.InsertDetail : ERROR : " + ex.Message);
throw;
}
}
public ProductResponse GetByID(GetProductRequest request)
{
ProductResponse productResponse = new ProductResponse();
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
var query = from p in context.ProductsEntity
where (p.IdCategory == request.IdProduct)
join path in context.ResourcesEntity on p.IdResoruce equals path.IdResource
join marca in context.MarcasEntity on p.IdMarca equals marca.IdMarca
select new
{
productEntity = new ProductResponse()
{
IdProduct = p.IdProduct,
Description = p.Description,
Name = p.Name,
IdMarca = p.IdMarca,
Marca = marca.Description,
Stock = p.Stock,
Price = p.Price,
IdCategory = p.IdCategory,
IdSubCategory = p.IdSubCategory,
Recipe = p.Recipe,
Path = path.Path
}
};
if (query != null)
{
var firstQueryItem = query.FirstOrDefault();
productResponse = firstQueryItem.productEntity;
}
}
catch (Exception ex)
{
Console.WriteLine("ProductDataAccess.GetByID : ERROR : " + ex.Message);
throw;
}
return(productResponse);
}
public void Insert(BuyRequest request)
{
try
{
MASFARMACIADEVContext context = new MASFARMACIADEVContext();
BuysEntity buysEntity = new BuysEntity()
{
UploadDate = request.UploadDate,
TotalAmount = request.TotalAmount,
IdClient = request.IdClient,
IdOrder = request.IdOrder
};
context.BuysEntity.Add(buysEntity);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("BuyDataAccess.Insert : ERROR : " + ex.Message);
throw;
}
}
public ProductDataAccess()
{
context = new MASFARMACIADEVContext();
}
public ClientDataAccess()
{
context = new MASFARMACIADEVContext();
}
public BuyDataAccess()
{
context = new MASFARMACIADEVContext();
}
public OrderDataAccess()
{
context = new MASFARMACIADEVContext();
}