public ActionResult Pedidos(bool?addToList, int?selectedGrupo, int?selectedReagente, float?qtdereagente) { if (Session.Count <= 0) { return(RedirectToAction("Logout", "Auth")); } gDAO = new Models.DAO.GrupoDAO(); rDAO = new Models.DAO.ReagenteDAO(); if ((!addToList.HasValue) && (!(selectedGrupo.HasValue) && !(selectedReagente.HasValue)) && !(qtdereagente.HasValue)) { vumodelped = new Models.ViewModels.CadastroPedidosViewModel(); vumodelped.selectedReagentes = new List <TableReagentes>(); vumodelped.listGrupo = new List <SelectListItem>(); vumodelped.listReagentes = new List <SelectListItem>(); } List <SelectListItem> ls = new List <SelectListItem>(); List <SelectListItem> lb = new List <SelectListItem>(); DataTable dx = gDAO.select(); DataTable dt = rDAO.selectListReagente().Tables[0]; if (!selectedGrupo.HasValue) { SelectListItem dp = new SelectListItem(); dp.Text = "Selecione um grupo"; dp.Value = "0"; dp.Selected = true; ViewBag.desativaReag = true; ls.Add(dp); } foreach (DataRow item in dx.Rows) { SelectListItem sl = new SelectListItem(); sl.Text = item["desc_grupo"].ToString(); sl.Value = item["id_grupo"].ToString(); ls.Add(sl); } if (selectedGrupo.HasValue) { dt = rDAO.selectListByGrupo(int.Parse(selectedGrupo.ToString())).Tables[0]; foreach (DataRow row in dt.Rows) { SelectListItem sl = new SelectListItem(); if (selectedReagente != 0) { sl.Selected = true; } sl.Value = row["id_tipo"].ToString(); sl.Text = row["desc_tipo"].ToString() + " " + row["teor_tipo"].ToString(); lb.Add(sl); } if (dt.Rows.Count == 0) { ViewBag.semReagentes = true; } else { ViewBag.desativaReag = false; ViewBag.semReagentes = false; if (selectedGrupo.HasValue && !selectedReagente.HasValue) { selectedReagente = int.Parse(ls[0].Value); } } } if (addToList == true) { TableReagentes tb = new TableReagentes(); tb.ID = selectedReagente.Value; tb.Nome = vumodelped.listReagentes[selectedReagente.Value].Text; tb.valor = Convert.ToDecimal(qtdereagente.Value); vumodelped.selectedReagentes.Add(tb); } vumodelped.listGrupo = ls; vumodelped.listReagentes = lb; return(View(vumodelped)); }
public ActionResult Frasco(int?selectedGrupo, int?selectedReagente) { if (Session.Count <= 0) { return(RedirectToAction("Logout", "Auth")); } var vmodel = new Models.ViewModels.CadastroFrascoViewModel(); rDAO = new Models.DAO.ReagenteDAO(); faDAO = new Models.DAO.FabricanteDAO(); frDAO = new Models.DAO.FrascosDAO(); gDAO = new Models.DAO.GrupoDAO(); DataTable dt = new DataTable(); DataTable db = faDAO.selectFabricantes().Tables[0]; DataTable ds = gDAO.select(); List <SelectListItem> lb = new List <SelectListItem>(); List <SelectListItem> ls = new List <SelectListItem>(); List <SelectListItem> lg = new List <SelectListItem>(); if (!selectedGrupo.HasValue) { dt = rDAO.selectListReagente().Tables[0]; SelectListItem dx = new SelectListItem(); dx.Text = "Selecione um grupo"; dx.Value = "0"; dx.Selected = true; ViewBag.desativaReag = true; lg.Add(dx); } foreach (DataRow row in ds.Rows) { SelectListItem sl = new SelectListItem(); if (int.Parse(row["id_grupo"].ToString()) == selectedGrupo) { sl.Selected = true; } sl.Value = row["id_grupo"].ToString(); sl.Text = row["desc_grupo"].ToString(); lg.Add(sl); } if (selectedGrupo.HasValue) { dt = rDAO.selectListByGrupo(int.Parse(selectedGrupo.ToString())).Tables[0]; foreach (DataRow row in dt.Rows) { SelectListItem sl = new SelectListItem(); if (vmodel.selectedReagente != 0) { sl.Selected = true; } sl.Value = row["id_tipo"].ToString(); sl.Text = row["desc_tipo"].ToString() + " " + row["teor_tipo"].ToString(); ls.Add(sl); } if (dt.Rows.Count == 0) { ViewBag.semReagentes = true; } else { ViewBag.desativaReag = false; ViewBag.semReagentes = false; if (selectedGrupo.HasValue && !selectedReagente.HasValue) { selectedReagente = int.Parse(ls[0].Value); } } } foreach (DataRow row in db.Rows) { SelectListItem dg = new SelectListItem(); dg.Value = row["id_fabricante"].ToString(); dg.Text = row["desc_fabricante"].ToString(); lb.Add(dg); } if (selectedReagente.HasValue) { vmodel.frasco_estoque = Convert.ToDecimal(frDAO.getEstoque(selectedReagente.Value)); } // vmodel.estoque_maximo = vmodel.listaGrupo = lg; vmodel.listaReagente = ls; vmodel.listaFabricantes = lb; return(View(vmodel)); }