private void button2_Click(object sender, EventArgs e)
{
this.Hide();
manager_window m = new manager_window();
m.Show();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
conn.Open();
string query = "select username from user_account where username='******'";
SqlCommand comm = new SqlCommand(query, conn);
SqlDataReader rd = comm.ExecuteReader();
if (rd.HasRows == true)
{
conn.Close();
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
conn.Open();
string q = "delete from user_account where username='******'";
SqlCommand com = new SqlCommand(q, conn);
com.ExecuteNonQuery();
MessageBox.Show("login deleted");
this.Hide();
manager_window m = new manager_window();
m.Show();
con.Close();
}
else
{
MessageBox.Show("no user exist with this username");
}
}
else
{
MessageBox.Show("mention username");
}
}
private void button1_Click(object sender, EventArgs e)
{
string str1 = textBox2.Text.ToString();
string str = textBox5.Text.ToString();
bool flag1 = true;
for (int i = 0; i < str1.Length; i++)
{
if (str1[i] < '0' || str1[i] > '9')
{
flag1 = false;
}
}
bool flag = true;
for (int i = 0; i < str.Length; i++)
{
if (str[i] < '0' || str[i] > '9')
{
flag1 = false;
}
}
if (flag1 && flag && textBox1.Text != "" && comboBox2.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox5.Text != "" && Int32.Parse(textBox2.Text.ToString()) > 0 && Int32.Parse(textBox5.Text.ToString()) > 10)
{
SqlConnection co = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
co.Open();
string q1 = "select P_name from products where P_name='" + textBox1.Text + "'";
SqlCommand c = new SqlCommand(q1, co);
SqlDataReader rd = c.ExecuteReader();
if (rd.HasRows != true)
{
co.Close();
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
conn.Open();
string query = "insert into products values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + comboBox2.Text + "','" + textBox5.Text + "')";
SqlCommand comm = new SqlCommand(query, conn);
comm.ExecuteNonQuery();
MessageBox.Show("new food item successfully added");
this.Hide();
manager_window m = new manager_window();
m.Show();
conn.Close();
}
else
{
MessageBox.Show("this product already exist");
}
}
else
{
MessageBox.Show("invalid entries");
}
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
conn.Open();
string query = "select status from user_account where username='******' and password='******'";
SqlCommand comm = new SqlCommand(query, conn);
SqlDataReader rd = comm.ExecuteReader();
if (rd.HasRows == true)
{
rd.Read();
if (textBox1.Text == "ali123")
{
this.Hide();
manager_window m = new manager_window();
m.Show();
conn.Close();
}
//else if (rd["status"].ToString() == "cashier")
//else if (textBox1.Text.ToString() == "amir321")
else
{
this.Hide();
PBill m = new PBill();
m.Show();
conn.Close();
}
}
else
{
MessageBox.Show("wrong id or password");
this.Hide();
login l = new login();
l.Show();
conn.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && textBox4.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "" && (textBox3.Text == "cashier"))
{
SqlConnection co = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
co.Open();
string q1 = "select username from user_account where username='******'";
SqlCommand c = new SqlCommand(q1, co);
SqlDataReader rd = c.ExecuteReader();
if (rd.HasRows != true)
{
co.Close();
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
conn.Open();
string query = "insert into user_account values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')";
SqlCommand comm = new SqlCommand(query, conn);
comm.ExecuteNonQuery();
MessageBox.Show("login created");
this.Hide();
manager_window m = new manager_window();
m.Show();
conn.Close();
}
else
{
MessageBox.Show("this username already exist");
}
}
else
{
MessageBox.Show("invalid entries");
}
}
private void button1_Click(object sender, EventArgs e)
{
string str1 = textBox2.Text.ToString();
bool flag1 = true;
for (int i = 0; i < str1.Length; i++)
{
if (str1[i] < '0' || str1[i] > '9')
{
flag1 = false;
}
}
string str2 = textBox6.Text.ToString();
bool flag = true;
int j = 0;
while (j < str2.Length)
{
if (str2[j] < '0' || str1[j] > '9')
{
flag1 = false;
}
j++;
}
if (flag1 && flag && textBox1.Text != "" && textBox4.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox6.Text != "" && Int32.Parse(textBox2.Text.ToString()) > 0 && Int32.Parse(textBox6.Text.ToString()) > 10)
{
SqlConnection co = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
co.Open();
string q1 = "select P_name from products where P_name='" + textBox1.Text + "'";
SqlCommand c = new SqlCommand(q1, co);
SqlDataReader rd = c.ExecuteReader();
if (rd.HasRows != true)
{
co.Close();
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
con.Open();
string q = "delete from products where P_name='" + textBox5.Text + "'";
SqlCommand com = new SqlCommand(q, con);
com.ExecuteNonQuery();
con.Close();
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
conn.Open();
string query = "insert into products values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox6.Text + "')";
SqlCommand comm = new SqlCommand(query, conn);
comm.ExecuteNonQuery();
MessageBox.Show(" item successfully updated");
this.Hide();
manager_window m = new manager_window();
m.Show();
conn.Close();
//SqlConnection con5 = new SqlConnection(@"Data Source=SHEIKH\SQLEXPRESS;Initial Catalog=data1;Integrated Security=True;Pooling=False");
//con5.Open();
//string q5 = "delete from sales where order_id>'" + 1 + "'";
//SqlCommand com5 = new SqlCommand(q5, con5);
//com5.ExecuteNonQuery();
//con5.Close();
}
else
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
con.Open();
string q = "delete from products where P_name='" + textBox1.Text + "'";
SqlCommand com = new SqlCommand(q, con);
com.ExecuteNonQuery();
con.Close();
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\M. Hammad Shahid\Documents\Visual Studio 2013\Projects\hotel_management\hotel_management\Database1.mdf;Integrated Security=True");
conn.Open();
string query = "insert into products values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox6.Text + "')";
SqlCommand comm = new SqlCommand(query, conn);
comm.ExecuteNonQuery();
MessageBox.Show("item successfully updated");
this.Hide();
manager_window m = new manager_window();
m.Show();
conn.Close();
}
}
else
{
MessageBox.Show("invalid entries");
}
}
