private void btn_buy_Click(object sender, EventArgs e)
{
int index = dgv_seat.CurrentCell.RowIndex;
String veTrong = dgv_seat.Rows[index].Cells[5].Value.ToString();
if (veTrong.Equals("Trống"))
{
using (SqlConnection conn = new SqlConnection(SQLConnection.connectionString()))
using (SqlCommand cmd = new SqlCommand("sp_BanVe", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ve", SqlDbType.Int);
cmd.Parameters.Add("@thanhvien", SqlDbType.Char);
cmd.Parameters.Add("@nhanvienbanhang", SqlDbType.Int);
cmd.Parameters.Add("@uudai", SqlDbType.NVarChar);
cmd.Parameters.Add("@loaive", SqlDbType.NVarChar);
cmd.Parameters["@ve"].Value = int.Parse(dgv_seat.Rows[index].Cells[1].Value.ToString());
cmd.Parameters["@thanhvien"].Value = tb_identity.Text;
cmd.Parameters["@nhanvienbanhang"].Value = fLogin.employeeID;
if (rb_monday.Checked)
{
cmd.Parameters["@uudai"].Value = "Monday";
}
else if (rb_giasoc.Checked)
{
cmd.Parameters["@uudai"].Value = "GiaSoc";
}
else if (rb_birthday.Checked)
{
cmd.Parameters["@uudai"].Value = "SinhNhat";
}
else
{
cmd.Parameters["@uudai"].Value = DBNull.Value;
}
if (rb_adult.Checked)
{
cmd.Parameters["@loaive"].Value = "NL";
}
else if (rb_child.Checked)
{
cmd.Parameters["@loaive"].Value = "TE";
}
else if (rb_student.Checked)
{
cmd.Parameters["@loaive"].Value = "HSSV";
}
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Xong chưa?");
}
}
else
{
MessageBox.Show("Khong the mua duoc");
}
}
private void btn_statistic_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(SQLConnection.connectionString()))
thongke(conn);
}
private void button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tb_username.Text))
{
MessageBox.Show("Hãy nhập tên đăng nhập!");
}
else if (string.IsNullOrEmpty(tb_password.Text))
{
MessageBox.Show("Hãy nhập mật khẩu!");
}
else
{
string position = "";
if (rb_manager.Checked)
{
position = "QL";
}
else if (rb_seller.Checked)
{
position = "NV";
}
using (SqlConnection conn = new SqlConnection(SQLConnection.connectionString()))
using (SqlCommand cmd = new SqlCommand("sp_DangNhap", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cmnd", SqlDbType.NVarChar);
cmd.Parameters.Add("@matKhau", SqlDbType.NVarChar);
cmd.Parameters.Add("@chucvu", SqlDbType.Char);
cmd.Parameters.Add("@idrap", SqlDbType.Int);
cmd.Parameters.Add("@idnhanvien", SqlDbType.Int);
cmd.Parameters["@cmnd"].Value = tb_username.Text;
cmd.Parameters["@matKhau"].Value = tb_password.Text;
cmd.Parameters["@chucvu"].Value = position;
cmd.Parameters["@idrap"].Direction = ParameterDirection.Output;
cmd.Parameters["@idnhanvien"].Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteScalar();
//cmd.ExecuteNonQuery();
employeeID = (int)cmd.Parameters["@idnhanvien"].Value;
cinemaID = (int)cmd.Parameters["@idrap"].Value;
if (employeeID > 0)
{
if (position == "QL")
{
fManager form = new fManager();
this.Hide();
form.ShowDialog();
this.Show();
}
else
{
fTicketClerk form = new fTicketClerk();
this.Hide();
form.ShowDialog();
this.Show();
}
}
else
{
MessageBox.Show("Đăng nhập thất bại!");
}
conn.Close();
}
}
}
