private void button1_Click(object sender, System.EventArgs e)
{
string login = loginBX.Text;
string password = passBX.Text;
string MyConString = "SERVER=localhost;" +
"DATABASE=baza;" +
"UID=root;";
MySqlConnection connection = new MySqlConnection(MyConString);
string command = "select ID, posada from pracownicy where login='******' and haslo='" + password + "';";
MySqlDataAdapter da = new MySqlDataAdapter(command, connection);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
if (Convert.ToInt32(dt.Rows[0][1]) == 1)
{
Serw serw = new Serw(login);
serw.Show();
this.Hide();
}
else
{
Admin admin = new Admin();
admin.Show();
this.Hide();
}
}
}
public RezervasyonListe()
{
InitializeComponent();
this.FormClosed += new FormClosedEventHandler(Form1_FormClosed);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
Admin admin = new Admin();
OleDbDataAdapter dAdapter = admin.RezervasyonListele();
DataTable dataTable = new DataTable();
DataSet ds = new DataSet();
admin.RezervasyonListele().Fill(dataTable);
dataGridView1.DataSource = dataTable;
dAdapter.Dispose();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Equals(""))
{
MessageBox.Show("Lutfen parametrelerinizi kontrol ediniz");
}
else
{
Admin admin = new Admin();
if (admin.RezervasyonSil(textBox1.Text) == 1)
{
MessageBox.Show("Rezervasyon silindi");
}
else
{
MessageBox.Show("Rezervasyon bulunamadi");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
Admin admin = new Admin();
DatabaseManager dbManager = DatabaseManager.dataBaseManager();
dbManager.BookConn = new OleDbConnection(dbManager.getConnParam());
CreateCustomerAdapter(dbManager.BookConn);
}
private void Update_Search_FormClosing(object sender, FormClosingEventArgs e)
{
Admin form = new Admin();
form.Show();
}
