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 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 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 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));
}
//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 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);
}
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 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);
}
internal static void DeleteThongTinNhanVien(int maNhanVien)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.DeleteThongTinNhanVien";
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaNhanVien";
param.Value = maNhanVien;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
DataAccessCode.ExecuteNonQuery(command);
}
internal static int TinhTongNhanVien(int maNhaHang)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.TinhTongNhanVien";
//// create a new parameter
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaNhaHang";
param.Value = maNhaHang;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
return(DataAccessCode.ExecuteNonQuery(command));
}
public static bool CapNhatThongTinKhachBanDatPhanTom(int maLichBan, int maBuoi, DateTime ngay, int soLuong)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.CnCapNhatThongTinBanDatPhanTom";
DbParameter pm = command.CreateParameter();
//
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaLichBan";
param.Value = maLichBan;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//
//param = command.CreateParameter();
//param.ParameterName = "@TinhTrangBan";
//param.Value = t;
//param.DbType = DbType.Boolean;
//command.Parameters.Add(param);
//
param = command.CreateParameter();
param.ParameterName = "@MaBuoi";
param.Value = maBuoi;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//
param = command.CreateParameter();
param.Value = ngay;
param.ParameterName = "@NgayDat";
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
//
param = command.CreateParameter();
param.Value = soLuong;
param.ParameterName = "@SoLuong";
param.DbType = DbType.Int32;
command.Parameters.Add(param);
if (DataAccessCode.ExecuteNonQuery(command) != -1)
{
MessageBox.Show("Cập Nhật Thông Tin Khách - Bàn Đặt Thành Công-Bóng Ma");
return(true);
}
return(false);
}
public static bool CapNhatThongTinBanDatLostUpdate(int maLichBan, int maBuoi, DateTime ngay, int soLuong)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.CnLostUpdate";
//
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaLichBan";
param.Value = maLichBan;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//
param = command.CreateParameter();
param.ParameterName = "@MaBuoi";
param.Value = maBuoi;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//
param = command.CreateParameter();
param.Value = ngay;
param.ParameterName = "@NgayDat";
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
//
param = command.CreateParameter();
param.Value = soLuong;
param.ParameterName = "@SoLuong";
param.DbType = DbType.Int32;
command.Parameters.Add(param);
if (DataAccessCode.ExecuteNonQuery(command) != -1)
{
MessageBox.Show("Thay Đổi Thông Tin Bàn Đặt Thành Công");
return(true);
}
MessageBox.Show("Chưa Được Lưu");
return(false);
}
public static int capNhatChiTietKhoHangNguyenLieuT2(KhoHang_NguyenLieuDTO dto, int maNhaHang)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.lostUpdateUpdateChiTietKhoHangNguyenLieuT2";
//// create a new parameter
DbParameter param = command.CreateParameter();
param.ParameterName = "@soLuongTon";
param.Value = dto.SoLuongTon;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@chuaToiDa";
param.Value = dto.SucChua;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@chuaToiThieu";
param.Value = dto.MucTonToiThieu;
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);
return(DataAccessCode.ExecuteNonQuery(command));
}
public static int themChiTietHangNhap(ChiTietHangNhapDTO chiTiet)
{
DbCommand command = DataAccessCode.CreateCommand();
//// create a new parameter
DbParameter param = command.CreateParameter();
command.CommandText = "dbo.themChiTietHangNhap";
param.ParameterName = "@maNguyenLieu";
param.Value = chiTiet.NguyenLieu.MaNguyenLieu;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@maNhaCungCap";
param.Value = chiTiet.NhaCungCap.MaNhaCungCap;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@donGia";
param.Value = chiTiet.DonGia;
param.DbType = DbType.Decimal;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@soLuong";
param.Value = chiTiet.SoLuong;
param.DbType = DbType.Decimal;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@maThongTinHangNhap";
param.Value = chiTiet.MaThongTinHangNhap;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
return(DataAccessCode.ExecuteNonQuery(command));
}
public static void ThemThongTinKhachVaBanDatPhamTom(BanDatDTO banDat, int loai)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.CnThemThongTinKhachVaBanDatPhanTom";
//// create a new parameter
DbParameter param = command.CreateParameter();
param.ParameterName = "@Loai";
param.Value = loai;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@HoTen";
param.Value = banDat.HoTen;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@CMND";
param.Value = banDat.Cmnd;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@DienThoai";
param.Value = banDat.DienThoai;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@MaBan";
param.Value = banDat.MaBan;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@NgayDatBan";
param.Value = banDat.NgayDatBan;
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@Buoi";
param.Value = banDat.MaBuoi;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@SoLuong";
param.Value = banDat.SoLuong;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@TinhTrangBan";
param.Value = banDat.TinhTrangBan;
param.DbType = DbType.Boolean;
command.Parameters.Add(param);
if (DataAccessCode.ExecuteNonQuery(command) != -1)
{
MessageBox.Show("Thêm Thành Công");
}
}
internal static void EditThongTinNhanVien(ThongTinNhanVienDTO nv, int loaiTruyXuat)
{
DbCommand command = DataAccessCode.CreateCommand();
if (loaiTruyXuat == 1)
{
command.CommandText = "dbo.T58LostUpdateEditThongTinNhanVien";
}
else if (loaiTruyXuat == 2)
{
command.CommandText = "dbo.T58LostUpdateSolvedEditThongTinNhanVien";
}
else if (loaiTruyXuat == 3)
{
command.CommandText = "dbo.T58DirtyReadEditThongTinNhanVien";
}
else if (loaiTruyXuat == 4)
{
command.CommandText = "dbo.T58DirtyReadSolvedEditThongTinNhanVien";
}
else if (loaiTruyXuat == 5 || loaiTruyXuat == 6)
{
command.CommandText = "dbo.T58UnrepeatableEditThongTinNhanVien";
}
else if (loaiTruyXuat == 7 || loaiTruyXuat == 8)
{
command.CommandText = "dbo.T58PhantomEditThongTinNhanVien";
}
else
{
command.CommandText = "dbo.T58EditThongTinNhanVien";
}
DbParameter param = command.CreateParameter();
param.ParameterName = "@MaNhanVien";
param.Value = nv.MaNhanVien;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@MaNhaHang";
if (nv.MaNhaHang == 0)
{
param.Value = 0;
}
else
{
param.Value = nv.MaNhaHang;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@MaLoaiNhanVien";
if (nv.MaLoaiNhanVien == 0)
{
param.Value = 0;
}
else
{
param.Value = nv.MaLoaiNhanVien;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Ho";
if (nv.Ho == null)
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.Ho;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Ten";
param.Value = nv.Ten;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@CMND";
param.Value = nv.CMND;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@DiaChi";
param.Value = nv.DiaChi;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@DienThoai";
param.Value = nv.DienThoai;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@NgayVaoLam";
param.Value = nv.NgayVaoLam;
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@TinhTrang";
if (nv.TinhTrang == "")
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.TinhTrang;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
DataAccessCode.ExecuteNonQuery(command);
}
internal static void AddThongTinNhanVien(ThongTinNhanVienDTO nv)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.T58AddThongTinNhanVien";
//// create a new parameter
DbParameter param = command.CreateParameter();
param = command.CreateParameter();
param.ParameterName = "@MaNhaHang";
if (nv.MaNhaHang == -1)
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.MaNhaHang;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@MaLoaiNhanVien";
if (nv.MaLoaiNhanVien == -1)
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.MaLoaiNhanVien;
}
param.DbType = DbType.Int32;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@Ho";
if (nv.Ho == null)
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.Ho;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@Ten";
param.Value = nv.Ten;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@CMND";
param.Value = nv.CMND;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@DiaChi";
param.Value = nv.DiaChi;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@DienThoai";
param.Value = nv.DienThoai;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@NgayVaoLam";
param.Value = nv.NgayVaoLam;
param.DbType = DbType.DateTime;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@TinhTrang";
if (nv.TinhTrang == "")
{
param.Value = DBNull.Value;
}
else
{
param.Value = nv.TinhTrang;
}
param.DbType = DbType.String;
command.Parameters.Add(param);
DataAccessCode.ExecuteNonQuery(command);
}
