CONTROLLERS

#nullable disable
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
[Authorize(Roles = "Administrador,Bodeguero")]
public class CategoriaProductoesController : Controller
{
private readonly storeplacedbContext _context;

public CategoriaProductoesController(storeplacedbContext context)

{
_context = context;
}

// GET: CategoriaProductoes
public async Task<IActionResult> Index()
{
[Link] = TempData["Message"];
[Link] = TempData["class"];
[Link] = TempData["icon"];
return View(await _context.[Link]());
}

// GET: CategoriaProductoes/Details/5
public async Task<IActionResult> Details(int? id)
{
if (id == null)
{
return NotFound();
}

var categoriaProducto = await _context.CategoriaProductos

.FirstOrDefaultAsync(m => [Link] == id);
if (categoriaProducto == null)
 {
return NotFound();
}

return View(categoriaProducto);
}

// GET: CategoriaProductoes/Create
public IActionResult Create()
{
[Link] = TempData["Message"];
return View();
}

// POST: CategoriaProductoes/Create
// To protect from overposting attacks, enable the specific
properties you want to bind to.
// For more details, see [Link]
LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult>
Create([Bind("Idcategoria,Descripcion")] CategoriaProducto
categoriaProducto)
{
if ([Link])
{
_context.Add(categoriaProducto);
await _context.SaveChangesAsync();
TempData["Message"] = "El registro se guardo correctamente";
TempData["class"] = "alert alert-success alert-dismissible
fade show";
TempData["icon"] = "bi bi-check-circle me-1";
return RedirectToAction(nameof(Index));
}
else
{
TempData["Message"] = "Llene todos los campos
correctamente";
}
return View(categoriaProducto);
}

// GET: CategoriaProductoes/Edit/5
public async Task<IActionResult> Edit(int? id)
 {
if (id == null)
{
return NotFound();
}

var categoriaProducto = await

_context.[Link](id);
if (categoriaProducto == null)
{
return NotFound();
}
return View(categoriaProducto);
}

// POST: CategoriaProductoes/Edit/5
// To protect from overposting attacks, enable the specific
properties you want to bind to.
// For more details, see [Link]
LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Edit(int id,
[Bind("Idcategoria,Descripcion")] CategoriaProducto categoriaProducto)
{
if (id != [Link])
{
return NotFound();
}

if ([Link])
{
try
{
_context.Update(categoriaProducto);
TempData["Message"] = "El registro se actualizo
correctamente";
TempData["class"] = "alert alert-success alert-
dismissible fade show";
TempData["icon"] = "bi bi-check-circle me-1";

await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
 if (!
CategoriaProductoExists([Link]))
{
return NotFound();
}
else
{
throw;
}
}
return RedirectToAction(nameof(Index));
}

return View(categoriaProducto);
}

// GET: CategoriaProductoes/Delete/5
public async Task<IActionResult> Delete(int? id)
{
if (id == null)
{
return NotFound();
}

var categoriaProducto = await _context.CategoriaProductos

.FirstOrDefaultAsync(m => [Link] == id);
if (categoriaProducto == null)
{
return NotFound();
}

return View(categoriaProducto);
}

// POST: CategoriaProductoes/Delete/5
[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public async Task<IActionResult> DeleteConfirmed(int id)
{
var categoriaProducto = await
_context.[Link](id);
_context.[Link](categoriaProducto);
TempData["Message"] = $"La categoria
'{[Link]}' se elimino correctamente";
 TempData["class"] = "alert alert-info alert-dismissible fade
show";
TempData["icon"] = "bi bi-info-circle me-1";
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}

private bool CategoriaProductoExists(int id)

{
return _context.[Link](e => [Link] ==
id);
}
}
}

