public ActionResult login(user _user) { Session["log_in"] = new Login().login_successfull(_user.user_name, _user.user_password); if (Session["log_in"].ToString() == "basarili_giris") { usermanager User = new usermanager(); user userinfo = User.filterread(x => x.user_name == _user.user_name && x.user_password == _user.user_password); if (userinfo != null) { Session["usernanme"] = userinfo.user_name; Session["userautorization"] = userinfo.autorization.autorization_name; if (Session["kullaniniadi"].ToString() == "admin") { } else { return(RedirectToAction("profile")); } } } else { return(RedirectToAction("Index")); } }
private void button3_Click(object sender, EventArgs e) { usermanager usem = new usermanager(); AddControlsToPanel(usem); movesidePane1(btnusemanger); }
public static usermanager GetByID(int id) { usermanager theManager = new usermanager(); IDbConnection conn = new MySqlConnection(); conn.ConnectionString = connString; string query = "Select * from usermanager WHERE Id=" + id; IDbCommand cmd = new MySqlCommand(); cmd.CommandText = query; cmd.Connection = conn; MySqlDataAdapter da = new MySqlDataAdapter(cmd as MySqlCommand); DataSet ds = new DataSet(); try { da.Fill(ds); DataRowCollection rows = ds.Tables[0].Rows; foreach (DataRow row in rows) { theManager.ID = int.Parse(row["Id"].ToString()); theManager.Username = row["Username"].ToString(); theManager.Email = row["Email"].ToString(); theManager.Role = row["Role"].ToString(); } } catch (MySqlException e) { string message = e.Message; } // implementation return(theManager); }
public async void GuardarValores() { usermanager manager = new usermanager(); var res = await manager.getCuentaOscar(); var res1 = await manager.getCuentaMarco(); var res2 = await manager.getCuentaRaul(); var res3 = await manager.getpassORM(); if (usuario.Equals(res) && contraseña.Equals(res3)) { await Navigation.PushAsync(new hola()); } if (usuario.Equals(res1) && contraseña.Equals(res3)) { await Navigation.PushAsync(new hola()); } if (usuario.Equals(res2) && contraseña.Equals(res3)) { await Navigation.PushAsync(new hola()); } /*if (res != null) * { * usuario.BindingContext = res; * } * if (res1 != null) * { * usuario.BindingContext = res1; * } * if (res2 != null) * { * usuario.BindingContext = res2; * } * if (res3 != null) * { * contraseña.BindingContext = res3; * }*/ }
public static List <usermanager> GetAllManagers() { List <usermanager> allManagers = new List <usermanager>(); IDbConnection conn = new MySqlConnection(); conn.ConnectionString = connString; string query = "Select * from usermanager"; IDbCommand cmd = new MySqlCommand(); cmd.CommandText = query; cmd.Connection = conn; MySqlDataAdapter da = new MySqlDataAdapter(cmd as MySqlCommand); DataSet ds = new DataSet(); try { da.Fill(ds); DataRowCollection rows = ds.Tables[0].Rows; foreach (DataRow row in rows) { usermanager theManager = new usermanager(); theManager.ID = int.Parse(row["Id"].ToString()); theManager.Username = row["Username"].ToString(); theManager.Email = row["Email"].ToString(); theManager.Role = row["Role"].ToString(); allManagers.Add(theManager); } } catch (MySqlException e) { string message = e.Message; } return(allManagers); }