public static List <Container> ComFiltro(Container filtro)
{
List <Container> containers = new List <Container>();
using (ContainerRepositorio repo = new ContainerRepositorio())
{
if (filtro == null)
{
containers = repo.Listar().ToList();
}
else
{
containers = repo.Listar()
.Where(c => string.IsNullOrEmpty(filtro.NroContainer?.Replace(" ", string.Empty) ?? string.Empty) || c.NroContainer.Contains(filtro.NroContainer))
.Where(c => filtro.CodigoIsoId == Guid.Empty || c.CodigoIsoId == filtro.CodigoIsoId)
.Where(
c => filtro.Fabricacao.Equals(default(DateTime)) || c.Fabricacao.Equals(filtro.Fabricacao))
.Where(c => ToInt32(filtro.CM) == 0 || Abs(c.CM - filtro.CM) < 1)
.Where(c => ToInt32(filtro.Tara) == 0 || Abs(c.Tara - filtro.Tara) < 1)
.Where(c => ToInt32(filtro.Peso) == 0 || Abs(c.Peso - filtro.Peso) < 1)
.ToList();
}
}
return(containers);
}
public void Update()
{
double cm = GetRandom(99999);
double peso = GetRandom((int)cm);
double tara = GetRandom(1000);
Container ctnr = null;
string ctnrNr = string.Empty;
using (ContainerRepositorio repo = new ContainerRepositorio())
{
ctnr = repo.Listar().FirstOrDefault();
if (ctnr != null)
{
ctnrNr = ctnr.NroContainer;
ctnr.CM = cm;
ctnr.Peso = peso;
ctnr.Tara = tara;
ctnr = repo.InserirOuAtualizar(ctnr);
}
}
Assert.IsNotNull(ctnr);
Assert.AreNotEqual(ctnr.Id, Guid.Empty);
Assert.AreEqual(ctnr.NroContainer, ctnrNr);
Assert.AreEqual(ctnr.CM, cm);
Assert.AreEqual(ctnr.Peso, peso);
Assert.AreEqual(ctnr.Tara, tara);
}
public ActionResult SalvarContainer(Container Model)
{
using (ContainerRepositorio repo = new ContainerRepositorio())
{
repo.InserirOuAtualizar(Model);
}
return(RedirectToAction("ManutenirContainer"));
}
public ActionResult ExcluirContainer(Guid containerId)
{
using (ContainerRepositorio repo = new ContainerRepositorio())
{
repo.Excluir(containerId);
}
return RedirectToAction("ManutenirContainer");
}
public ActionResult SalvarContainer(Container Model)
{
using (ContainerRepositorio repo = new ContainerRepositorio())
{
repo.InserirOuAtualizar(Model);
}
return RedirectToAction("ManutenirContainer");
}
public ActionResult ExcluirContainer(Guid containerId)
{
using (ContainerRepositorio repo = new ContainerRepositorio())
{
repo.Excluir(containerId);
}
return(RedirectToAction("ManutenirContainer"));
}
public void Query()
{
List <Container> lista = null;
using (ContainerRepositorio repo = new ContainerRepositorio())
{
lista = repo.Listar().ToList();
}
Assert.IsNotNull(lista);
Assert.AreNotEqual(lista.Count, 0);
}
public void GetListBy()
{
List <Container> lista = null;
using (ContainerRepositorio repo = new ContainerRepositorio())
{
lista = repo.CapturarPor(c => c.NroContainer.Contains(CodePredicate)).ToList();
}
Assert.IsNotNull(lista);
Assert.AreNotEqual(lista.Count, 0);
}
public ActionResult ManutenirContainer()
{
using (CodigoIsoRepositorio codIsoRepo = new CodigoIsoRepositorio())
{
ViewBag.CodigosIso = ServicoConverteCodigosIso.ParaSelectListItens(codIsoRepo.Listar().ToList());
}
List<Container> containers = new List<Container>();
using (ContainerRepositorio contrRepo = new ContainerRepositorio())
{
containers = contrRepo.Listar().ToList();
}
return View(containers);
}
//[TestCleanup]
public void ClearDb()
{
using (ContainerRepositorio repo = new ContainerRepositorio())
{
foreach (Container ctnr in repo.Listar())
{
repo.Excluir(ctnr);
}
}
ClearCodigosIso();
Inserted.Clear();
}
public ActionResult ManutenirContainer()
{
using (CodigoIsoRepositorio codIsoRepo = new CodigoIsoRepositorio())
{
ViewBag.CodigosIso = ServicoConverteCodigosIso.ParaSelectListItens(codIsoRepo.Listar().ToList());
}
List <Container> containers = new List <Container>();
using (ContainerRepositorio contrRepo = new ContainerRepositorio())
{
containers = contrRepo.Listar().ToList();
}
return(View(containers));
}
public ActionResult EditarContainer(Guid containerId)
{
Container container = new Container();
using (ContainerRepositorio repo = new ContainerRepositorio())
{
container = repo.CapturarPorId(containerId);
}
using (CodigoIsoRepositorio repo = new CodigoIsoRepositorio())
{
ViewBag.CodigosIso = ServicoConverteCodigosIso.ParaSelectListItens(repo.Listar().ToList());
}
return PartialView(container);
}
public void GetById()
{
Container cod = null;
int index = GetRandomIndex(Inserted);
var item = Inserted[index];
using (ContainerRepositorio repo = new ContainerRepositorio())
{
cod = repo.CapturarPorId(item.Id);
}
Assert.IsNotNull(cod);
Assert.IsInstanceOfType(cod, typeof(Container));
Assert.AreEqual(cod.Id, item.Id);
}
public ActionResult EditarContainer(Guid containerId)
{
Container container = new Container();
using (ContainerRepositorio repo = new ContainerRepositorio())
{
container = repo.CapturarPorId(containerId);
}
using (CodigoIsoRepositorio repo = new CodigoIsoRepositorio())
{
ViewBag.CodigosIso = ServicoConverteCodigosIso.ParaSelectListItens(repo.Listar().ToList());
}
return(PartialView(container));
}
public void GetOneBy()
{
List <Container> lista = null;
int index = GetRandomIndex(Inserted);
var item = Inserted[index];
using (ContainerRepositorio repo = new ContainerRepositorio())
{
lista = repo.CapturarPor(c => c.NroContainer == item.NroContainer).ToList();
}
Assert.IsNotNull(lista);
Assert.AreEqual(lista.Count, 1);
Assert.AreEqual(lista[0].NroContainer, item.NroContainer);
Assert.AreEqual(lista[0].Id, item.Id);
}
public static List<Container> ComFiltro(Container filtro)
{
List<Container> containers = new List<Container>();
using (ContainerRepositorio repo = new ContainerRepositorio())
{
if (filtro == null)
containers = repo.Listar().ToList();
else
containers = repo.Listar()
.Where(c => string.IsNullOrEmpty(filtro.NroContainer?.Replace(" ",string.Empty) ?? string.Empty) || c.NroContainer.Contains(filtro.NroContainer))
.Where(c => filtro.CodigoIsoId == Guid.Empty || c.CodigoIsoId == filtro.CodigoIsoId)
.Where(
c => filtro.Fabricacao.Equals(default(DateTime)) || c.Fabricacao.Equals(filtro.Fabricacao))
.Where(c => ToInt32(filtro.CM) == 0 || Abs(c.CM - filtro.CM) < 1)
.Where(c => ToInt32(filtro.Tara) == 0 || Abs(c.Tara - filtro.Tara) < 1)
.Where(c => ToInt32(filtro.Peso) == 0 || Abs(c.Peso - filtro.Peso) < 1)
.ToList();
}
return containers;
}
public void DeleteById()
{
int countOld = 0;
int countNew = 0;
Container Container = null;
int index = GetRandomIndex(Inserted);
var item = Inserted[index];
using (ContainerRepositorio repo = new ContainerRepositorio())
{
countOld = repo.Listar().Count();
Container = repo.Excluir(item.Id);
countNew = repo.Listar().Count();
Container = repo.CapturarPorId(item.Id);
}
Assert.IsNull(Container);
Assert.AreNotSame(countOld, countNew);
Assert.IsTrue(Math.Abs(countOld - countNew) == 1);
}
public void InitializeDb()
{
GenerateCodigosIso();
Inserted = new List <Container>();
for (int i = 0; i < 5; i++)
{
string cod = GenerateRandomCode();
while (Inserted.Any(c => c.NroContainer == cod))
{
cod = GenerateRandomCode();
}
double cm = GetRandom(99999);
double peso = GetRandom((int)cm);
double tara = GetRandom(1000);
CodigoIso codIso = null;
using (CodigoIsoRepositorio cirepo = new CodigoIsoRepositorio())
{
codIso = cirepo.Listar().ToList()[GetRandomIndex(cirepo.Listar().ToList())];
}
Container ctnr = new Container()
{
NroContainer = cod,
CM = cm,
CodigoIso = codIso,
Fabricacao = new DateTime(2012, 12, 12),
Peso = peso,
Tara = tara
};
using (ContainerRepositorio repo = new ContainerRepositorio())
{
Inserted.Add(repo.Inserir(ctnr));
}
}
}
public void Insert()
{
string cod = GenerateRandomCode();
while (Inserted.Any(c => c.NroContainer == cod))
{
cod = GenerateRandomCode();
}
double cm = GetRandom(99999);
double peso = GetRandom((int)cm);
double tara = GetRandom(1000);
CodigoIso codIso = null;
using (CodigoIsoRepositorio cirepo = new CodigoIsoRepositorio())
{
codIso = cirepo.Listar().ToList()[GetRandomIndex(cirepo.Listar().ToList())];
}
Container ctnr = new Container()
{
NroContainer = cod,
CM = cm,
CodigoIso = codIso,
Fabricacao = new DateTime(2012, 12, 12),
Peso = peso,
Tara = tara
};
using (ContainerRepositorio repo = new ContainerRepositorio())
{
ctnr = repo.InserirOuAtualizar(ctnr);
Inserted.Add(ctnr);
}
Assert.IsNotNull(ctnr);
Assert.AreNotEqual(ctnr.Id, Guid.Empty);
}
//[TestCleanup]
public void ClearDb()
{
using (ContainerRepositorio repo = new ContainerRepositorio())
{
foreach (Container ctnr in repo.Listar())
{
repo.Excluir(ctnr);
}
}
ClearCodigosIso();
Inserted.Clear();
}
public void GetById()
{
Container cod = null;
int index = GetRandomIndex(Inserted);
var item = Inserted[index];
using (ContainerRepositorio repo = new ContainerRepositorio())
{
cod = repo.CapturarPorId(item.Id);
}
Assert.IsNotNull(cod);
Assert.IsInstanceOfType(cod, typeof(Container));
Assert.AreEqual(cod.Id, item.Id);
}
public void GetListBy()
{
List<Container> lista = null;
using (ContainerRepositorio repo = new ContainerRepositorio())
{
lista = repo.CapturarPor(c => c.NroContainer.Contains(CodePredicate)).ToList();
}
Assert.IsNotNull(lista);
Assert.AreNotEqual(lista.Count, 0);
}
public void GetOneBy()
{
List<Container> lista = null;
int index = GetRandomIndex(Inserted);
var item = Inserted[index];
using (ContainerRepositorio repo = new ContainerRepositorio())
{
lista = repo.CapturarPor(c => c.NroContainer == item.NroContainer).ToList();
}
Assert.IsNotNull(lista);
Assert.AreEqual(lista.Count, 1);
Assert.AreEqual(lista[0].NroContainer, item.NroContainer);
Assert.AreEqual(lista[0].Id, item.Id);
}
public void Insert()
{
string cod = GenerateRandomCode();
while (Inserted.Any(c => c.NroContainer == cod))
{
cod = GenerateRandomCode();
}
double cm = GetRandom(99999);
double peso = GetRandom((int)cm);
double tara = GetRandom(1000);
CodigoIso codIso = null;
using (CodigoIsoRepositorio cirepo = new CodigoIsoRepositorio())
{
codIso = cirepo.Listar().ToList()[GetRandomIndex(cirepo.Listar().ToList())];
}
Container ctnr = new Container()
{
NroContainer = cod,
CM = cm,
CodigoIso = codIso,
Fabricacao = new DateTime(2012, 12, 12),
Peso = peso,
Tara = tara
};
using (ContainerRepositorio repo = new ContainerRepositorio())
{
ctnr = repo.InserirOuAtualizar(ctnr);
Inserted.Add(ctnr);
}
Assert.IsNotNull(ctnr);
Assert.AreNotEqual(ctnr.Id, Guid.Empty);
}
public void Update()
{
double cm = GetRandom(99999);
double peso = GetRandom((int)cm);
double tara = GetRandom(1000);
Container ctnr = null;
string ctnrNr = string.Empty;
using (ContainerRepositorio repo = new ContainerRepositorio())
{
ctnr = repo.Listar().FirstOrDefault();
if (ctnr != null)
{
ctnrNr = ctnr.NroContainer;
ctnr.CM = cm;
ctnr.Peso = peso;
ctnr.Tara = tara;
ctnr = repo.InserirOuAtualizar(ctnr);
}
}
Assert.IsNotNull(ctnr);
Assert.AreNotEqual(ctnr.Id, Guid.Empty);
Assert.AreEqual(ctnr.NroContainer, ctnrNr);
Assert.AreEqual(ctnr.CM, cm);
Assert.AreEqual(ctnr.Peso, peso);
Assert.AreEqual(ctnr.Tara, tara);
}
public void Delete()
{
int countOld = 0;
int countNew = 0;
Container Container = null;
int index = GetRandomIndex(Inserted);
var item = Inserted[index];
using (ContainerRepositorio repo = new ContainerRepositorio())
{
countOld = repo.Listar().Count();
Container = repo.Excluir(item);
countNew = repo.Listar().Count();
Container = repo.CapturarPorId(item.Id);
}
Assert.IsNull(Container);
Assert.AreNotSame(countOld, countNew);
Assert.IsTrue(Math.Abs(countOld - countNew) == 1);
}
public void InitializeDb()
{
GenerateCodigosIso();
Inserted = new List<Container>();
for (int i = 0; i < 5; i++)
{
string cod = GenerateRandomCode();
while (Inserted.Any(c => c.NroContainer == cod))
{
cod = GenerateRandomCode();
}
double cm = GetRandom(99999);
double peso = GetRandom((int)cm);
double tara = GetRandom(1000);
CodigoIso codIso = null;
using (CodigoIsoRepositorio cirepo = new CodigoIsoRepositorio())
{
codIso = cirepo.Listar().ToList()[GetRandomIndex(cirepo.Listar().ToList())];
}
Container ctnr = new Container()
{
NroContainer = cod,
CM = cm,
CodigoIso = codIso,
Fabricacao = new DateTime(2012, 12, 12),
Peso = peso,
Tara = tara
};
using (ContainerRepositorio repo = new ContainerRepositorio())
{
Inserted.Add(repo.Inserir(ctnr));
}
}
}
public void Query()
{
List<Container> lista = null;
using (ContainerRepositorio repo = new ContainerRepositorio())
{
lista = repo.Listar().ToList();
}
Assert.IsNotNull(lista);
Assert.AreNotEqual(lista.Count, 0);
}