#nullable disable
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
[Authorize(Roles = "Administrador,Cajero")]
public class ClientesController : Controller
{
private readonly storeplacedbContext _context;

public ClientesController(storeplacedbContext context)

{
_context = context;
}

// GET: Clientes
public async Task<IActionResult> Index()
{
[Link] = TempData["Message"];
 [Link] = TempData["class"];
[Link] = TempData["icon"];
var storeplacedbContext = _context.[Link](c =>
[Link]);
return View(await [Link]());
}

// GET: Clientes/Details/5
public async Task<IActionResult> Details(int? id)
{
if (id == null)
{
return NotFound();
}

var cliente = await _context.Clientes

.Include(c => [Link])
.FirstOrDefaultAsync(m => [Link] == id);
if (cliente == null)
{
return NotFound();
}

return View(cliente);
}

// GET: Clientes/Create
public IActionResult Create()
{
ViewData["Idctgcliente"] = new
SelectList(_context.CategoriaClientes, "Idcategoria", "Idcategoria");
return View();
}

// POST: Clientes/Create
// To protect from overposting attacks, enable the specific
properties you want to bind to.
// For more details, see [Link]
LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult>
Create([Bind("Idcliente,Nit,Idctgcliente,Nombre,Apellido,Direccion,Telefono"
)] Cliente cliente)
{
 if ([Link])
{
_context.Add(cliente);
TempData["Message"] = "El registro se guardo correctamente";
TempData["class"] = "alert alert-success alert-dismissible
fade show";
TempData["icon"] = "bi bi-check-circle me-1";
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
ViewData["Idctgcliente"] = new
SelectList(_context.CategoriaClientes, "Idcategoria", "Idcategoria",
[Link]);
return View(cliente);
}

// GET: Clientes/Edit/5
public async Task<IActionResult> Edit(int? id)
{
if (id == null)
{
return NotFound();
}

var cliente = await _context.[Link](id);

if (cliente == null)
{
return NotFound();
}
ViewData["Idctgcliente"] = new
SelectList(_context.CategoriaClientes, "Idcategoria", "Idcategoria",
[Link]);
return View(cliente);
}

// POST: Clientes/Edit/5
// To protect from overposting attacks, enable the specific
properties you want to bind to.
// For more details, see [Link]
LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Edit(int id,
[Bind("Idcliente,Nit,Idctgcliente,Nombre,Apellido,Direccion,Telefono")]
Cliente cliente)
 {
if (id != [Link])
{
return NotFound();
}

if ([Link])
{
try
{
_context.Update(cliente);
TempData["Message"] = "El registro se actualizo
correctamente";
TempData["class"] = "alert alert-success alert-
dismissible fade show";
TempData["icon"] = "bi bi-check-circle me-1";
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ClienteExists([Link]))
{
return NotFound();
}
else
{
throw;
}
}
return RedirectToAction(nameof(Index));
}
ViewData["Idctgcliente"] = new
SelectList(_context.CategoriaClientes, "Idcategoria", "Idcategoria",
[Link]);
return View(cliente);
}

// GET: Clientes/Delete/5
public async Task<IActionResult> Delete(int? id)
{
if (id == null)
{
return NotFound();
}
 var cliente = await _context.Clientes
.Include(c => [Link])
.FirstOrDefaultAsync(m => [Link] == id);
if (cliente == null)
{
return NotFound();
}

return View(cliente);
}

// POST: Clientes/Delete/5
[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public async Task<IActionResult> DeleteConfirmed(int id)
{
var cliente = await _context.[Link](id);
_context.[Link](cliente);
TempData["Message"] = $"El Cliente '{[Link]}
{[Link]}' se elimino correctamente";
TempData["class"] = "alert alert-info alert-dismissible fade
show";
TempData["icon"] = "bi bi-info-circle me-1";
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}

private bool ClienteExists(int id)

{
return _context.[Link](e => [Link] == id);
}
}
}

using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
public class HomeController : Controller
 {
private readonly ILogger<HomeController> _logger;
private readonly storeplacedbContext _context;

public HomeController(ILogger<HomeController> logger,

storeplacedbContext context)
{
_logger = logger;
_context = context;
}

public IActionResult Index()

{
var Productos = _context.[Link]().Count;
var Proveedores = _context.[Link]().Count;
var today = [Link]("dd/MM/yyyy");
var mes = [Link]("MM/yyyy");
var año = [Link]("yyyy");
var VentasHoy = _context.[Link]("SELECT * FROM venta
WHERE date_format(FECHA, '%d/%m/%Y') = {0}",
[Link]()).ToList().Count;
var VentasMes = _context.[Link]("SELECT * FROM venta
WHERE date_format(FECHA, '%m/%Y') = {0}", [Link]()).ToList().Count;
var VentasAño = _context.[Link]("SELECT * FROM venta
WHERE date_format(FECHA, '%Y') = {0}", añ[Link]()).ToList().Count;
Tuple<int, int, int, int, int> model = new Tuple<int, int, int,
int, int>(Productos, Proveedores, VentasHoy, VentasMes, VentasAño);
return View(model);
}

public IActionResult Privacy()

{
return View();
}

[ResponseCache(Duration = 0, Location = [Link],

NoStore = true)]
public IActionResult Error()
{
return View(new ErrorViewModel { RequestId =
[Link]?.Id ?? [Link] });
}
}
}
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
public class LoginController : Controller
{
private readonly storeplacedbContext _context;

public LoginController(storeplacedbContext context)

{
_context = context;
}

public IActionResult Index()

{
return View();
}

[HttpPost]
public async Task<IActionResult> Index(Usuario user)
{
Usuario _user = UserIsvalid(user);
if (_user != null)
{
var claims = new List<Claim>
{
new Claim([Link],
_user.[Link]()),
new Claim([Link], _user.Nombre + " " +
_user.Apellido),
new Claim([Link], _user.Correo),
};

[Link](new Claim([Link],
_user.[Link]));

var claimsIdentity = new ClaimsIdentity(claims,

[Link]);
 await
[Link]([Link],
new ClaimsPrincipal(claimsIdentity));

return RedirectToAction("Index", "Home");

}
else
{
return View();
}
}

public async Task<IActionResult> LoginOut()

{

await
[Link]([Link]);

return RedirectToAction("Index", "Login");

}

private Usuario UserIsvalid(Usuario user)

{
Usuario usuario;
[Link]ña = [Link]([Link]ña);
usuario = _context.[Link](e => [Link] == [Link]
&& [Link]ña == [Link]ña).Include(p =>
[Link]).FirstOrDefault();
return usuario;
}
}
}

