private void button1_Click(object sender, EventArgs e)
{
if (txt_UserName.Text == "" || txt_Password.Text == "")
{
MessageBox.Show("Wpisz nazwę użytkownia i hasło");
return;
}
try
{
//Create SqlConnection
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("Select * from login where UserName=@username and Password=@password", con);
cmd.Parameters.AddWithValue("@username", txt_UserName.Text);
cmd.Parameters.AddWithValue("@password", txt_Password.Text);
con.Open();
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
con.Close();
int count = ds.Tables[0].Rows.Count;
if (count == 1)
{
MessageBox.Show("Logowanie się powiodło!");
int id = Convert.ToInt32(ds.Tables[0].Rows[0]["id"]);
Boolean mod = Convert.ToBoolean(ds.Tables[0].Rows[0]["modpermission"]);
String name = Convert.ToString(ds.Tables[0].Rows[0]["username"]);
User user = new User(name, mod, id);
this.Hide();
if (!Convert.ToBoolean(ds.Tables[0].Rows[0]["modpermission"]))
{
MainUserPage fm = new MainUserPage();
fm.user = user;
fm.Show();
}
if (Convert.ToBoolean(ds.Tables[0].Rows[0]["modpermission"]))
{
ManagerPage fm = new ManagerPage();
fm.user = user;
fm.Show();
}
}
else
{
MessageBox.Show("Logowanie nieudane!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void yesbtn_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
int car_id = Convert.ToInt32(cartobuygrid.Rows[0].Cells["id"].Value);
int value = Convert.ToInt32(cartobuygrid.Rows[0].Cells["price"].Value);
DateTime date = DateTime.Today;
SqlCommand cmd = new SqlCommand("INSERT INTO [transaction] (client_id, car_id, date, value, accepted) VALUES (@client_id, @car_id, @date, @value, 1)", con);
cmd.Parameters.AddWithValue("@client_id", user.id);
cmd.Parameters.AddWithValue("@car_id", car_id);
cmd.Parameters.AddWithValue("@value", value);
cmd.Parameters.AddWithValue("@date", date.ToString("d"));
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Zakup przebiegł pomyślnie!");
}
catch (Exception ex)
{
MessageBox.Show("Zakup się nie powiódł!");
MessageBox.Show(ex.Message);
}
//SqlCommand cmds = new SqlCommand("DELETE FROM car WHERE id = CONVERT(int, @car_id)", con);
SqlCommand cmds = new SqlCommand("UPDATE car SET available = 0 WHERE id = @car_id;", con);
cmds.Parameters.AddWithValue("@car_id", car_id);
try
{
cmds.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (user.mod == true)
{
ManagerPage menu = new ManagerPage();
menu.user = user;
menu.Show();
this.Close();
}
if (user.mod == false)
{
MainUserPage menu = new MainUserPage();
menu.user = user;
menu.Show();
this.Close();
}
}
}
private void backtbn_Click(object sender, EventArgs e)
{
if (user.mod == true)
{
ManagerPage menu = new ManagerPage();
menu.user = user;
menu.Show();
this.Close();
}
if (user.mod == false)
{
MainUserPage menu = new MainUserPage();
menu.user = user;
menu.Show();
this.Close();
}
}
private void backbtn_Click(object sender, EventArgs e)
{
clientgrid.CancelEdit();
if (user.mod == true)
{
ManagerPage menu = new ManagerPage();
menu.user = user;
menu.Show();
this.Close();
}
if (user.mod == false)
{
MainUserPage menu = new MainUserPage();
menu.user = user;
menu.Show();
this.Close();
}
}
private void register_Click(object sender, EventArgs e)
{
if (txt_UserName.Text == "" || txt_Password.Text == "")
{
MessageBox.Show("Wpisz nazwę użytkownia i hasło");
return;
}
try
{
/*
* Database1Entities1 db = new Database1Entities1();
* login dp = new login();
* dp.username = txt_UserName.Text;
* dp.password = txt_Password.Text;
* db.login.Add(dp);
* db.SaveChanges();
* MessageBox.Show("Rejestracja się powiodła!");
* this.Hide();
* MainUserPage fm = new MainUserPage();
* fm.username = txt_UserName.Text;
* fm.Show();
*
*
*/
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("Select * from login where UserName=@username and Password=@password", con);
cmd.Parameters.AddWithValue("@username", txt_UserName.Text);
cmd.Parameters.AddWithValue("@password", txt_Password.Text);
con.Open();
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
int count = ds.Tables[0].Rows.Count;
if (count == 0)
{
SqlCommand cmds = new SqlCommand("INSERT INTO login (username, password) VALUES ('" + txt_UserName.Text + "', '" + txt_Password.Text + "')", con);
try
{
cmds.ExecuteNonQuery();
MessageBox.Show("Rejestracja się powiodła!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
int id = Convert.ToInt32(ds.Tables[0].Rows[0]["id"]);
Boolean mod = Convert.ToBoolean(ds.Tables[0].Rows[0]["modpermission"]);
String name = Convert.ToString(ds.Tables[0].Rows[0]["username"]);
User user = new User(name, mod, id);
this.Hide();
MainUserPage fm = new MainUserPage();
fm.user.name = this.user.name;
fm.Show();
}
else
{
MessageBox.Show("Rejestracja się nie powiodła!");
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}