public static int themMoi(NhaCungCapDTO dto)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.ThemNhaCungCap";
//// create a new parameter
DbParameter param = command.CreateParameter();
param.ParameterName = "@tenNhaCungCap";
param.Value = dto.TenNhaCungCap;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@dienThoai";
param.Value = dto.DienThoai;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@soTaiKhoan";
param.Value = dto.SoTaiKhoan;
param.DbType = DbType.String;
command.Parameters.Add(param);
return(DataAccessCode.ExecuteNonQuery(command));
}
public static int setNgungGiaoDich(int maNhaCungCap, int maNhaHang, int tinhTrang)
{
DbCommand command = DataAccessCode.CreateCommand();
//command.CommandText = "dbo.setNgungGiaoDich";
command.CommandText = "dbo.setNgungGiaoDich";
//// create a new parameter
DbParameter param = command.CreateParameter();
param.ParameterName = "@maNhaCungCap";
param.Value = maNhaCungCap;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@maNhaHang";
param.Value = maNhaHang;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@tinhTrang";
param.Value = tinhTrang;
param.DbType = DbType.Int16;
command.Parameters.Add(param);
return(DataAccessCode.ExecuteNonQuery(command));
}
public static DataTable LayBangNhaHang()
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayDanhSachNhaHang";
return(DataAccessCode.ExecuteSelectCommand(command));
}
internal static List <LichLamViecDTO> LoadLichLamViec()
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayDanhSachLichLamViec";
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
List <LichLamViecDTO> list = new List <LichLamViecDTO>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
LichLamViecDTO lich = new LichLamViecDTO();
lich.MaNhanVien = Int32.Parse(dt.Rows[i]["MaNhanVien"].ToString());
lich.HoNhanVien = dt.Rows[i]["HoNhanVien"].ToString();
lich.TenNhanVien = dt.Rows[i]["TenNhanVien"].ToString();
lich.Thu = Int32.Parse(dt.Rows[i]["Thu"].ToString());
lich.Ca = Int32.Parse(dt.Rows[i]["Ca"].ToString());
list.Add(lich);
}
}
return(list);
}
// cấp phát
public static DataTable LayBangNguoiDung()
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayTaiKhoan";
return(DataAccessCode.ExecuteSelectCommand(command));
}
public static int layMaThongTinHangNhap(DateTime ngayGioNhap, int maKhoHang)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.layIDThongTinHangNhap";
DbParameter param = command.CreateParameter();
param.ParameterName = "@ngayGioNhap";
param.Value = ngayGioNhap;
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@maKhoHang";
param.Value = maKhoHang;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
int id = -1;
if (dt != null)
{
id = Convert.ToInt32(dt.Rows[0]["MaThongTinHangNhap"]);
}
return(id);
}
public static List <ThongTinBanDTO> LayDanhSachThongTinBan(int maKhuVuc)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayDanhSachThongTinBan";
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaKhuVuc";
if (maKhuVuc == 0)
{
param.Value = DBNull.Value;
}
else
{
param.Value = maKhuVuc;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
List <ThongTinBanDTO> list = new List <ThongTinBanDTO>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ThongTinBanDTO thongTinBan = new ThongTinBanDTO();
thongTinBan.MaBan = Int32.Parse(dt.Rows[i]["MaBan"].ToString());
thongTinBan.MaKhuVuc = Int32.Parse(dt.Rows[i]["MaKhuVuc"].ToString());
thongTinBan.TenBan = dt.Rows[i]["TenBan"].ToString();
thongTinBan.SucChua = Int32.Parse(dt.Rows[i]["SucChua"].ToString());
list.Add(thongTinBan);
}
}
return(list);
}
//LOST UPDATED SOLVED
public static int lostUpdatedSolvedXuatNguyenLieu(KhoHang_NguyenLieuDTO dto, int maNhaHang, int mucCoLap)
{
DbCommand command = DataAccessCode.CreateCommand();
DbParameter param = command.CreateParameter();
command.CommandText = "dbo.lostUpdatedSolvedXuatNguyenLieu";
//// create a new parameter
param.ParameterName = "@soLuongXuat";
param.Value = dto.SoLuongXuat;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@maNguyenLieu";
param.Value = dto.NguyenLieu.MaNguyenLieu;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@maNhaHang";
param.Value = maNhaHang;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@mucCoLap";
param.Value = mucCoLap;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
return(DataAccessCode.ExecuteNonQuery(command));
}
public static List <ChiTietThucDonDTO> LayDanhSachMonAnTheoNhaHang(int maNhaHang, DateTime ngay)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayDanhSachMonAnTheoNhaHang";
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaNhaHang";
param.Value = maNhaHang;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Ngay";
param.Value = ngay;
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
List <ChiTietThucDonDTO> list = new List <ChiTietThucDonDTO>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ChiTietThucDonDTO chiTietThucDon = new ChiTietThucDonDTO();
chiTietThucDon.MaChiTietThucDon = Int32.Parse(dt.Rows[i]["MaChiTietThucDon"].ToString());
chiTietThucDon.MaMonAn = Int32.Parse(dt.Rows[i]["MaMonAn"].ToString());
chiTietThucDon.TenMonAn = dt.Rows[i]["TenMonAn"].ToString();
chiTietThucDon.DonGia = Decimal.Parse(dt.Rows[i]["DonGia"].ToString());
list.Add(chiTietThucDon);
}
}
return(list);
}
public static DataTable GetTables()
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "SP_GETTABLES";
return(DataAccessCode.ExecuteSelectCommand(command));
}
public static ArrayList layDanhSachNguyenLieuTheoMonAn(MonAnDTO monAn)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayDanhSachNguyenLieuTheoMonAn";
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaMonAn";
param.Value = monAn.MaMonAn;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
ArrayList list = new ArrayList();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
MonAn_NguyenLieuDTO dto = new MonAn_NguyenLieuDTO();
dto.NguyenLieu.MaNguyenLieu = Convert.ToInt32(dt.Rows[i]["MaNguyenLieu"]);
dto.NguyenLieu.TenNguyenLieu = dt.Rows[i]["TenNguyenLieu"].ToString();
dto.NguyenLieu.DonViTinh = dt.Rows[i]["DonViTinh"].ToString();
dto.SoLuong = Convert.ToInt32(dt.Rows[i]["SoLuong"]);
list.Add(dto);
}
}
return(list);
}
public static DataTable TTNhanVien()
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayNhanVien";
return(DataAccessCode.ExecuteSelectCommand(command));
}
public static List <KhuVucDTO> LayDanhSachKhuVuc(int maNhaHang)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayDanhSachKhuVuc";
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaNhaHang";
if (maNhaHang == 0)
{
param.Value = DBNull.Value;
}
else
{
param.Value = maNhaHang;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
List <KhuVucDTO> list = new List <KhuVucDTO>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
KhuVucDTO khuVuc = new KhuVucDTO();
khuVuc.MaKhuVuc = Int32.Parse(dt.Rows[i]["MaKhuVuc"].ToString());
khuVuc.TenKhuVuc = dt.Rows[i]["TenKhuVuc"].ToString();
khuVuc.GiaBan = Decimal.Parse(dt.Rows[i]["GiaBan"].ToString());
list.Add(khuVuc);
}
}
return(list);
}
public static ArrayList layDanhSachMonAnTheoPhanLoaiMonAn(LoaiMonAnDTO loaiMonAn, int maNhaHang)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayDanhSachMonAnTheoPhanLoaiMonAn";
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaNhaHang";
param.Value = maNhaHang;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@MaLoaiMonAn";
param.Value = loaiMonAn.MaLoaiMonAn;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
ArrayList list = new ArrayList();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
PhanLoaiMonAnDTO plMA = new PhanLoaiMonAnDTO();
plMA.LoaiMonAn.MaLoaiMonAn = Convert.ToInt32(dt.Rows[i]["MaLoaiMonAn"]);
plMA.MonAn.MaMonAn = Convert.ToInt32(dt.Rows[i]["MaMonAn"]);
plMA.MonAn.TenMonAn = dt.Rows[i]["TenMonAn"].ToString();
plMA.NhaHang.MaNhaHang = maNhaHang;
list.Add(plMA);
}
}
return(list);
}
public static KhoHang_NguyenLieuDTO layChiTietKhoHangNguyenLieu(int maNhaHang, NguyenLieuDTO nguyenLieuCanTim)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.layChiTietKhoHangNguyenLieu";
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaNguyenLieu";
param.Value = nguyenLieuCanTim.MaNguyenLieu;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@MaNhaHang";
param.Value = maNhaHang;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
KhoHang_NguyenLieuDTO dto = new KhoHang_NguyenLieuDTO();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dto.NguyenLieu.MaNguyenLieu = Convert.ToInt32(dt.Rows[i]["MaNguyenLieu"]);
dto.NguyenLieu.TenNguyenLieu = dt.Rows[i]["TenNguyenLieu"].ToString();
dto.NguyenLieu.DonViTinh = dt.Rows[i]["DonViTinh"].ToString();
dto.SoLuongTon = Convert.ToInt32(dt.Rows[i]["SoLuongTon"]);
dto.SucChua = Convert.ToInt32(dt.Rows[i]["SucChua"]);
dto.MucTonToiThieu = Convert.ToInt32(dt.Rows[i]["MucChuaToiThieu"]);
}
}
return(dto);
}
public static ArrayList traCuuNhaCungCapThoaYeuCauNguyenLieuCanDatHang(string sqlFROM)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.traCuuNhaCungCapThoaYeuCauNguyenLieuCanDatHang";
DbParameter param = command.CreateParameter();
param.ParameterName = "@sqlFROM";
param.Value = sqlFROM;
param.DbType = DbType.String;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
ArrayList list = new ArrayList();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaCungCapDTO dto = new NhaCungCapDTO();
dto.MaNhaCungCap = Convert.ToInt32(dt.Rows[i]["MaNhaCungCap"]);
dto.SoLuongNguyenLieuToiDaPhuHopYeuCauDatHang = Convert.ToInt32(dt.Rows[i]["SoLuongNguyenLieuDapUng"]);
dto.TenNhaCungCap = dt.Rows[i]["TenNhaCungCap"].ToString();
list.Add(dto);
}
}
return(list);
}
//DIRTY READ SOLVED
public static int dirtyReadSolvedSetNgungGiaoDich(int maNhaCungCap, int maNhaHang, int tinhTrang)
{
DbCommand command = DataAccessCode.CreateCommand();
//command.CommandText = "dbo.setNgungGiaoDich";
command.CommandText = "dbo.DirtyReadSolvedT2SetNgungGiaoDich";
//// create a new parameter
DbParameter param = command.CreateParameter();
param.ParameterName = "@maNhaCungCap";
param.Value = maNhaCungCap;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@maNhaHang";
param.Value = maNhaHang;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@tinhTrang";
param.Value = tinhTrang;
param.DbType = DbType.Int16;
command.Parameters.Add(param);
//create a new parameter
param = command.CreateParameter();
param.ParameterName = "@isRollback";
param.Direction = ParameterDirection.Output;
param.Value = 0;
param.DbType = DbType.Int16;
command.Parameters.Add(param);
return(DataAccessCode.ExecuteNonQueryReturnIsRollBackOutputValue(command));
}
public static bool HuyThongTinKhachVaBanDatUnRRead(int maLich)
{
try
{
DbCommand cm = DataAccessCode.CreateCommand();
cm.CommandText = "dbo.CnHuyThongTinKhachBanDatUnRRead";
//
DbParameter pm = cm.CreateParameter();
pm.ParameterName = "@maLichBan";
pm.Value = maLich;
pm.DbType = DbType.Int32;
cm.Parameters.Add(cm);
if (DataAccessCode.ExecuteNonQuery(cm) != -1)
{
MessageBox.Show("Hủy Thành Công");
return(true);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(false);
}
public static DataTable ThongTinKhachVaBanDat()
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.ThongTinKhachVaBanDat";
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
//List<BanDatDTO> list = new List<BanDatDTO>();
//if (dt != null)
//{
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// BanDatDTO bd = new BanDatDTO();
// //bd.MaNhaHang = Int32.Parse(dt.Rows[i]["MaNhaHang"].ToString());
// bd.HoTen = dt.Rows[i]["HoTen"].ToString();
// bd.Cmnd = dt.Rows[i]["CMND"].ToString();
// bd.DienThoai = dt.Rows[i]["DienThoai"].ToString();
// bd.MaBan = Int32.Parse(dt.Rows[i]["MaBan"].ToString());
// bd.NgayDatBan = DateTime.Parse(dt.Rows[i]["NgayDatBan"].ToString());
// bd.MaBuoi = Int32.Parse(dt.Rows[i]["MaBuoi"].ToString());
// bd.SoLuong = Int32.Parse(dt.Rows[i]["SoLuong"].ToString());
// bd.MaThongTinKhachHang = Int32.Parse(dt.Rows[i]["MaThongTinKhachHang"].ToString());
// bd.MaLichBan = Int32.Parse(dt.Rows[i]["MaLichBan"].ToString());
// list.Add(bd);
// }
//}
if (dt == null)
{
dt = new DataTable();
}
return(dt);
}
public static int themThongTinHangNhap(ThongTinHangNhapDTO ttNhap)
{
DbCommand command = DataAccessCode.CreateCommand();
//// create a new parameter
DbParameter param = command.CreateParameter();
command.CommandText = "dbo.themThongTinHangNhap";
param.ParameterName = "@ngayNhap";
param.Value = ttNhap.NgayNhap;
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@maKhoHang";
param.Value = ttNhap.KhoHang.MaKhoHang;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
int kq = DataAccessCode.ExecuteNonQuery(command);
if (kq == 1)
{
for (int i = 0; i < ttNhap.ChiTietHangNhap.Count; i++)
{
((ChiTietHangNhapDTO)ttNhap.ChiTietHangNhap[i]).MaThongTinHangNhap = layMaThongTinHangNhap(ttNhap.NgayNhap, ttNhap.KhoHang.MaKhoHang);
themChiTietHangNhap((ChiTietHangNhapDTO)ttNhap.ChiTietHangNhap[i]);
}
}
return(1);
}
public static List <LoaiNhanVienCNDTO> LayLoaiNhanVien()
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayLoaiNhanVien";
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
List <LoaiNhanVienCNDTO> list = new List <LoaiNhanVienCNDTO>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//LoaiNhanVienDTO loaiNV = new LoaiNhanVienDTO();
int maLoaiNhanVien = Int32.Parse(dt.Rows[i]["MaLoaiNhanVien"].ToString());
string tenLoaiNhanVien = dt.Rows[i]["TenLoaiNhanVien"].ToString();
double luong = Int32.Parse(dt.Rows[i]["Luong"].ToString());
LoaiNhanVienCNDTO loaiNV = new LoaiNhanVienCNDTO(maLoaiNhanVien, tenLoaiNhanVien, luong);
list.Add(loaiNV);
//NhaHangDTO nhaHang = new NhaHangDTO(maNhaHang, tenNhaHang, diaChi, dienThoai);
//list.Add(nhaHang);
}
}
return(list);
}
public static List <BanDatDTO> LayDanhSachBanDat()
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.LayDanhSachBanDat";
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
List <BanDatDTO> list = new List <BanDatDTO>();
if (dt != null)
{
int maThongTinKhachHang;
for (int i = 0; i < dt.Rows.Count; i++)
{
BanDatDTO banDat = new BanDatDTO();
banDat.MaLichBan = Int32.Parse(dt.Rows[i]["MaLichBan"].ToString());
banDat.MaBan = Int32.Parse(dt.Rows[i]["MaBan"].ToString());
banDat.NgayDatBan = DateTime.Parse(dt.Rows[i]["NgayDatBan"].ToString());
banDat.MaBuoi = Int32.Parse(dt.Rows[i]["MaBuoi"].ToString());
if (Int32.TryParse(dt.Rows[i]["MaThongTinKhachHang"].ToString(), out maThongTinKhachHang))
{
banDat.MaThongTinKhachHang = maThongTinKhachHang;
}
banDat.SoLuong = Int32.Parse(dt.Rows[i]["SoLuong"].ToString());
banDat.TinhTrangBan = Boolean.Parse(dt.Rows[i]["TinhTrangBan"].ToString());
list.Add(banDat);
}
}
return(list);
}
public static void XoaMonAn(string maChiTietHoaDon, bool isDirtyRead, bool isUnrepeatableRead)
{
DbCommand command = DataAccessCode.CreateCommand();
if (isDirtyRead)
{
command.CommandText = "dbo.XoaMonAnDirtyRead";
}
else if (isUnrepeatableRead)
{
command.CommandText = "dbo.XoaMonAnUnrepeatableRead";
}
else
{
command.CommandText = "dbo.XoaMonAn";
}
//// create a new parameter
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaChiTietHoaDon";
param.Value = maChiTietHoaDon;
param.DbType = DbType.String;
command.Parameters.Add(param);
DataAccessCode.ExecuteNonQuery(command);
}
public static Guid ThemHoaDon(int maLichBan, DateTime ngayLapHoaDon)
{
Guid maHoaDon = Guid.NewGuid();
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.ThemHoaDon";
//// create a new parameter
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaHoaDon";
param.Value = maHoaDon.ToString();
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@MaLichBan";
param.Value = maLichBan;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@NgayLapHoaDon";
param.Value = ngayLapHoaDon;
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
DataAccessCode.ExecuteNonQuery(command);
return(maHoaDon);
}
private void button1_Click(object sender, EventArgs e)
{
RestaurantConfiguration.command = DataAccessCode.CreateCommand();
if (isDirtyRead)
{
RestaurantConfiguration.command.CommandText = "dbo.T1DirtyRead";
}
else
{
RestaurantConfiguration.command.CommandText = "dbo.T1ResolvedDirtyRead";
}
DataTable dt = DataAccessCode.ExecuteSelectCommand(RestaurantConfiguration.command);
List <ThongTinNhanVienDTO> list = new List <ThongTinNhanVienDTO>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ThongTinNhanVienDTO thongTinNhanVien = new ThongTinNhanVienDTO();
thongTinNhanVien.MaNhanVien = Int32.Parse(dt.Rows[i]["MaNhanVien"].ToString());
//thongTinNhanVien.MaNhaHang = Int32.Parse(dt.Rows[i]["MaNhaHang"].ToString());
list.Add(thongTinNhanVien);
}
}
dgvData.DataSource = list;
}
public static void CapNhatChiTietHoaDon(Guid maHoaDon, int maChiTietThucDon, decimal donGia, int soLuong, bool isPhantom, bool isDirtyRead, bool isLostUpdate)
{
DbCommand command = DataAccessCode.CreateCommand();
DbParameter param;
if (isDirtyRead)
{
command.CommandText = "dbo.CapNhatChiTietHoaDonDirtyRead";
}
else if (isPhantom)
{
command.CommandText = "dbo.CapNhatChiTietHoaDonPhanTom";
}
else if (isLostUpdate)
{
if (GlobalVariables.bLostUpdate)
{
command.CommandText = "dbo.CapNhatChiTietHoaDonLostUpdate";
}
else
{
command.CommandText = "dbo.CapNhatChiTietHoaDonSolveLostUpdate";
param = command.CreateParameter();
param.ParameterName = "@MucCoLap";
param.Value = GlobalVariables.mucCoLap;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
}
}
else
{
command.CommandText = "dbo.CapNhatChiTietHoaDon";
}
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@MaHoaDon";
param.Value = maHoaDon.ToString();
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@MaChiTietThucDon";
param.Value = maChiTietThucDon;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@DonGia";
param.Value = donGia;
param.DbType = DbType.Decimal;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@SoLuong";
param.Value = soLuong;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
DataAccessCode.ExecuteNonQuery(command);
}
private void button2_Click(object sender, EventArgs e)
{
RestaurantConfiguration.command = DataAccessCode.CreateCommand();
RestaurantConfiguration.command.CommandText = "dbo.T2";
//DataAccessCode.ExecuteNonQuery();
//command = DataAccessCode.CreateCommand();
//command.CommandText = "dbo.T2";
//DataAccessCode.ExecuteNonQuery();
}
public static ArrayList timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(string ten, int tinhTrangGiaoDich, int maNhaHang)
{
DbCommand command = DataAccessCode.CreateCommand();
//command.CommandText = "dbo.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung";
//phantom read
//command.CommandText = "dbo.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung";
//dirty
//command.CommandText = "dbo.DirtyReadSolvedT1TimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichNgungGiaoDich";
//unrepeat
command.CommandText = "dbo.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung";
DbParameter param = command.CreateParameter();
param.ParameterName = "@ten";
param.Value = ten;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@tinhTrangGiaoDich";
param.Value = tinhTrangGiaoDich;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@maNhaHang";
param.Value = maNhaHang;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
ArrayList list = new ArrayList();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaCungCapDTO dto = new NhaCungCapDTO();
dto.MaNhaCungCap = Convert.ToInt32(dt.Rows[i]["MaNhaCungCap"]);
dto.TenNhaCungCap = dt.Rows[i]["TenNhaCungCap"].ToString();
dto.DienThoai = dt.Rows[i]["DienThoai"].ToString();
dto.SoTaiKhoan = dt.Rows[i]["SoTaiKhoan"].ToString();
if (dt.Rows[i]["TongNo"].ToString() != "")
{
dto.TongNo = Convert.ToDecimal(dt.Rows[i]["TongNo"]);
}
list.Add(dto);
}
}
return(list);
}
public static bool DoiMatKhau(string userName, string pass)
{
DbCommand command = DataAccessCode.CreateCommand();
string sql = "UPDATE NguoiDung SET MatKhau = '" + pass + "' WHERE TenDangNhap = '" + userName + "' ";
System.Windows.Forms.MessageBox.Show(sql);
if (DataAccessCode.ExecuteQuery(sql, command))
{
return(true);
}
return(false);
}
public static bool ThayDoiTaiKhoan(int maNhanVien, string taiKhoan, string matKhau)
{
DbCommand command = DataAccessCode.CreateCommand();
string sql = string.Format("UPDATE NGUOIDUNG SET('N{0}','N{1}',N'{2}')", maNhanVien, taiKhoan, matKhau);
if (DataAccessCode.ExecuteQuery(sql, command))
{
MessageBox.Show("Thay Đổi Một Tài Khoản Thành Công", "Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
return(false);
}
