public static void Sua(LoaiVeDTO loaive) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Thêm SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; //command.CommandText = "INSERT INTO NHANVIEN VALUES(@MANV,@HOTEN,@CHUCVU,@SDT,@GIOITINH,@NGAYSINH,@DIACHI,@LUONG,@NGAYVL)"; command.CommandText = "EXEC SuaLoaiVe @MALV,@TENLV,@LOAICHONGOI,@GIA"; command.Parameters.Add("@MALV", SqlDbType.VarChar, 10); command.Parameters.Add("@TENLV", SqlDbType.NVarChar, 100); command.Parameters.Add("@LOAICHONGOI", SqlDbType.NVarChar, 100); command.Parameters.Add("@GIA", SqlDbType.Money); // gán giá trị command.Parameters["@MALV"].Value = loaive.MaLV; command.Parameters["@TENLV"].Value = loaive.TenLV; command.Parameters["@LOAICHONGOI"].Value = loaive.LoaiChoNgoi; command.Parameters["@GIA"].Value = loaive.Gia; command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static void Them(VeDTO ve) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Thêm SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; //command.CommandText = "INSERT INTO PHIM VALUES(@MALV,@TENLV,@LOAICHONGOI,@GIA,@MALP,@NOIDUNG,@NAMSX,@NUOCSX,@THOILUONG)"; command.CommandText = "EXEC ThemVe @MAPHIM,@MAPC,@MALV,@SOLUONG"; command.Parameters.Add("@MAPHIM", SqlDbType.VarChar, 10); command.Parameters.Add("@MAPC", SqlDbType.VarChar, 10); command.Parameters.Add("@MALV", SqlDbType.VarChar, 10); command.Parameters.Add("@SOLUONG", SqlDbType.Int); // gán giá trị command.Parameters["@MAPHIM"].Value = ve.MaPhim; command.Parameters["@MAPC"].Value = ve.MaPC; command.Parameters["@MALV"].Value = ve.MaLV; command.Parameters["@SOLUONG"].Value = ve.SoLuong; command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static void Them(NguoiDungDTO nguoidung) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Thêm SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; //command.CommandText = "INSERT INTO NHANVIEN VALUES(@MANV,@HOTEN,@CHUCVU,@SDT,@GIOITINH,@NGAYSINH,@DIACHI,@LUONG,@NGAYVL)"; command.CommandText = "EXEC ThemNguoiDung @MAND,@HOTEN,@CHUCVU,@PHANQUYEN"; command.Parameters.Add("@MAND", SqlDbType.VarChar, 10); command.Parameters.Add("@HOTEN", SqlDbType.NVarChar, 40); command.Parameters.Add("@CHUCVU", SqlDbType.VarChar, 100); command.Parameters.Add("@PHANQUYEN", SqlDbType.VarChar, 100); // gán giá trị command.Parameters["@MANV"].Value = nguoidung.MaND; command.Parameters["@HOTEN"].Value = nguoidung.HoTen; command.Parameters["@CHUCVU"].Value = nguoidung.ChucVu; command.Parameters["@SDT"].Value = nguoidung.PhanQuyen; command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static void Sua(LoaiPhimDTO loaiphim) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Thêm SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; //command.CommandText = "INSERT INTO NHANVIEN VALUES(@MANV,@HOTEN,@CHUCVU,@SDT,@GIOITINH,@NGAYSINH,@DIACHI,@LUONG,@NGAYVL)"; command.CommandText = "EXEC Sualoaiphim @MALP,@TENLP,@MOTA"; command.Parameters.Add("@MALP", SqlDbType.VarChar, 10); command.Parameters.Add("@TENLP", SqlDbType.NVarChar, 40); command.Parameters.Add("@MOTA", SqlDbType.NVarChar, 1000); // gán giá trị command.Parameters["@MALP"].Value = loaiphim.MaLP; command.Parameters["@TENLP"].Value = loaiphim.TenLP; command.Parameters["@MOTA"].Value = loaiphim.MoTa; command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static void Them(DangNhapKhachHangDTO khachhang) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Thêm SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC TaoTaiKhoanKH @MAKH,@USER,@PASS"; //command.CommandText = "INSERT INTO KHACHHANGTHANTHIET VALUES(@MAKH,@HOTEN,@DIACHI,@NGAYSINH,@GIOITINH,@SDT,@LOAIKH,@NGAYDK)"; command.Parameters.Add("@MAKH", SqlDbType.VarChar, 10); command.Parameters.Add("@USER", SqlDbType.VarChar, 50); command.Parameters.Add("@PASS", SqlDbType.VarChar, 50); // gán giá trị command.Parameters["@MAKH"].Value = khachhang.MaKH; command.Parameters["@USER"].Value = khachhang.TAIKHOAN; command.Parameters["@PASS"].Value = khachhang.MATKHAU; command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static bool Login(string user, string pass) { using (var connection = SQLConnectionData.HamKetNoi()) { connection.Open(); using (var command = new SqlCommand()) { command.Connection = connection; command.CommandText = "EXEC Dangnhapnhanvien '" + user + "','" + pass + "'"; // command.CommandText = "SELECT * FROM NGUOIDUNG WHERE TAIKHOAN=@user AND MATKHAU=@pass"; command.Parameters.AddWithValue("@user", user); command.Parameters.AddWithValue("@pass", pass); command.CommandType = CommandType.Text; SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { tk = user; Mk = pass; HoTen = reader.GetString(0); ChucVu = reader.GetString(1); } return(true); } else { return(false); } } } }
public static void Sua(KhachHangDTO khachhang) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Sửa SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; //command.CommandText = "EXEC SuaKhachHang @MAKH,@HOTEN,@DIACHI,@NGAYSINH,@GIOITINH,@SDT,@LOAIKH,@NGAYDK"; command.CommandText = "set dateformat dmy\n EXEC SuaKhachHang '" + khachhang.MaKH + "'" + ",N'" + khachhang.HoTen + "'" + ",N'" + khachhang.DiaChi + "'" + ",'" + khachhang.NgaySinh_String + "'" + ",N'" + khachhang.GioiTinh + "'" + ",'" + khachhang.SDT + "'" + ",N'" + khachhang.LoaiKH + "'" + ",'" + khachhang.NgayDK_String + "'"; command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static void Them(VeDTO ve) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Thêm SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC ThemVe @MAVE,@MALC,@NGAY_GIO_MUA,@TONGCONG,@MAKH"; command.Parameters.Add("@MAVE", SqlDbType.VarChar, 10); command.Parameters.Add("@MALC", SqlDbType.VarChar, 10); command.Parameters.Add("@NGAY_GIO_MUA", SqlDbType.DateTime); command.Parameters.Add("@TONGCONG", SqlDbType.Money); command.Parameters.Add("@MAKH", SqlDbType.VarChar, 10); // gán giá trị command.Parameters["@MAVE"].Value = ve.MaVe; command.Parameters["@MALC"].Value = ve.MaLC; command.Parameters["@NGAY_GIO_MUA"].Value = ve.Ngay_Gio_Mua; command.Parameters["@TONGCONG"].Value = ve.TongCong; command.Parameters["@MAKH"].Value = ve.MaKH; command.ExecuteNonQuery(); connection.Close(); }
public static bool Login(string user, string pass) { using (var connection = SQLConnectionData.HamKetNoi()) { connection.Open(); using (var command = new SqlCommand()) { command.Connection = connection; command.CommandText = "SELECT NV.HOTEN,NV.CHUCVU,NV.SDT,DN.TAIKHOAN,DN.MATKHAU FROM DANGNHAP_NHANVIEN DN INNER JOIN NHANVIEN NV ON DN.MANV=NV.MANV" + " WHERE DN.TAIKHOAN=@user AND DN.MATKHAU=@pass"; // command.CommandText = "SELECT * FROM NGUOIDUNG WHERE TAIKHOAN=@user AND MATKHAU=@pass"; command.Parameters.AddWithValue("@user", user); command.Parameters.AddWithValue("@pass", pass); command.CommandType = CommandType.Text; SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { //// UserLoginCache.MaNV = reader.GetString(0); //DangNhapNhanVienDTO = reader.GetString(0); //UserLoginCache.ChucVu = reader.GetString(1); //UserLoginCache.SDT = reader.GetString(2); } return(true); } else { return(false); } } } }
public static void Sua(VeDTO ve) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Thêm SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; //command.CommandText = "INSERT INTO NHANVIEN VALUES(@MANV,@HOTEN,@CHUCVU,@SDT,@GIOITINH,@NGAYSINH,@DIACHI,@LUONG,@NGAYVL)"; command.CommandText = "EXEC SuaVe @MAPHIM,@MAPC,@MALV,@SOLUONG"; command.Parameters.Add("@MAPHIM", SqlDbType.VarChar, 10); command.Parameters.Add("@MAPC", SqlDbType.VarChar, 10); command.Parameters.Add("@MALV", SqlDbType.VarChar, 10); command.Parameters.Add("@SOLUONG", SqlDbType.Int); // gán giá trị command.Parameters["@MAPHIM"].Value = ve.MaPhim; command.Parameters["@MAPC"].Value = ve.MaPC; command.Parameters["@MALV"].Value = ve.MaLV; command.Parameters["@SOLUONG"].Value = ve.SoLuong; command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static void Sua(CaChieuDTO cachieu) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Thêm SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC SuaCaChieu @MACC,@TENCC,@BATDAU,@KETTHUC"; command.Parameters.Add("@MACC", SqlDbType.VarChar, 10); command.Parameters.Add("@TENCC", SqlDbType.NVarChar, 100); command.Parameters.Add("@BATDAU", SqlDbType.DateTime); command.Parameters.Add("@KETTHUC", SqlDbType.DateTime); // gán giá trị command.Parameters["@MACC"].Value = cachieu.MaCC; command.Parameters["@TENCC"].Value = cachieu.TenCC; command.Parameters["@BATDAU"].Value = cachieu.BatDau.ToLongTimeString(); command.Parameters["@KETTHUC"].Value = cachieu.KetThuc.ToLongTimeString(); command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static void Them(KhachHangDTO khachhang) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Thêm SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; //command.CommandText = "EXEC Them_khachhang @MAKH,@HOTEN,@DIACHI,@NGAYSINH,@GIOITINH,@SDT,@LOAIKH,@NGAYDK"; // 'KH5',N'pham quoc trung',N'123123','1/7/2021 12:00:00 AM',N'Nam','1231232','1/7/2021 9:04:22 AM' command.CommandText = "set dateformat dmy\n EXEC Them_khachhang '" + khachhang.MaKH + "'" + ",N'" + khachhang.HoTen + "'" + ",N'" + khachhang.DiaChi + "'" + ",'" + khachhang.NgaySinh_String + "',N'" + khachhang.GioiTinh + "','" + khachhang.SDT + "','" + khachhang.Ngaydk + "'"; command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static void Them(LichChieuDTO lichchieu) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Thêm SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = " EXEC ThemLichChieu @NGAYCHIEU,@MAPHIM,@MACC,@MAPC "; command.Parameters.Add("@NGAYCHIEU", SqlDbType.Date); command.Parameters.Add("@MAPHIM", SqlDbType.VarChar, 10); command.Parameters.Add("@MACC", SqlDbType.VarChar, 10); command.Parameters.Add("@MAPC", SqlDbType.VarChar, 10); // gán giá trị command.Parameters["@NGAYCHIEU"].Value = lichchieu.NgayChieu; command.Parameters["@MAPHIM"].Value = lichchieu.MaPhim; command.Parameters["@MACC"].Value = lichchieu.MaCC; command.Parameters["@MAPC"].Value = lichchieu.MaPC; command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static void Them(LoaiVeDTO loaive) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Thêm SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; //command.CommandText = "INSERT INTO PHIM VALUES(@MALV,@TENLV,@LOAICHONGOI,@GIA,@MALP,@NOIDUNG,@NAMSX,@NUOCSX,@THOILUONG)"; command.CommandText = "EXEC ThemLoaiVe @MALV,@TENLV,@LOAICHONGOI,@GIA"; command.Parameters.Add("@MALV", SqlDbType.VarChar, 10); command.Parameters.Add("@TENLV", SqlDbType.NVarChar, 100); command.Parameters.Add("@LOAICHONGOI", SqlDbType.NVarChar, 100); command.Parameters.Add("@GIA", SqlDbType.Money); // gán giá trị command.Parameters["@MALV"].Value = loaive.MaLV; command.Parameters["@TENLV"].Value = loaive.TenLV; command.Parameters["@LOAICHONGOI"].Value = loaive.LoaiChoNgoi; command.Parameters["@GIA"].Value = loaive.Gia; command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static DataTable TimTheoMaKH(string makh) { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "SELECT HD.STT,HD.SOHD,HD.NGAYHD,HD.GIOHD,KH.HOTEN,QTN.TENQTN,NV.HOTEN,HD.TONGCONG " + " FROM HOADON HD JOIN KHACHHANGTHANTHIET KH ON KH.MAKH=HD.MAKH " + " JOIN QUAYTN QTN ON QTN.MAQTN=HD.MAQTN " + " JOIN NHANVIEN NV ON NV.MANV=QTN.MANV " + " WHERE MAKH LIKE '" + makh + "%'"; // gán giá trị command.ExecuteNonQuery(); SqlDataAdapter dataAdapter = new SqlDataAdapter(command); DataTable dataTable = new DataTable(); dataAdapter.Fill(dataTable); connection.Close(); return(dataTable); }
public List <NhanVienDTO> GetAll() { List <NhanVienDTO> list_nv = new List <NhanVienDTO>(); // string query = "SelectAllNhanVien"; SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = " EXEC LoadNhanVien "; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { NhanVienDTO nv = new NhanVienDTO(); nv.MaNV = reader.GetString(1); nv.HoTen = reader.GetString(2); nv.ChucVu = reader.GetString(3); nv.SDT = reader.GetString(4); nv.GioiTinh = reader.GetString(5); nv.NgaySinh = reader.GetDateTime(6); nv.DiaChi = reader.GetString(7); nv.Luong = reader.GetDecimal(8).ToString(); nv.NgayVL = reader.GetDateTime(9); list_nv.Add(nv); } return(list_nv); }
public static void Xoa(string macc) { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC XoaCaChieu '" + macc + "'"; command.ExecuteNonQuery(); connection.Close(); }
public static int Phanquyen(string user, string pass) { using (var connection = SQLConnectionData.HamKetNoi()) { connection.Open(); // using (SqlCommand cmd = new SqlCommand("EXEC Phanquyennhanvien '"+user+"','"+pass+"'", connection)) using (SqlCommand cmd = new SqlCommand("EXEC PhanQuyen '" + user + "','" + pass + "'", connection)) { cmd.CommandType = CommandType.Text; using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { DataSet ds = new DataSet(); sda.Fill(ds); string a = ""; foreach (DataRow row in ds.Tables[0].Rows) { //a = row["CHUCVU"].ToString(); a = row["PHANQUYEN"].ToString(); } if (a == "Quản trị") { return(1); } // else if (a == "Nhân viên quản lý phim") else if (a == "Quản lý phim, Quản lý loại phim") { return(2); } // else if (a == "Nhân viên quản lý phòng chiếu") else if (a == "Quản lý phòng chiếu") { return(3); } // else if (a == "Nhân viên quản lý lịch chiếu") else if (a == "Quản lý lịch chiếu") { return(4); } // else if (a == "Nhân viên bán vé") else if (a == "Quản lý loại vé, Quản lý vé") { return(5); } return(0); } } } }
public static void Xoa(DateTime ngaychieu, string maphim, string macc, string mapc) { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC XoaLichChieu " + "'" + ngaychieu + "','" + maphim + "','" + macc + "','" + mapc + "'"; command.ExecuteNonQuery(); connection.Close(); }
public static void Xoa(string maphim, string mapc, string malv) { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC XoaVe " + "'" + maphim + "','" + mapc + "','" + malv + "'"; command.ExecuteNonQuery(); connection.Close(); }
public static void Sua(NhanVienDTO nhanvien) { // mở kết nối SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); // tạo câu lệnh Sửa SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC Suanhanvien @MANV,@HOTEN,@CHUCVU,@SDT,@GIOITINH,@NGAYSINH,@DIACHI,@LUONG,@NGAYVL"; //command.CommandText = "UPDATE NHANVIEN " + // "SET MANV=@MANV ," + // "HOTEN=@HOTEN," + // "CHUCVU=@CHUCVU," + // "SDT=@SDT," + // "GIOITINH=@GIOITINH," + // "NGAYSINH=@NGAYSINH," + // "DIACHI=@DIACHI," + // "LUONG=@LUONG," + // "NGAYVL=@NGAYVL " + // "WHERE MANV=@MANV"; command.Parameters.Add("@MANV", SqlDbType.VarChar, 10); command.Parameters.Add("@HOTEN", SqlDbType.NVarChar, 40); command.Parameters.Add("@CHUCVU", SqlDbType.NVarChar, 100); command.Parameters.Add("@SDT", SqlDbType.VarChar, 20); command.Parameters.Add("@GIOITINH", SqlDbType.NVarChar, 4); command.Parameters.Add("@NGAYSINH", SqlDbType.DateTime); command.Parameters.Add("@DIACHI", SqlDbType.NVarChar, 100); command.Parameters.Add("@LUONG", SqlDbType.Money); command.Parameters.Add("@NGAYVL", SqlDbType.DateTime); // gán giá trị command.Parameters["@MANV"].Value = nhanvien.MaNV; command.Parameters["@HOTEN"].Value = nhanvien.HoTen; command.Parameters["@CHUCVU"].Value = nhanvien.ChucVu; command.Parameters["@SDT"].Value = nhanvien.SDT; command.Parameters["@GIOITINH"].Value = nhanvien.GioiTinh; command.Parameters["@NGAYSINH"].Value = nhanvien.NgaySinh; command.Parameters["@DIACHI"].Value = nhanvien.DiaChi; command.Parameters["@LUONG"].Value = nhanvien.Luong; command.Parameters["@NGAYVL"].Value = nhanvien.NgayVL; // thực hiện câu lệnh command.ExecuteNonQuery(); // đóng kết nối connection.Close(); }
public static void Xoa(string sohd) { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "DELETE FROM HOADON " + "WHERE SOHD=@SOHD"; command.Parameters.Add("@SOHD", SqlDbType.VarChar, 10); // gán giá trị command.Parameters["@SOHD"].Value = sohd; command.ExecuteNonQuery(); connection.Close(); }
public static DataTable LichSuDatVe_LayDSGhe(string makh, string mave) { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC LichSuDatVe_LayDSGhe '" + makh + "','" + mave + "'"; DataTable dataTable = new DataTable(); SqlDataAdapter dataAdapter = new SqlDataAdapter(command); dataAdapter.Fill(dataTable); connection.Close(); return(dataTable); }
public static void Xoa(string makh) { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC Xoakhachhang '" + makh + "'"; //command.CommandText = "DELETE KH FROM KHACHHANGTHANTHIET KH " + // "WHERE KH.MAKH='" + makh + "'"; //command.Parameters.Add("@MANV", SqlDbType.VarChar, 10); // gán giá trị //command.Parameters["@MANV"].Value = manv; command.ExecuteNonQuery(); connection.Close(); }
public static void Xoa(string malp) { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC Xoaloaiphim '" + malp + "'"; //command.CommandText = "DELETE NV FROM NHANVIEN NV " + // "WHERE NV.MANV='" + manv + "'"; //command.Parameters.Add("@MANV", SqlDbType.VarChar, 10); // gán giá trị //command.Parameters["@MANV"].Value = manv; command.ExecuteNonQuery(); connection.Close(); }
public static DataTable LoadDSHoaDon() { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "LoadDSVe"; DataTable dataTable = new DataTable(); SqlDataAdapter dataAdapter = new SqlDataAdapter(command); dataAdapter.Fill(dataTable); connection.Close(); return(dataTable); }
public static DataTable LoadTheLoaiPhim(string maphim) { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC LoadTheLoaiPhim '" + maphim + "'"; command.ExecuteNonQuery(); SqlDataAdapter dataAdapter = new SqlDataAdapter(command); DataTable dataTable = new DataTable(); dataAdapter.Fill(dataTable); connection.Close(); return(dataTable); }
//Load danh sách sv từ database public static DataTable LoadDSPC() { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "EXEC LoadDSPhongChieu "; DataTable dataTable = new DataTable(); SqlDataAdapter dataAdapter = new SqlDataAdapter(command); dataAdapter.Fill(dataTable); connection.Close(); return(dataTable); }
public static DataTable HienLichChieuPhim_NgayChieu_MaCC_MaPC(DateTime ngaychieu, string macc, string mapc) { SqlConnection connection = SQLConnectionData.HamKetNoi(); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = " EXEC HienLichChieuPhim_NgayChieu_MaCC_MaPC '" + ngaychieu + "'" + ",'" + macc + "'" + ",'" + mapc + "'"; DataTable dataTable = new DataTable(); SqlDataAdapter dataAdapter = new SqlDataAdapter(command); dataAdapter.Fill(dataTable); connection.Close(); return(dataTable); }
public static int Phanquyen(string user, string pass) { using (var connection = SQLConnectionData.HamKetNoi()) { connection.Open(); using (SqlCommand cmd = new SqlCommand("EXEC Phanquyenkhachhang '" + user + "', '" + pass + "'", connection)) { cmd.CommandType = CommandType.Text; using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { DataSet ds = new DataSet(); sda.Fill(ds); string a = ""; foreach (DataRow row in ds.Tables[0].Rows) { a = row["LOAIKH"].ToString(); } /// quanly :1 nhanvien ban hang :2 if (a == "Đồng") { return(1); } else if (a == "Bạc") { return(2); } else if (a == "Vàng") { return(3); } else if (a == "Bạch kim") { return(4); } else if (a == "Kim cương") { return(5); } return(0); } } } }