#nullable disable
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
[Authorize(Roles = "Bodeguero,Administrador")]
//[Authorize(Roles = "Administrador")]
public class ProductosController : Controller
{
private readonly storeplacedbContext _context;
private readonly string _cn;

public ProductosController(storeplacedbContext context,

IConfiguration config)
{
_context = context;
_cn = [Link]("default");
}

// GET: Productos
public async Task<IActionResult> Index()
{
[Link] = TempData["Message"];
[Link] = TempData["class"];
[Link] = TempData["icon"];
var storeplacedbContext = _context.[Link](p =>
[Link]);
return View(await [Link]());
}

public JsonResult GetProducts()

{
List<JProducto> Products = new List<JProducto>();
using (var cn = new MySqlConnection(_cn))
{
[Link]();
MySqlCommand cmd = new MySqlCommand("GETPRODUCTS", cn);
[Link] = [Link];
using (var reader = [Link]())
{
while ([Link]())
{
[Link](new JProducto
 {
Barcode = reader["Barcode"].ToString(),
Nombre = reader["Nombre"].ToString(),
Categoria = reader["Descripcion"].ToString(),
Precio = [Link](reader["Precio"]),
Costo = [Link](reader["Costo"]),
Stock = Convert.ToInt32(reader["Stock"]),
Porcganacia =
[Link](reader["Porcganacia"]),
});
}
}
}
return Json(new { Data = Products });
}

// GET: Productos/Details/5
public async Task<IActionResult> Details(string id)
{
if (id == null)
{
return NotFound();
}

var producto = await _context.Productos

.Include(p => [Link])
.FirstOrDefaultAsync(m => [Link] == id);
if (producto == null)
{
return NotFound();
}

return View(producto);
}

// GET: Productos/Create
public IActionResult Create()
{
[Link] = TempData["Message_err"];
ViewData["Idcategoria"] = new
SelectList(_context.CategoriaProductos, "Idcategoria", "Descripcion");
return View();
}

// POST: Productos/Create
 // To protect from overposting attacks, enable the specific
properties you want to bind to.
// For more details, see [Link]
LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult>
Create([Bind("Barcode,Idcategoria,Nombre,Costo,Porcganacia,Stock,Precio")]
Producto producto)
{
if ([Link])
{
_context.Add(producto);
TempData["Message"] = "El registro se guardo correctamente";
TempData["class"] = "alert alert-success alert-dismissible
fade show";
TempData["icon"] = "bi bi-check-circle me-1";
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
else if (![Link]) {
TempData["Message_err"] = "Llene todos los campos
correctamente";

TempData["Message_err"] = "Llene todos los campos

correctamente";
ViewData["Idcategoria"] = new
SelectList(_context.CategoriaProductos, "Idcategoria", "Descripcion",
[Link]);
return View(producto);
}

// GET: Productos/Edit/5
public async Task<IActionResult> Edit(string id)
{
if (id == null)
{
return NotFound();
}

var producto = await _context.[Link](id);

if (producto == null)
{
 return NotFound();
}
ViewData["Idcategoria"] = new
SelectList(_context.CategoriaProductos, "Idcategoria", "Descripcion",
[Link]);
return View(producto);
}

// POST: Productos/Edit/5
// To protect from overposting attacks, enable the specific
properties you want to bind to.
// For more details, see [Link]
LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Edit(string id,
[Bind("Barcode,Idcategoria,Nombre,Costo,Porcganacia,Stock,Precio")] Producto
producto)
{
if (id != [Link])
{
return NotFound();
}

if ([Link])
{
try
{
_context.Update(producto);
TempData["Message"] = "El registro se actualizo
correctamente";
TempData["class"] = "alert alert-success alert-
dismissible fade show";
TempData["icon"] = "bi bi-check-circle me-1";
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductoExists([Link]))
{
return NotFound();
}
else
{
throw;
 }
}
return RedirectToAction(nameof(Index));
}
ViewData["Idcategoria"] = new
SelectList(_context.CategoriaProductos, "Idcategoria", "Descripcion",
[Link]);
return View(producto);
}

// GET: Productos/Delete/5
public async Task<IActionResult> Delete(string id)
{
if (id == null)
{
return NotFound();
}

var producto = await _context.Productos

.Include(p => [Link])
.FirstOrDefaultAsync(m => [Link] == id);
if (producto == null)
{
return NotFound();
}

return View(producto);
}

// POST: Productos/Delete/5
[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public async Task<IActionResult> DeleteConfirmed(string id)
{
var producto = await _context.[Link](id);
_context.[Link](producto);
TempData["Message"] = $"El Producto '{[Link]}' se
elimino correctamente";
TempData["class"] = "alert alert-info alert-dismissible fade
show";
TempData["icon"] = "bi bi-info-circle me-1";
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
 private bool ProductoExists(string id)
{
return _context.[Link](e => [Link] == id);
}
}
}

#nullable disable
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
[Authorize(Roles = "Administrador,Bodeguero")]
public class ProveedoresController : Controller
{
private readonly storeplacedbContext _context;

public ProveedoresController(storeplacedbContext context)

{
_context = context;
}

// GET: Proveedores
public async Task<IActionResult> Index()
{
[Link] = TempData["Message"];
[Link] = TempData["class"];
[Link] = TempData["icon"];
return View(await _context.[Link]());
}

// GET: Proveedores/Details/5
public async Task<IActionResult> Details(int? id)
{
 if (id == null)
{
return NotFound();
}

var proveedor = await _context.Proveedors

.FirstOrDefaultAsync(m => [Link] == id);
if (proveedor == null)
{
return NotFound();
}

return View(proveedor);
}

// GET: Proveedores/Create
public IActionResult Create()
{
return View();
}

// POST: Proveedores/Create
// To protect from overposting attacks, enable the specific
properties you want to bind to.
// For more details, see [Link]
LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult>
Create([Bind("Idproveedor,Nombre,Direccion,Telefono")] Proveedor proveedor)
{
if ([Link])
{
_context.Add(proveedor);
TempData["Message"] = "El registro se guardo correctamente";
TempData["class"] = "alert alert-success alert-dismissible
fade show";
TempData["icon"] = "bi bi-check-circle me-1";
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
return View(proveedor);
}

// GET: Proveedores/Edit/5
 public async Task<IActionResult> Edit(int? id)
{
if (id == null)
{
return NotFound();
}

var proveedor = await _context.[Link](id);

if (proveedor == null)
{
return NotFound();
}
return View(proveedor);
}

// POST: Proveedores/Edit/5
// To protect from overposting attacks, enable the specific
properties you want to bind to.
// For more details, see [Link]
LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Edit(int id,
[Bind("Idproveedor,Nombre,Direccion,Telefono")] Proveedor proveedor)
{
if (id != [Link])
{
return NotFound();
}

if ([Link])
{
try
{
_context.Update(proveedor);
TempData["Message"] = "El registro se actualizo
correctamente";
TempData["class"] = "alert alert-success alert-
dismissible fade show";
TempData["icon"] = "bi bi-check-circle me-1";
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProveedorExists([Link]))
 {
return NotFound();
}
else
{
throw;
}
}
return RedirectToAction(nameof(Index));
}
return View(proveedor);
}

// GET: Proveedores/Delete/5
public async Task<IActionResult> Delete(int? id)
{
if (id == null)
{
return NotFound();
}

var proveedor = await _context.Proveedors

.FirstOrDefaultAsync(m => [Link] == id);
if (proveedor == null)
{
return NotFound();
}

return View(proveedor);
}

// POST: Proveedores/Delete/5
[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public async Task<IActionResult> DeleteConfirmed(int id)
{
var proveedor = await _context.[Link](id);
TempData["Message"] = $"El Proveedor '{[Link]}' se
elimino correctamente";
TempData["class"] = "alert alert-info alert-dismissible fade
show";
TempData["icon"] = "bi bi-info-circle me-1";
_context.[Link](proveedor);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
 }

private bool ProveedorExists(int id)

{
return _context.[Link](e => [Link] == id);
}
}
}

#nullable disable
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
[Authorize(Roles = "Administrador")]
public class UsuariosController : Controller
{
private readonly storeplacedbContext _context;

public UsuariosController(storeplacedbContext context)

{
_context = context;
}

// GET: Usuarios
public async Task<IActionResult> Index()
{
[Link] = TempData["Message"];
[Link] = TempData["class"];
[Link] = TempData["icon"];
var storeplacedbContext = _context.[Link](u =>
[Link]);
 return View(await [Link]());
}

// GET: Usuarios/Details/5
public async Task<IActionResult> Details(int? id)
{
if (id == null)
{
return NotFound();
}

var usuario = await _context.Usuarios

.Include(u => [Link])
.FirstOrDefaultAsync(m => [Link] == id);
if (usuario == null)
{
return NotFound();
}

return View(usuario);
}

// GET: Usuarios/Create
public IActionResult Create()
{
//[Link] = TempData["Message_err"];
ViewData["Idrol"] = new SelectList(_context.Rols, "Idrol",
"Descripcion");
return View();
}

// POST: Usuarios/Create
// To protect from overposting attacks, enable the specific
properties you want to bind to.
// For more details, see [Link]
LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult>
Create([Bind("Idusuario,Nombre,Apellido,Correo,Idrol,Contraseña")] Usuario
usuario)
{
if (UsuarioExists([Link]))
{
TempData["Message_err"] = "Este usuario ya existe";
 ViewData["Idrol"] = new SelectList(_context.Rols, "Idrol",
"Descripcion", [Link]);
return View(usuario);
}
else
{
[Link]ña = [Link]([Link]ña);
_context.Add(usuario);
TempData["Message"] = "El registro se guardo correctamente";
TempData["class"] = "alert alert-success alert-dismissible
fade show";
TempData["icon"] = "bi bi-check-circle me-1";
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
}

// GET: Usuarios/Edit/5
public async Task<IActionResult> Edit(int? id)
{
if (id == null)
{
return NotFound();
}

var usuario = await _context.[Link](id);

if (usuario == null)
{
return NotFound();
}
ViewData["Idrol"] = new SelectList(_context.Rols, "Idrol",
"Descripcion", [Link]);
return View(usuario);
}

// POST: Usuarios/Edit/5
// To protect from overposting attacks, enable the specific
properties you want to bind to.
// For more details, see [Link]
LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Edit(int id,
[Bind("Idusuario,Nombre,Apellido,Correo,Idrol,Contraseña")] Usuario usuario)
{
 if (id != [Link])
{
return NotFound();
}
_context.Update(usuario);
TempData["Message"] = "El registro se actualizo correctamente";
TempData["class"] = "alert alert-success alert-dismissible fade
show";
TempData["icon"] = "bi bi-check-circle me-1";
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
ViewData["Idrol"] = new SelectList(_context.Rols, "Idrol",
"Descripcion", [Link]);
return View(usuario);
}

// GET: Usuarios/Delete/5
public async Task<IActionResult> Delete(int? id)
{
if (id == null)
{
return NotFound();
}

var usuario = await _context.Usuarios

.Include(u => [Link])
.FirstOrDefaultAsync(m => [Link] == id);
if (usuario == null)
{
return NotFound();
}

return View(usuario);
}

// POST: Usuarios/Delete/5
[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public async Task<IActionResult> DeleteConfirmed(int id)
{
var usuario = await _context.[Link](id);
_context.[Link](usuario);
TempData["Message"] = $"El Producto '{[Link]}
{[Link]}' se elimino correctamente";
 TempData["class"] = "alert alert-info alert-dismissible fade
show";
TempData["icon"] = "bi bi-info-circle me-1";
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}

private bool UsuarioExists(string correo)

{
return _context.[Link](e => [Link] == correo);
}

}
}

#nullable disable
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

namespace [Link]
{
[Authorize(Roles = "Administrador,Cajero")]
public class VentasController : Controller
{
private readonly storeplacedbContext _context;

public VentasController(storeplacedbContext context)

{
_context = context;
}

// GET: Ventas
public async Task<IActionResult> Index()
{
 var storeplacedbContext = _context.[Link](v =>
[Link]).Include(v => [Link]);
return View(await [Link]());
}

// GET: Ventas/Details/5
public async Task<IActionResult> Details(uint? id)
{
if (id == null)
{
return NotFound();
}

var venta = await _context.Venta

.Include(v => [Link])
.Include(v => [Link])
.FirstOrDefaultAsync(m => [Link] == id);
if (venta == null)
{
return NotFound();
}

return View(venta);
}

// GET: Ventas/Create
public IActionResult Create()
{
IEnumerable<Producto> Productos = _context.[Link](p
=> [Link]);
Tuple<Venta, IEnumerable<Producto>> model = new Tuple<Venta,
IEnumerable<Producto>>(new Venta(), Productos);
var Cliente = _context.[Link](x => new { [Link],
Nombre = [Link](" ", [Link], [Link], [Link]) }).ToList();
ViewData["Idcliente"] = new SelectList(Cliente, "Idcliente",
"Nombre");
ViewData["Idproducto"] = new SelectList(_context.Productos,
"Barcode", "Nombre");
return View(model);
}

// POST: Ventas/Create
// To protect from overposting attacks, enable the specific
properties you want to bind to.
 // For more details, see [Link]
LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult>
Create([Bind("Idventa,Idcliente,Idusuario,Fecha,Total")] Venta venta)
{
if ([Link])
{
_context.Add(venta);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
ViewData["Idcliente"] = new SelectList(_context.Clientes,
"Idcliente", "Idcliente", [Link]);
ViewData["Idusuario"] = new SelectList(_context.Usuarios,
"Idusuario", "Idusuario", [Link]);
return View(venta);
}

// GET: Ventas/Edit/5
public async Task<IActionResult> Edit(uint? id)
{
if (id == null)
{
return NotFound();
}

var venta = await _context.[Link](id);

if (venta == null)
{
return NotFound();
}
ViewData["Idcliente"] = new SelectList(_context.Clientes,
"Idcliente", "Idcliente", [Link]);
ViewData["Idusuario"] = new SelectList(_context.Usuarios,
"Idusuario", "Idusuario", [Link]);
return View(venta);
}

[HttpPost]
public JsonResult Add(VentaViewModel venta)
{
using (var Transaccion = _context.[Link]())
{
 try
{
Venta _Venta = new Venta
{
Idcliente = [Link],
Idusuario = [Link],
Fecha = [Link]([Link]),
Total = [Link]
};

_context.Add(_Venta);
_context.SaveChanges();

foreach (var oC in [Link])

{
DetalleVenta oConcepto = new DetalleVenta
{
Cantidad = [Link],
Idproducto = [Link],
Precio = [Link],
Subtotal = [Link] * [Link],
Idventa = _Venta.Idventa
};
_context.Add(oConcepto);
}

_context.SaveChanges();
//[Link] = "Registro insertado";
[Link]();

return Json(true);
}
catch (Exception ex)
{
[Link]();
return Json(venta);
}
}

private bool VentaExists(uint id)

{
return _context.[Link](e => [Link] == id);
}
 }
}

MODELS
using System;
using [Link];

namespace [Link]
{
public partial class CategoriaCliente
{
public CategoriaCliente()
{
Clientes = new HashSet<Cliente>();
}

public int Idcategoria { get; set; }

public string Descripcion { get; set; } = null!;

public virtual ICollection<Cliente> Clientes { get; set; }

}
}

using System;
using [Link];
using [Link];

namespace [Link]
{
public partial class Venta
{
public Venta()
{
DetalleVenta = new HashSet<DetalleVenta>();
}

public uint Idventa { get; set; }

[Display(Name = "Cliente")]
public int? Idcliente { get; set; }
public int Idusuario { get; set; }
public DateTime? Fecha { get; set; }
 public decimal? Total { get; set; }

public virtual Cliente? IdclienteNavigation { get; set; }

public virtual Usuario IdusuarioNavigation { get; set; } = null!;
public virtual ICollection<DetalleVenta> DetalleVenta { get; set; }
}
}

using System;
using [Link];

namespace [Link]
{
public partial class Usuario
{
public Usuario()
{
Ingresos = new HashSet<Ingreso>();
Venta = new HashSet<Venta>();
}

public int Idusuario { get; set; }

public string Nombre { get; set; } = null!;
public string Apellido { get; set; } = null!;
public string Correo { get; set; } = null!;
public int Idrol { get; set; }
public string Contraseña { get; set; } = null!;

public virtual Rol IdrolNavigation { get; set; } = null!;

public virtual ICollection<Ingreso> Ingresos { get; set; }
public virtual ICollection<Venta> Venta { get; set; }
}
}

using System;
using [Link];

namespace [Link]
{
public partial class Proveedor
{
public Proveedor()
 {
Ingresos = new HashSet<Ingreso>();
}

public int Idproveedor { get; set; }

public string Nombre { get; set; } = null!;
public string Direccion { get; set; } = null!;
public string Telefono { get; set; } = null!;

public virtual ICollection<Ingreso> Ingresos { get; set; }

}
}

using System;
using [Link];

namespace [Link]
{
public partial class Producto
{
public Producto()
{
DetalleIngresos = new HashSet<DetalleIngreso>();
DetalleVenta = new HashSet<DetalleVenta>();
}

public string Barcode { get; set; } = null!;

public int? Idcategoria { get; set; }
public string Nombre { get; set; } = null!;
public decimal Costo { get; set; }
public decimal Porcganacia { get; set; }
public int Stock { get; set; }
public decimal Precio { get; set; }

public virtual CategoriaProducto? IdcategoriaNavigation { get;

set; }
public virtual ICollection<DetalleIngreso> DetalleIngresos { get;
set; }
public virtual ICollection<DetalleVenta> DetalleVenta { get; set; }
}
}
using System;
using [Link];

namespace [Link]
{
public partial class DetalleIngreso
{
public int IddetalleIngreso { get; set; }
public int Idingreso { get; set; }
public string? Idproducto { get; set; }
public int Cantidad { get; set; }
public decimal? Precio { get; set; }

public virtual Ingreso IdingresoNavigation { get; set; } = null!;

public virtual Producto? IdproductoNavigation { get; set; }
}
}

using System;
using [Link];

namespace [Link]
{
public partial class Cliente
{
public Cliente()
{
Venta = new HashSet<Venta>();
}

public int Idcliente { get; set; }

public string? Nit { get; set; }
public int? Idctgcliente { get; set; }
public string Nombre { get; set; } = null!;
public string Apellido { get; set; } = null!;
public string Direccion { get; set; } = null!;
public string? Telefono { get; set; }

public virtual CategoriaCliente? IdctgclienteNavigation { get;

set; }
public virtual ICollection<Venta> Venta { get; set; }
}
}
 DBCONTEXT. INJECCION DE DEPENDENCIAS

using System;
using [Link];
using [Link];
using [Link];

namespace [Link]
{
public partial class storeplacedbContext : DbContext
{
public storeplacedbContext()
{
}

public storeplacedbContext(DbContextOptions<storeplacedbContext>
options)
: base(options)
{
}

public virtual DbSet<CategoriaCliente> CategoriaClientes { get; set;

} = null!;
public virtual DbSet<CategoriaProducto> CategoriaProductos { get;
set; } = null!;
public virtual DbSet<Cliente> Clientes { get; set; } = null!;
public virtual DbSet<DetalleIngreso> DetalleIngresos { get; set; } =
null!;
public virtual DbSet<DetalleVenta> DetalleVenta { get; set; } =
null!;
public virtual DbSet<Ingreso> Ingresos { get; set; } = null!;
public virtual DbSet<Producto> Productos { get; set; } = null!;
public virtual DbSet<Proveedor> Proveedors { get; set; } = null!;
public virtual DbSet<Rol> Rols { get; set; } = null!;
public virtual DbSet<Usuario> Usuarios { get; set; } = null!;
public virtual DbSet<Venta> Venta { get; set; } = null!;

protected override void OnConfiguring(DbContextOptionsBuilder

optionsBuilder)
{

protected override void OnModelCreating(ModelBuilder modelBuilder)

{
[Link]("utf8mb4_general_ci")
 .HasCharSet("utf8mb4");

[Link]<CategoriaCliente>(entity =>
{
[Link](e => [Link])
.HasName("PRIMARY");

[Link]("categoria_cliente");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDCATEGORIA");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("DESCRIPCION");
});

[Link]<CategoriaProducto>(entity =>
{
[Link](e => [Link])
.HasName("PRIMARY");

[Link]("categoria_producto");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDCATEGORIA");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("DESCRIPCION");
});

[Link]<Cliente>(entity =>
{
[Link](e => [Link])
.HasName("PRIMARY");

[Link]("cliente");

[Link](e => [Link], "IDCTGCLIENTE");

[Link](e => [Link])

.HasColumnType("int(11)")
 .HasColumnName("IDCLIENTE");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("APELLIDO");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("DIRECCION");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDCTGCLIENTE");

[Link](e => [Link])

.HasMaxLength(11)
.HasColumnName("NIT");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("NOMBRE");

[Link](e => [Link])

.HasMaxLength(8)
.HasColumnName("TELEFONO");

[Link](d => [Link])

.WithMany(p => [Link])
.HasForeignKey(d => [Link])
.HasConstraintName("cliente_ibfk_1");
});

[Link]<DetalleIngreso>(entity =>
{
[Link](e => [Link])
.HasName("PRIMARY");

[Link]("detalle_ingreso");

[Link](e => [Link], "IDINGRESO");

[Link](e => [Link], "IDPRODUCTO");

[Link](e => [Link])

.HasColumnType("int(11)")
 .HasColumnName("IDDETALLE_INGRESO");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("CANTIDAD");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDINGRESO");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("IDPRODUCTO");

[Link](e => [Link])

.HasPrecision(11, 2)
.HasColumnName("PRECIO");

[Link](d => [Link])

.WithMany(p => [Link])
.HasForeignKey(d => [Link])
.HasConstraintName("detalle_ingreso_ibfk_1");

[Link](d => [Link])

.WithMany(p => [Link])
.HasForeignKey(d => [Link])
.HasConstraintName("detalle_ingreso_ibfk_2");
});

[Link]<DetalleVenta>(entity =>
{
[Link](e => [Link])
.HasName("PRIMARY");

[Link]("detalle_venta");

[Link](e => [Link], "IDPRODUCTO");

[Link](e => [Link], "IDVENTA");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDDETALLE_VENTA");

[Link](e => [Link])

 .HasColumnType("int(11)")
.HasColumnName("CANTIDAD");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("IDPRODUCTO");

[Link](e => [Link])

.HasColumnType("int(11) unsigned zerofill")
.HasColumnName("IDVENTA");

[Link](e => [Link])

.HasPrecision(6, 2)
.HasColumnName("PRECIO");

[Link](e => [Link])

.HasPrecision(6, 2)
.HasColumnName("SUBTOTAL");

[Link](d => [Link])

.WithMany(p => [Link])
.HasForeignKey(d => [Link])
.HasConstraintName("detalle_venta_ibfk_2");

[Link](d => [Link])

.WithMany(p => [Link])
.HasForeignKey(d => [Link])
.HasConstraintName("detalle_venta_ibfk_3");
});

[Link]<Ingreso>(entity =>
{
[Link](e => [Link])
.HasName("PRIMARY");

[Link]("ingreso");

[Link](e => [Link], "IDPROVEEDOR");

[Link](e => [Link], "IDUSUARIO");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDINGRESO");
 [Link](e => [Link])
.HasMaxLength(45)
.HasColumnName("ESTADO");

[Link](e => [Link])

.HasColumnType("datetime")
.HasColumnName("FECHA");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDPROVEEDOR");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDUSUARIO");

[Link](e => [Link])

.HasPrecision(4, 2)
.HasColumnName("IMPUESTO");

[Link](e => [Link])

.HasPrecision(11, 2)
.HasColumnName("TOTAL");

[Link](d => [Link])

.WithMany(p => [Link])
.HasForeignKey(d => [Link])
.HasConstraintName("ingreso_ibfk_1");

[Link](d => [Link])

.WithMany(p => [Link])
.HasForeignKey(d => [Link])
.HasConstraintName("ingreso_ibfk_2");
});

[Link]<Producto>(entity =>
{
[Link](e => [Link])
.HasName("PRIMARY");

[Link]("producto");

[Link](e => [Link], "IDCATEGORIA");

[Link](e => [Link])

 .HasMaxLength(45)
.HasColumnName("BARCODE");

[Link](e => [Link])

.HasPrecision(4, 2)
.HasColumnName("COSTO");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDCATEGORIA");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("NOMBRE");

[Link](e => [Link])

.HasPrecision(3, 2)
.HasColumnName("PORCGANACIA");

[Link](e => [Link])

.HasPrecision(4, 2)
.HasColumnName("PRECIO");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("STOCK");

[Link](d => [Link])

.WithMany(p => [Link])
.HasForeignKey(d => [Link])
.HasConstraintName("producto_ibfk_2");
});

[Link]<Proveedor>(entity =>
{
[Link](e => [Link])
.HasName("PRIMARY");

[Link]("proveedor");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDPROVEEDOR");

[Link](e => [Link])

 .HasMaxLength(45)
.HasColumnName("DIRECCION");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("NOMBRE");

[Link](e => [Link])

.HasMaxLength(8)
.HasColumnName("TELEFONO");
});

[Link]<Rol>(entity =>
{
[Link](e => [Link])
.HasName("PRIMARY");

[Link]("rol");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDROL");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("DESCRIPCION");
});

[Link]<Usuario>(entity =>
{
[Link](e => [Link])
.HasName("PRIMARY");

[Link]("usuario");

[Link](e => [Link], "CORREO")

.IsUnique();

[Link](e => [Link], "IDROL");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDUSUARIO");

[Link](e => [Link])

 .HasMaxLength(45)
.HasColumnName("APELLIDO");

[Link](e => [Link]ña)

.HasMaxLength(256)
.HasColumnName("CONTRASEÑA");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("CORREO");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDROL");

[Link](e => [Link])

.HasMaxLength(45)
.HasColumnName("NOMBRE");

[Link](d => [Link])

.WithMany(p => [Link])
.HasForeignKey(d => [Link])
.OnDelete([Link])
.HasConstraintName("usuario_ibfk_1");
});

[Link]<Venta>(entity =>
{
[Link](e => [Link])
.HasName("PRIMARY");

[Link]("venta");

[Link](e => [Link], "IDCLIENTE");

[Link](e => [Link], "IDUSUARIO");

[Link](e => [Link])

.HasColumnType("int(11) unsigned zerofill")
.HasColumnName("IDVENTA");

[Link](e => [Link])

.HasColumnType("datetime")
.HasColumnName("FECHA");
 [Link](e => [Link])
.HasColumnType("int(11)")
.HasColumnName("IDCLIENTE");

[Link](e => [Link])

.HasColumnType("int(11)")
.HasColumnName("IDUSUARIO");

[Link](e => [Link])

.HasPrecision(6, 2)
.HasColumnName("TOTAL");

[Link](d => [Link])

.WithMany(p => [Link])
.HasForeignKey(d => [Link])
.HasConstraintName("venta_ibfk_1");

[Link](d => [Link])

.WithMany(p => [Link])
.HasForeignKey(d => [Link])
.OnDelete([Link])
.HasConstraintName("venta_ibfk_3");
});

OnModelCreatingPartial(modelBuilder);
}

partial void OnModelCreatingPartial(ModelBuilder modelBuilder);

}
}

CONEXIÓN
{
"Logging": {
"LogLevel": {
"Default": "Information",
"[Link]": "Warning"
}
},
"AllowedHosts": "*",
"ConnectionStrings": {
 "default": "server=localhost;port=3306;user=root;database=storeplacedb"
},
"AppSettings": {
"Language": "es"
}
}

CLASE ENCRIPTACION DE CONTRASEÑAS

using [Link];
using [Link];

namespace StorePlace
{
public class Encrypt
{
public static string Encriptar(string str)
{
if(str != null)
{
SHA256 sha256 = [Link]();
ASCIIEncoding encoding = new ASCIIEncoding();
byte[] stream = null;
StringBuilder sb = new StringBuilder();
stream = [Link]([Link](str));
for (int i = 0; i < [Link]; i++)
[Link]("{0:x2}", stream[i]);
return [Link]();
}
return "";
}

/// Esta función desencripta la cadena que le envíamos en el

parámentro de entrada.
public static string DesEncriptar(string _cadenaAdesencriptar)
{
string result = [Link];
byte[] decryted =
Convert.FromBase64String(_cadenaAdesencriptar);
//result = [Link](decryted, 0,
[Link]().Length);
result = [Link](decryted);
return result;
}
 }
}