private void button5_Click(object sender, EventArgs e)
{
plannerForm pf = new plannerForm();
SqlCommand cmd = new SqlCommand("update [Wedding planner] set wed_planner_available_time= '" + updatee.Text + "' where wed_planner_id='" + id + "' ", cn);
cn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("date has been updated ");
cn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection("Data Source =DESKTOP-74I7G65\\SQLEXPRESS; Initial Catalog=Weddingguide;Integrated Security = True ");
SqlDataAdapter da;
DataTable dt = new DataTable();
if (comboBox1.Text == admin)
{
da = new SqlDataAdapter("Select* from Admin where admin_name ='" + textBox1.Text + "'and admin_pass = '******'", cn);
da.Fill(dt);
if (dt.Rows.Count == 1)
{
adminForm f = new adminForm();
this.Hide();
f.Show();
}
else
{
MessageBox.Show("Incorrect username and password ", "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (comboBox1.Text == user)
{
da = new SqlDataAdapter("Select* from [User] where user_name ='" + textBox1.Text + "'and user_pass = '******'", cn);
da.Fill(dt);
if (dt.Rows.Count == 1)
{
userForm f = new userForm(dt.Rows[0]["user_name"].ToString(), Convert.ToInt32(dt.Rows[0]["user_id"]));
this.Hide();
f.Show();
}
else
{
MessageBox.Show("Incorrect username and password ", "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (comboBox1.Text == WeddingP)
{
da = new SqlDataAdapter("Select* from [wedding planner] where wed_planner_name ='" + textBox1.Text + "'and wedding_planner_pass = '******'", cn);
da.Fill(dt);
if (dt.Rows.Count == 1)
{
plannerForm f = new plannerForm(dt.Rows[0]["wed_planner_name"].ToString(), Convert.ToInt32(dt.Rows[0]["wed_planner_id"]));
this.Hide();
f.Show();
}
else
{
MessageBox.Show("Incorrect username and password ", "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
