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));
}
