public List <Stocker> listarStocker()
{
Stocker stocker = null;
List <Stocker> list = new List <Stocker>();
using (ProyectoEntities db = new ProyectoEntities())
{
var query = (from us in db.Usuario
join ad in db.Stocker on us.CedulaUsu equals ad.cedulaStocker
select new
{
IdUsuario = us.Idusu,
CedulaUsu = us.CedulaUsu,
NombreUsu = us.NombreUsu,
ClaveUsu = us.ClaveUsu,
Sueldo = us.Sueldo,
FechaIngreso = us.FechaIngreso,
}).ToList();
if (query != null)
{
foreach (var r in query)
{
stocker = new Stocker(r.IdUsuario, r.CedulaUsu, r.NombreUsu, r.ClaveUsu, r.Sueldo, r.FechaIngreso, false);
list.Add(stocker);
}
}
}
return(list);
}
public void modificarStocker(Stocker mstocker)
{
try
{
using (ProyectoEntities db = new ProyectoEntities())
{
var queryUsuario =
from Usuario in db.Usuario
where
Usuario.CedulaUsu == mstocker.CedulaUsu
select Usuario;
foreach (var Usuario in queryUsuario)
{
Usuario.NombreUsu = mstocker.NombreUsu;
Usuario.ClaveUsu = mstocker.ClaveUsu;
Usuario.Sueldo = mstocker.Sueldo;
}
db.SaveChanges();
}
}
catch (Exception exsql)
{
throw new Exception("Ocurrio un error al modificar al Stocker", exsql);
}
}
public Stocker obtenerStocker(long cedula)
{
Stocker stocker = null;
using (ProyectoEntities db = new ProyectoEntities())
{
var query = (from us in db.Usuario
join ad in db.Stocker on us.CedulaUsu equals ad.cedulaStocker
where
us.CedulaUsu == cedula
select new
{
IdUsuario = us.Idusu,
CedulaUsu = us.CedulaUsu,
NombreUsu = us.NombreUsu,
ClaveUsu = us.ClaveUsu,
Sueldo = us.Sueldo,
FechaIngreso = us.FechaIngreso,
Idstocker = ad.IdStocker,
}).FirstOrDefault();
if (query != null)
{
stocker = new Stocker(query.IdUsuario, query.CedulaUsu, query.NombreUsu, query.ClaveUsu, query.Sueldo, query.FechaIngreso, false);
}
}
return(stocker);
}
public Stocker getStocker(long cedula)
{
Stocker stock = null;
Usuario _unusuario = FabricaLogica.getControladorUsuario().ingresarCedula(cedula);
if (_unusuario is Stocker)
{
stock = (Stocker)_unusuario;
}
return(stock);
}
public void Check_To_See_If_Change_Return_Works(double balance, int[] changeExpected)
{
string path = Path.Combine(Environment.CurrentDirectory, "vendingmachine.txt");
Stocker stocker = new Stocker();
VendingMachine vendingMachine = new VendingMachine(stocker.ReturnStock(path));
vendingMachine.Balance = (decimal)balance;
int[] change = vendingMachine.MakeChange(vendingMachine.Balance);
CollectionAssert.AreEqual(changeExpected, change);
}
public void StockListIsProperlyCreatedFromTextFile()
{
Stocker stock = new Stocker("vendingmachine.csv");
List <Item> items = stock.CreateStockList();
string itemName = items[6].Name;
decimal itemPrice = items[6].Price;
Assert.AreEqual("Wonka Bar", itemName);
Assert.AreEqual((decimal)1.50, itemPrice);
}
public void Check_To_See_If_Change_Return_Leaves_Zero_Balance()
{
string path = Path.Combine(Environment.CurrentDirectory, "vendingmachine.txt");
Stocker stocker = new Stocker();
VendingMachine vendingMachine = new VendingMachine(stocker.ReturnStock(path));
vendingMachine.Balance = 5.85M;
vendingMachine.MakeChange(vendingMachine.Balance);
decimal balance = vendingMachine.Balance;
Assert.AreEqual(0.00M, balance);
}
public void CheckToSeeIfDispenseItemReducesStock()
{
string path = Path.Combine(Environment.CurrentDirectory, "vendingmachine.txt");
Stocker stocker = new Stocker();
var Stock = stocker.ReturnStock(path);
VendingMachine vendingMachine = new VendingMachine(Stock);
vendingMachine.Balance = 5.00M;
vendingMachine.DispenseItem("A1");
Assert.AreEqual(4, Stock["A1"].ItemsRemaining);
Assert.AreEqual(1.95M, vendingMachine.Balance);
}
public void agregarStocker(Stocker addstocker)
{
using (ProyectoEntities db = new ProyectoEntities())
{
Usuario usu = DatosAdministrador.obtenerUsuario(addstocker.CedulaUsu);
if (usu != null)
{
var queryUsuario =
from Usuario in db.Usuario
where Usuario.CedulaUsu == addstocker.CedulaUsu
select Usuario;
foreach (var delu in queryUsuario)
{
delu.BajaUsu = false;
}
db.SaveChanges();
}
else
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
db.Usuario.Add(new Usuario()
{
CedulaUsu = addstocker.CedulaUsu,
NombreUsu = addstocker.NombreUsu,
ClaveUsu = addstocker.ClaveUsu,
Sueldo = addstocker.Sueldo,
FechaIngreso = DateTime.Now,
});
db.SaveChanges();
db.Stocker.Add(new Stocker()
{
cedulaStocker = addstocker.CedulaUsu,
});
db.SaveChanges();
transaction.Commit();
}
catch (Exception exsql)
{
transaction.Rollback();
throw new Exception("Ocurrio un error al agregar al Stocker", exsql);
}
}
}
}
}
public void TestPurchase()
{
Stocker stocker = new Stocker();
VendingMachine vendingMachine = new VendingMachine();
vendingMachine.Load(stocker.Restock());
vendingMachine.FeedMoney(100.0m);
// Price of A1 = 3.05
vendingMachine.Purchase("A1");
Assert.AreEqual(96.95M, vendingMachine.Balance);
Assert.AreEqual(4, vendingMachine.Stock["A1"].Count);
vendingMachine.Purchase("A1");
Assert.AreEqual(93.9M, vendingMachine.Balance);
Assert.AreEqual(3, vendingMachine.Stock["A1"].Count);
}
public IHttpActionResult PostStocker(Stocker stocker)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Stockers.Add(stocker);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = stocker.StockerId }, new
{
stocker.StockerId,
stocker.FirstName,
stocker.LastName,
stocker.EmployeeNumber
}));
}
public IHttpActionResult GetStocker(int id)
{
Stocker stocker = db.Stockers.Find(id);
if (stocker == null)
{
return(NotFound());
}
var resultSet = new
{
stocker.StockerId,
stocker.FirstName,
stocker.LastName,
stocker.EmployeeNumber
};
return(Ok(resultSet));
}
public Stocker getLogin(long cedula, string contrasena)
{
var token = "";
Stocker sto = null;
Usuario _unusuario = FabricaLogica.getLUsuario().iniciarsesion(cedula, contrasena);
if (_unusuario is Stocker)
{
sto = (Stocker)_unusuario;
if (sto == null)
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
token = TokenGenerator.GenerateTokenJwt(cedula.ToString());
}
return(sto);
}
public IHttpActionResult DeleteStocker(int id)
{
Stocker stocker = db.Stockers.Find(id);
if (stocker == null)
{
return(NotFound());
}
db.Stockers.Remove(stocker);
db.SaveChanges();
var resultSet = new
{
stocker.StockerId,
stocker.FirstName,
stocker.LastName,
stocker.EmployeeNumber
};
return(Ok(resultSet));
}
public void eliminarStocker(Stocker delstocker)
{
using (ProyectoEntities db = new ProyectoEntities())
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
var queryStocker =
from Stocker in db.Stocker
where Stocker.cedulaStocker == delstocker.CedulaUsu
select Stocker;
foreach (var delc in queryStocker)
{
db.Stocker.Remove(delc);
}
db.SaveChanges();
var queryUsuario =
from Usuario in db.Usuario
where Usuario.CedulaUsu == delstocker.CedulaUsu
select Usuario;
foreach (var delu in queryUsuario)
{
db.Usuario.Remove(delu);
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception exsql)
{
transaction.Rollback();
throw new Exception("Ocurrio un error al eliminar al Stocker", exsql);
}
}
}
}
public IHttpActionResult PutStocker(int id, Stocker stocker)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != stocker.StockerId)
{
return(BadRequest());
}
var dbStocker = db.Stockers.Find(id);
dbStocker.StockerId = stocker.StockerId;
dbStocker.FirstName = stocker.FirstName;
dbStocker.LastName = stocker.LastName;
dbStocker.EmployeeNumber = stocker.EmployeeNumber;
db.Entry(stocker).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!StockerExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public bool Put(long cedula, [FromBody] Stocker apiusuario)
{
return(FabricaLogica.getControladorUsuario().modificarUsuario(cedula, apiusuario));
}
public bool Delete([FromBody] Stocker apiusuario)
{
return(FabricaLogica.getControladorUsuario().eliminarUsuario(apiusuario));
}
public bool Post([FromBody] Stocker apiusuario)
{
return(FabricaLogica.getControladorUsuario().agregarUsuario(apiusuario));
}
public void StockerTest_DoesItWork()
{
string filepath = Path.Combine(Environment.CurrentDirectory, "TestInventory.txt");
Dictionary <string, Inventory> testanswer = Stocker.UsingPathToLoadStocker(filepath);
}
