public JsonResult DeleteClient(int id_cli)
{
bool result = false;
using (var bd = new bdgoldendatesEntities1())
{
try
{
var cli = bd.Clientes.Where(w => w.id_cli == id_cli).FirstOrDefault();
bd.Entry(cli).State = System.Data.Entity.EntityState.Deleted;
bd.SaveChanges();
result = true;
}
catch (Exception)
{
result = false;
}
////Borrado Logico
//if (user != null)
//{
// user.isActive = false;
// result = true;
//}
//else
//{
// result = false;
//}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult GetItem(int id_prod)
{
var item = new Producto();
using (var bd = new bdgoldendatesEntities1())
{
item = bd.Productos.Where(w => w.id_prod == id_prod).FirstOrDefault();
}
return(Json(item, JsonRequestBehavior.AllowGet));
}
public JsonResult GetClient(int id_cli)
{
var cli = new Cliente();
using (var bd = new bdgoldendatesEntities1())
{
cli = bd.Clientes.Where(w => w.id_cli == id_cli).FirstOrDefault();
}
return(Json(cli, JsonRequestBehavior.AllowGet));
}
public JsonResult GetUser(int id_user)
{
var user = new Usuario();
using (var bd = new bdgoldendatesEntities1())
{
user = bd.Usuarios.Where(w => w.id_user == id_user).FirstOrDefault();
}
return(Json(user, JsonRequestBehavior.AllowGet));
}
public JsonResult ListClient()
{
//var _userResponse = new UserResponse();
var cli = new List <Cliente>();
using (var bd = new bdgoldendatesEntities1())
{
cli = bd.Clientes.ToList();
}
return(Json(cli, JsonRequestBehavior.AllowGet));
}
public JsonResult ListUsers()
{
//var _userResponse = new UserResponse();
var user = new List <Usuario>();
using (var bd = new bdgoldendatesEntities1())
{
user = bd.Usuarios.ToList();
}
return(Json(user, JsonRequestBehavior.AllowGet));
}
public JsonResult LoginUsers(LoginRequest _userData)
{
var _LoginResponse = new LoginResponse();
using (var bd = new bdgoldendatesEntities1())
{
var usuario = bd.Usuarios.Where(w => w.username == _userData.username && w.password == _userData.password).FirstOrDefault();
if (usuario != null)
{
_LoginResponse.id_user = usuario.id_user;
_LoginResponse.username = usuario.username;
_LoginResponse.nombre = usuario.nombre;
_LoginResponse.apellido = usuario.apelllido;
}
}
return(Json(_LoginResponse, JsonRequestBehavior.DenyGet));
}
public JsonResult EditItems(ProductoRequest _itemRequest)
{
var _itemResponse = new ProductoResponse();
using (var bd = new bdgoldendatesEntities1())
{
var item = bd.Productos.Where(w => w.id_prod == _itemRequest.id_prod).FirstOrDefault();
item.description = _itemRequest.description;
item.cantidad = _itemRequest.cantidad;
item.stockmin = _itemRequest.stockmin;
item.stockmax = _itemRequest.stockmax;
bd.Entry(item).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
_itemResponse.id_prod = item.id_prod;
}
return(Json(_itemResponse, JsonRequestBehavior.DenyGet));
}
public JsonResult EditClient(ClientRequest _clientRequest)
{
var _clientResponse = new ClientRequest();
using (var bd = new bdgoldendatesEntities1())
{
var cli = bd.Clientes.Where(w => w.id_cli == _clientRequest.id_cli).FirstOrDefault();
cli.nombre = _clientRequest.nombre;
cli.apellido = _clientRequest.apellido;
cli.telefono = _clientRequest.telefono;
cli.direccion = _clientRequest.direccion;
bd.Entry(cli).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
_clientResponse.id_cli = cli.id_cli;
}
return(Json(_clientResponse, JsonRequestBehavior.DenyGet));
}
public JsonResult AddItem(ProductoRequest _ProductoRequest)
{
var _ProductoResponse = new ProductoResponse();
using (var bd = new bdgoldendatesEntities1())
{
var item = new Producto();
item.description = _ProductoRequest.description;
item.cantidad = _ProductoRequest.cantidad;
item.stockmin = _ProductoRequest.stockmin;
item.stockmax = _ProductoRequest.stockmax;
item.FechaRegistro = DateTime.Now;
bd.Entry(item).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
_ProductoResponse.id_prod = item.id_prod;
}
return(Json(_ProductoResponse, JsonRequestBehavior.DenyGet));
}
public JsonResult AddClient(ClientRequest _clientRequest)
{
var _clientResponse = new ClientResponse();
using (var bd = new bdgoldendatesEntities1())
{
var cli = new Cliente();
cli.nombre = _clientRequest.nombre;
cli.apellido = _clientRequest.apellido;
cli.telefono = _clientRequest.telefono;
cli.direccion = _clientRequest.direccion;
//user.birthday= DateTime.Now;
bd.Entry(cli).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
_clientResponse.id_cli = cli.id_cli;
}
return(Json(_clientResponse, JsonRequestBehavior.DenyGet));
}
public JsonResult AddUsers(UserRequest _userRequest)
{
var _userResponse = new UserResponse();
using (var bd = new bdgoldendatesEntities1())
{
var user = new Usuario();
user.username = _userRequest.username;
user.password = _userRequest.password;
user.nombre = _userRequest.nombre;
user.apelllido = _userRequest.apellido;
//user.birthday = _userRequest.birthday;
user.birthday = DateTime.Now;
user.IsActive = true;
user.FechaRegistro = DateTime.Now;
bd.Entry(user).State = System.Data.Entity.EntityState.Added;
bd.SaveChanges();
_userResponse.id_user = user.id_user;
}
return(Json(_userResponse, JsonRequestBehavior.DenyGet));
}
public JsonResult ListItems()
{
//var _userResponse = new UserResponse();
var items = new List <ProductoResponse>();
using (var bd = new bdgoldendatesEntities1())
{
//items = bd.Items.ToList();
var ListItem = bd.Productos.ToList();
foreach (var item in ListItem)
{
items.Add(new ProductoResponse()
{
description = item.description,
cantidad = (int)item.cantidad,
stockmin = (int)item.stockmin,
stockmax = (int)item.stockmax,
id_prod = item.id_prod
});
}
}
return(Json(items, JsonRequestBehavior.AllowGet));
}
