public ActionResult Saveuser(Models.User2 user) { OleDbConnection cn = new OleDbConnection(cadena); cn.Open(); string usuario = user.Usuario; string nombre = user.Nombre; string password = user.Password; string rol = user.rol; int id_rol = Convert.ToInt32(user.rol); int id_empresa = user.id_empresa; string query = "exec uspadduser '" + usuario + "','" + nombre + "','" + password + "'," + id_empresa + "," + id_rol; OleDbCommand cmd = new OleDbCommand(query, cn); OleDbDataReader reader = cmd.ExecuteReader(); List <SelectListItem> li_idempresa = new List <SelectListItem>(); string querylist = "select * from roles"; OleDbCommand cmd2 = new OleDbCommand(querylist, cn); OleDbDataReader reader2 = cmd2.ExecuteReader(); List <SelectListItem> li = new List <SelectListItem>(); Models.User2 u = new Models.User2(); while (reader2.Read()) { li.Add(new SelectListItem { Text = reader2.GetString(1), Value = reader2.GetValue(0).ToString() }); } ViewData["Rol"] = li; string queryempresa = "select * from empresas"; OleDbCommand cmd3 = new OleDbCommand(queryempresa, cn); OleDbDataReader reader3 = cmd3.ExecuteReader(); while (reader3.Read()) { li_idempresa.Add(new SelectListItem { Text = reader3.GetString(1), Value = reader3.GetValue(0).ToString() }); } ViewData["id_empresa"] = li_idempresa; while (reader.Read()) { ViewData["Error"] = reader.GetString(0); } return(View(user)); }
public ActionResult Adduser() { OleDbConnection cn = new OleDbConnection(cadena); cn.Open(); List <SelectListItem> li_idempresa = new List <SelectListItem>(); string querylist = "select * from roles"; OleDbCommand cmd2 = new OleDbCommand(querylist, cn); OleDbDataReader reader2 = cmd2.ExecuteReader(); List <SelectListItem> li = new List <SelectListItem>(); Models.User2 u = new Models.User2(); while (reader2.Read()) { li.Add(new SelectListItem { Text = reader2.GetString(1), Value = reader2.GetValue(0).ToString() }); } ViewData["Rol"] = li; string queryempresa = "select * from empresas"; OleDbCommand cmd3 = new OleDbCommand(queryempresa, cn); OleDbDataReader reader3 = cmd3.ExecuteReader(); while (reader3.Read()) { li_idempresa.Add(new SelectListItem { Text = reader3.GetString(1), Value = reader3.GetValue(0).ToString() }); } ViewData["id_empresa"] = li_idempresa; cmd3.Dispose(); reader2.Close(); reader3.Close(); reader2.Close(); cmd2.Dispose(); cn.Close(); return(View(u)); }
[HttpPost] ActionResult probar(Models.User2 user) { return(View(user)); }