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 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 Query() { List <Container> lista = null; using (ContainerRepositorio repo = new ContainerRepositorio()) { lista = repo.Listar().ToList(); } Assert.IsNotNull(lista); Assert.AreNotEqual(lista.Count, 0); }
//[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 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 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 Query() { List<Container> lista = null; using (ContainerRepositorio repo = new ContainerRepositorio()) { lista = repo.Listar().ToList(); } Assert.IsNotNull(lista); Assert.AreNotEqual(lista.Count, 0); }