public IEnumerable <ApiProducts.Library.Models.ProductoRes> GetProductsIds(object value)
{
var ConnectionStringLocal = _configuration.GetValue <string>("CadenaConexion");
var jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(value);
List <ApiProducts.Library.Models.ProductoRes> list = new List <ApiProducts.Library.Models.ProductoRes>();
ApiProducts.Library.Models.Producto objProducto = new ApiProducts.Library.Models.Producto();
//string json = @"[ {""idPedido"": 1, ""idProducto"": 1, ""cantidad"": 1 }]";
//Deserialize the data
var obj = JsonConvert.DeserializeObject <List <ApiProducts.Library.Models.ProductoMinRes> >(value.ToString());
//Loop thrrouch values and save the details into database
foreach (ApiProducts.Library.Models.ProductoMinRes p in obj)
{
using (IProduct producto = Factorizador.CrearConexionServicio(ApiProducts.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
objProducto = producto.GetProduct(p.Id);
list.Add(new ApiProducts.Library.Models.ProductoRes()
{
Id = objProducto.Id,
Titulo = objProducto.Titulo,
Plataforma = objProducto.Plataforma,
Imagen = objProducto.Imagen,
Imagen2 = objProducto.Imagen2,
Imagen3 = objProducto.Imagen3,
PrecioVenta = objProducto.PrecioVenta,
Edicion = objProducto.FechaLanzamiento,
IdCarrito = p.IdCarrito
});
}
}
return(list);
}
//public IActionResult Login([FromBody]Models.Login user)
//{
// if (user == null)
// return BadRequest("Invalid client request");
// //Lógica de consulta a una base de datos
// if (user.Nick == "mtwdm" && user.Password == "123123")
// {
// var secretKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes("rgatilanov-2019-mtwdm"));
// var signinCredentials = new SigningCredentials(secretKey, SecurityAlgorithms.HmacSha256);
// var tokeOptions = new JwtSecurityToken(
// issuer: "https://userapi2.azurewebsites.net",
// audience: "https://userapi2.azurewebsites.net",
// claims: new List<System.Security.Claims.Claim>(),
// expires: DateTime.Now.AddMinutes(5),
// signingCredentials: signinCredentials
// );
// var tokenString = new JwtSecurityTokenHandler().WriteToken(tokeOptions);
// return Ok(new { Token = tokenString });
// }
// else
// return Unauthorized();
//}
public Api.Library.Models.User Login([FromBody] Api.Library.Models.UserMin user)
{
var ConnectionStringLocal = _configuration.GetValue <string>("ConnectionStringLocal");
var ConnectionStringAzure = _configuration.GetValue <string>("ConnectionStringAzure");
using (ILogin Login = Factorizador.CrearConexionServicio(Api.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
Api.Library.Models.User objusr = Login.EstablecerLogin(user.Nick, user.Password);
if (objusr.ID > 0)
{
var secretKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes("maestria-mtwdm-2019"));
var signinCredentials = new SigningCredentials(secretKey, SecurityAlgorithms.HmacSha256);
var tokeOptions = new JwtSecurityToken(
issuer: "http://localhost:44308",
audience: "http://localhost:44308",
claims: new List <System.Security.Claims.Claim>(),
expires: DateTime.Now.AddMinutes(5),
signingCredentials: signinCredentials
);
var tokenString = new JwtSecurityTokenHandler().WriteToken(tokeOptions);
objusr.JWT = tokenString;
}
return(objusr);
}
}
public IEnumerable <APIUsers.Library.Models.User> GetUsers()
{
#if false
List <User> users = new List <User>();
users.Add(new Models.User()
{
CreateDate = DateTime.Now,
ID = 1,
Name = "Ramón Gerardo",
Nick = "rgatilanov",
Password = null,
accountType = AccountType.Administrator
});
users.Add(new Models.User()
{
CreateDate = DateTime.Now,
ID = 2,
Name = "Juan Perez",
Nick = "juan.perez",
Password = null,
accountType = AccountType.Basic,
});
#endif
List <APIUsers.Library.Models.User> listUsers = new List <APIUsers.Library.Models.User>();
var ConnectionStringLocal = _configuration.GetValue <string>("ServidorLocal");
using (IUser User = Factorizador.CrearConexionServicio(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
listUsers = User.GetUsers();
}
return(listUsers);
}
public ActionResult <List <User> > GetAllUsers()
{
using (ILogin Login = Factorizador.CrearConexionServicio(Api.Library.Models.ConnectionType.MSSQL, ConnectionStringAzure))
{
List <Api.Library.Models.User> objusrs = Login.ObtenerUsers();
return(objusrs);
}
}
public IActionResult InsertOrderDetail(ApiProducts.Library.Models.PedidoCabDet value)
{
int id = 0;
int idPedido = 0;
var ConnectionStringLocal = _configuration.GetValue <string>("CadenaConexion");
var jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(value);
int insertCodigo = 0;
ApiProducts.Library.Models.Producto objProducto = new ApiProducts.Library.Models.Producto();
ApiProducts.Library.Models.PedidoCab objPedido = new ApiProducts.Library.Models.PedidoCab();
//string json = @"[ {""idPedido"": 1, ""idProducto"": 1, ""cantidad"": 1 }]";
//Deserialize the data
//var obj = JsonConvert.DeserializeObject<List<ApiProducts.Library.Models.PedidoCabDet>>(value.ToString());
//Loop thrrouch values and save the details into database
using (IOrder Order = Factorizador.CrearConexionServicioOrder(ApiProducts.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
idPedido = Order.InsertOrder(value.ClienteId, value.Total, "TC", "");
}
foreach (int p in value.ListaProductos)
{
using (ICode Code = Factorizador.CrearConexionServicioCode(ApiProducts.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
insertCodigo = Code.InsertCode(idPedido, p, Functions.RandomCodigo());
}
using (IProduct producto = Factorizador.CrearConexionServicio(ApiProducts.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
objProducto = producto.GetProduct(p);
}
using (IOrder Order = Factorizador.CrearConexionServicioOrder(ApiProducts.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
id = Order.InsertDetail(idPedido, p, insertCodigo, 1, objProducto.PrecioVenta);
}
using (IOrder order = Factorizador.CrearConexionServicioOrder(ApiProducts.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
objPedido = order.GetOrder(idPedido);
}
}
if (id > 0)
{
return(Ok(new
{
Id = objPedido,
Estatus = "success",
Code = 200,
Msg = "Detalle del pedido insertado correctamente!!"
}));
}
return(NotFound());
}
public int RemoveFromShoppingCart([FromBody] APIUsers.Library.Models.ShoppingCart shoppingCart)
{
int id = 0;
using (IShoppingCart Shopping = Factorizador.CrearConexionServicioShoppingCart(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal)){
id = Shopping.removeFromShoppingCart(shoppingCart.ID_User, shoppingCart.ID_Product);
}
return(id);
}
public IEnumerable<APIUsers.Library.Models.User> GetUsers()
{
List<APIUsers.Library.Models.User> listUsers = new List<APIUsers.Library.Models.User>();
var ConnectionStringLocal = _configuration.GetValue<string>("ServidorAzure");
using (IUser User = Factorizador.CrearConexionServicio(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal)){
listUsers = User.GetUsers();
}
return listUsers;
}
public IActionResult UpdateCategory([FromBody] APIUsers.Library.Models.Category value)
{
Boolean status;
using (ICategory Category = Factorizador.CrearConexionServicioCategory(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal)){
status = Category.UpdateCategory(value);
}
return(Ok(status));
}
public IActionResult GetProductBySearch(string search)
{
List <APIUsers.Library.Models.Product> listProducts = new List <APIUsers.Library.Models.Product>();
using (IProduct Product = Factorizador.CrearConexionServicioProduct(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal)) {
listProducts = Product.GetAllProductsBySearch(search);
}
return(Ok(new { listProducts }));
}
public Boolean UpdateUserDomicilio([FromBody] APIUsers.Library.Models.User value)
{
Boolean status;
var ConnectionStringLocal = _configuration.GetValue<string>("ServidorAzure");
using (IUser User = Factorizador.CrearConexionServicio(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
status = User.UpdateUser_domicilio(value);
}
return status;
}
public int UpdateShoppingCartQuantity([FromBody] APIUsers.Library.Models.ShoppingCart shoppingCart)
{
int id = 0;
using (IShoppingCart Shopping = Factorizador.CrearConexionServicioShoppingCart(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
id = Shopping.updateShoppingCart_ProductQuantity(shoppingCart.ID_User, shoppingCart.ID_Product, shoppingCart.Quantity);
}
return(id);
}
public int RemovefromWishList([FromBody] APIUsers.Library.Models.WishList wishList)
{
int id = 0;
using (IWishList WishList = Factorizador.CrearConexionServicioWishList(ConnectionType.MSSQL, ConnectionStringLocal))
{
id = WishList.removeFromWishList(wishList.ID_User, wishList.ID_Product);
}
return(id);
}
public IActionResult DeleteProduct(int id)
{
Boolean status;
using (IProduct Product = Factorizador.CrearConexionServicioProduct(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
status = Product.DeleteProduct(id);
}
return(Ok(status));
}
public IActionResult SearchWishList_Products(int id, string search)
{
List <APIUsers.Library.Models.Product> listProducts = new List <APIUsers.Library.Models.Product>();
using (IWishList WishList = Factorizador.CrearConexionServicioWishList(ConnectionType.MSSQL, ConnectionStringLocal))
{
listProducts = WishList.searchProducts_Wishlist(search, id);
}
return(Ok(new { listProducts }));
}
public IEnumerable <APIUsers.Library.Models.Promotion> GetPromotionsById([FromBody] APIUsers.Library.Models.Promotion value)
{
List <APIUsers.Library.Models.Promotion> listPromotions = new List <APIUsers.Library.Models.Promotion>();
using (IPromotion promotion = Factorizador.CrearConexionServicio3(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
listPromotions = promotion.GetPromotionsById(value.id);
}
return(listPromotions);
}
public IActionResult GetAllProductsByParamsPost([FromBody] APIUsers.Library.Models.Parametros value)
{
List <APIUsers.Library.Models.Product> listProducts = new List <APIUsers.Library.Models.Product>();
using (IProduct Product = Factorizador.CrearConexionServicioProduct(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
listProducts = Product.GetAllProductsByParams(value);
}
return(Ok(new { listProducts }));
}
public string GetPromotions(int idUser)
{
string listShopping = "";
using (ICheckout chk = Factorizador.CrearConexionServicio2(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
listShopping = chk.getShoping(idUser);
}
return(listShopping);
}
public IActionResult GetCategoriesBySearch(string search)
{
List <APIUsers.Library.Models.Category> list = new List <APIUsers.Library.Models.Category>();
using (ICategory Category = Factorizador.CrearConexionServicioCategory(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
list = Category.GetAllCategoriesBySearch(search);
}
return(Ok(new { list }));
}
public IActionResult GetUserByNick(string nick)
{
APIUsers.Library.Models.User user = new APIUsers.Library.Models.User();
var ConnectionStringLocal = _configuration.GetValue<string>("ServidorAzure");
using (IUser User = Factorizador.CrearConexionServicio(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
user = User.GetUser(nick);
}
return Ok(new { user });
}
public IActionResult DeleteCategory(int id)
{
Boolean status;
using (ICategory Category = Factorizador.CrearConexionServicioCategory(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
status = Category.DeleteCategory(id);
}
return(Ok(status));
}
public int InsertCategory([FromBody] APIUsers.Library.Models.Category value)
{
int id = 0;
using (ICategory Category = Factorizador.CrearConexionServicioCategory(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
id = Category.InsertCategory(value);
}
return(id);
}
public int GetProductValidbyCode([FromBody] string code)
{
int userDAta = 0;
using (ICheckout chk = Factorizador.CrearConexionServicio2(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
userDAta = chk.getProductValidbyCode(code);
}
return(userDAta);
}
public IActionResult GetBrandBySelect()
{
List <APIUsers.Library.Models.Brand> list = new List <APIUsers.Library.Models.Brand>();
using (IBrand Brand = Factorizador.CrearConexionServicioBrand(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
list = Brand.obtenerMarcasSelected();
}
return(Ok(new { list }));
}
public int remove_promotion([FromBody] APIUsers.Library.Models.Promotion value)
{
int result = 0;
using (IPromotion promotion = Factorizador.CrearConexionServicio3(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
result = promotion.removePromotion(value.id);
}
return(result);
}
public int InsertProduct([FromBody] APIUsers.Library.Models.Product value)
{
int id = 0;
var ConnectionStringLocal = _configuration.GetValue <string>("ServidorAzure");
using (IProduct Product = Factorizador.CrearConexionServicioProduct(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
id = Product.InsertProduct(value);
}
return(id);
}
//[Authorize]
public IEnumerable <ApiProducts.Library.Models.Producto> GetProductsPlataforma(int id)//[FromBody] ApiProducts.Library.Models.ProductoMin value
{
List <ApiProducts.Library.Models.Producto> listProducts = new List <ApiProducts.Library.Models.Producto>();
var ConnectionStringLocal = _configuration.GetValue <string>("CadenaConexion");
using (IProduct product = Factorizador.CrearConexionServicio(ApiProducts.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
listProducts = product.GetProductsPlataforma(id);
}
return(listProducts);
}
public Boolean UpdateProduct([FromBody] APIUsers.Library.Models.Product value)
{
Boolean status;
var ConnectionStringLocal = _configuration.GetValue <string>("ServidorAzure");
using (IProduct Product = Factorizador.CrearConexionServicioProduct(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
status = Product.UpdateProduct(value);
}
return(status);
}
public IActionResult GetProduct(int id)
{
APIUsers.Library.Models.Product product = new Product();
var ConnectionStringLocal = _configuration.GetValue <string>("ServidorAzure");
using (IProduct Product = Factorizador.CrearConexionServicioProduct(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
product = Product.GetProduct(id);
}
return(Ok(new { product }));
}
//[Authorize]
public IEnumerable <ApiProducts.Library.Models.PedidoDet> GetOrderDetail(int id)//[FromBody] ApiProducts.Library.Models.PedidoCabMin value
{
List <ApiProducts.Library.Models.PedidoDet> listOrders = new List <ApiProducts.Library.Models.PedidoDet>();
var ConnectionStringLocal = _configuration.GetValue <string>("CadenaConexion");
using (IOrder order = Factorizador.CrearConexionServicioOrder(ApiProducts.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
listOrders = order.GetOrderDetail(id);
}
return(listOrders);
}
public IActionResult GetTop3ByCategory(string category, int id)
{
List <APIUsers.Library.Models.Product> listProducts = new List <APIUsers.Library.Models.Product>();
var ConnectionStringLocal = _configuration.GetValue <string>("ServidorAzure");
using (IProduct Product = Factorizador.CrearConexionServicioProduct(APIUsers.Library.Models.ConnectionType.MSSQL, ConnectionStringLocal))
{
listProducts = Product.GetTop3ByCategory(category, id);
}
return(Ok(new { listProducts }));
}
