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