public ActionResult Fabricante(CadastroFabricantesViewModel vf)
{
if (!ModelState.IsValid)
{
return(View(vf));
}
faDAO = new Models.DAO.FabricanteDAO();
if (faDAO.createFabricante(vf.NomeFabricante, vf.TelefoneFabricante, vf.EnderecoFabricante) == 1)
{
return(RedirectToRoute(new { controller = "Cadastro", action = "Sucesso" }));
}
else
{
return(RedirectToRoute(new { controller = "Home", action = "Erro", id = 2 }));
}
}
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));
}
