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(); } } }