public fChuyenBan(TaiKhoanDTO taiKhoanHienTai, BanDTO ban)
{
InitializeComponent();
_taiKhoanHienTai = taiKhoanHienTai;
_ban = ban;
LoadCBXT();
}
//chuyen qua chon mon
private void button1_Click(object sender, EventArgs e)
{
dsBandadatDTO ban = new dsBandadatDTO();
BanDTO banDTO = new BanDTO();
ban.soban = int.Parse(comboBox1.Text);
ban.bookeddate = dateTimePicker1.Value;
banDTO.soban = int.Parse(comboBox1.Text);
//2. Kiểm tra data hợp lệ or not
//3. Thêm vào DB
if (dsbanBUS.checkBookStatus(ban.soban, ban.bookeddate))
{
System.Windows.MessageBox.Show("Đặt bàn thất bại. Bàn đã bị đặt");
return;
}
bool kq = dsbanBUS.Them(ban);
if (kq == false)
{
System.Windows.MessageBox.Show("Đặt bàn thất bại. Vui lòng kiểm tra lại dũ liệu");
}
else
{
System.Windows.MessageBox.Show("Đặt bàn thành công");
LapHoaDon frm = new LapHoaDon(banDTO);
frm.ShowDialog();
}
loadData_Vao_GridView(comboBox1.Text);
}
private void BtInTamTinh_Click(object sender, EventArgs e)
{
try
{
BanDTO ban = dtgvHoaDon.Tag as BanDTO;
string ThanhTien = txbThanhTien.Text;
int idHoaDon = HoaDonDAO.Instance.LayIDHoaDonChuaThanhToanBangIDBan(ban.ID);
string TenDN = TaiKhoanHienTai.TenDangNhap;
string NhanVien = ThongTinTaiKhoanDAO.Instance.GetTenBangTenDN(TenDN);
DateTime?GioVao = HoaDonDAO.Instance.GetGioVaoByID(ban.ID);
string VAT;
if (ckbxGTGT.Checked == true)
{
VAT = txbGTGT.Text;
}
else
{
VAT = "0";
}
string ThanhToan = txbTongThanhToan.Text;
rptInTam rptInTam = new rptInTam(ban.ID);
rptInTam.XuatHoaDon(idHoaDon, ban.TenBan, NhanVien, ThanhTien, GioVao, VAT, ThanhToan);
rptInTam.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnThemBan_Click(object sender, EventArgs e)
{
BanDTO banTam = new BanDTO();
if (txtTenBan.Text == string.Empty)
{
MessageBox.Show("Bạn chưa nhập đầy đủ thông tin!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
banTam.Tenban = txtTenBan.Text;
banTam.Socho = Convert.ToInt32(nmrSoCho.Value);
}
if (banBus.ThemBan(banTam))
{
MessageBox.Show("Thêm thành công!", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDsBan();
AutoCompleteBan();
}
else
{
MessageBox.Show("Thêm thất bại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Ban_Sua(string maBan)
{
InitializeComponent();
ban = BanDAO.Instance.GetBan(maBan);
loadKhuVuc();
fillInput();
}
public BanDTO Constructor02(BanDTO HoaDon)
{
BanDTO target = new BanDTO(HoaDon);
return(target);
// TODO: add assertions to method BanDTOTest.Constructor02(BanDTO)
}
public int SoGheGet([PexAssumeUnderTest] BanDTO target)
{
int result = target.SoGhe;
return(result);
// TODO: add assertions to method BanDTOTest.SoGheGet(BanDTO)
}
public BanDTO Constructor01(int maBan, int soGhe)
{
BanDTO target = new BanDTO(maBan, soGhe);
return(target);
// TODO: add assertions to method BanDTOTest.Constructor01(Int32, Int32)
}
public BanDTO Constructor()
{
BanDTO target = new BanDTO();
return(target);
// TODO: add assertions to method BanDTOTest.Constructor()
}
private void btnSuaBan_Click(object sender, EventArgs e)
{
BanDTO banTam = new BanDTO();
banTam.Soban = Convert.ToInt32(dtgvBan.SelectedCells[0].OwningRow.Cells["colMaBan"].Value.ToString());
if (txtTenBan.Text == string.Empty)
{
MessageBox.Show("Bạn chưa nhập đầy đủ thông tin!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
banTam.Tenban = txtTenBan.Text;
banTam.Socho = Convert.ToInt32(nmrSoCho.Value);
}
if (banBus.SuaBan(banTam))
{
MessageBox.Show("Sửa thành công!", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDsBan();
AutoCompleteBan();
}
else
{
MessageBox.Show("Sửa thất bại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static bool Ban_ThemSuaXoa(BanDTO b, int type)
{
string query = "";
switch (type)
{
case 1:
query = "EXEC Ban_Them '" + b.Ban_id + "',N'" + b.Ban_ten + "',N'" + b.Ban_trangthai + "'," + b.Kv_id + "," + b.Ban_xoa + "";
break;
case 2:
query = "EXEC Ban_Sua '" + b.Ban_id + "',N'" + b.Ban_ten + "',N'" + b.Ban_trangthai + "'," + b.Kv_id + "";
break;
case 3:
query = "EXEC Ban_Xoa '" + b.Ban_id + "'";
break;
}
if (conn.ExcuteQuery(query))
{
return(true);
}
else
{
return(false);
}
}
public Ban_Them(string defaultMaKV)
{
InitializeComponent();
ban = new BanDTO();
ban.KhuVuc = KhuVucDAO.Instance.GetKhuVuc(defaultMaKV);
loadKhuVuc();
fillInput();
}
public void SoGheSet516()
{
BanDTO s0 = new BanDTO(0, 0);
this.SoGheSet(s0, 0);
Assert.IsNotNull((object)s0);
Assert.AreEqual <int>(0, s0.MaBan);
Assert.AreEqual <int>(0, s0.SoGhe);
}
public void Constructor02862()
{
BanDTO banDTO;
BanDTO s0 = new BanDTO(0, 0);
banDTO = this.Constructor02(s0);
Assert.IsNotNull((object)banDTO);
Assert.AreEqual <int>(0, banDTO.MaBan);
Assert.AreEqual <int>(0, banDTO.SoGhe);
}
public void MaBanGet151()
{
int i;
BanDTO s0 = new BanDTO(0, 0);
i = this.MaBanGet(s0);
Assert.AreEqual <int>(0, i);
Assert.IsNotNull((object)s0);
Assert.AreEqual <int>(0, s0.MaBan);
Assert.AreEqual <int>(0, s0.SoGhe);
}
public LapHoaDon(BanDTO ban)
{
dsmaBUS = new DSMonAnBUS();
hdBUS = new hoaDonBUS();
nvBUS = new NhanVienBUS();
banBUS = new BanBUS();
banDTO = ban;
InitializeComponent();
loadDataVaoComboBox();
loadData_Vao_GridView();
}
public int GetIdBanByTen(string tenBan)
{
string query = "SELECT * FROM dbo.Ban WHERE TenBan = N'" + tenBan + "'";
DataTable table = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in table.Rows)
{
BanDTO ban = new BanDTO(item);
return(ban.ID);
}
return(-1);
}
public string GetTrangThaiBanBangIDBan(int idBan)
{
string query = "SELECT * FROM dbo.Ban WHERE id = " + idBan;
DataTable table = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in table.Rows)
{
BanDTO ban = new BanDTO(item);
return(ban.TrangThai);
}
return(string.Empty);
}
public List <BanDTO> LoadDsBan()
{
// Trả về danh sách bàn với các giá trị : Id,Tên bàn, Trạng thái
List <BanDTO> tableList = new List <BanDTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("USP_GetTableList");
foreach (DataRow item in data.Rows)
{
BanDTO table = new BanDTO(item);
tableList.Add(table);
}
return(tableList);
}
public string GetTenBan(string tenBan)
{
// Lấy tên bàn
// VD: SELECT * FROM dbo.Ban WHERE TenBan = N'Bàn 01' => Nếu có trả về "Bàn 1" không có trả về "".
string query = "SELECT * FROM dbo.Ban WHERE TenBan = N'" + tenBan + "'";
DataTable table = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in table.Rows)
{
BanDTO ban = new BanDTO(item);
return(ban.TenBan);
}
return(string.Empty);
}
public static List <BanDTO> LayDSBan()
{
List <BanDTO> _ds = new List <BanDTO>();
string sql = "select * from BanAn";
DataTable dt = SqlDataAccessHelper.ExecuteQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
BanDTO b = new BanDTO();
b.MaBan = int.Parse(dt.Rows[i]["MaSoBan"].ToString());
b.SoGhe = int.Parse(dt.Rows[i]["SoGhe"].ToString());
_ds.Add(b);
}
return(_ds);
}
public bool SuaBan(BanDTO ban)
{
try
{
BAN banDB = db.BANs.SingleOrDefault(p => p.SOBAN == ban.Soban && p.TRANGTHAI != 0);
banDB.SOCHO = ban.Socho;
banDB.TENBAN = ban.Tenban;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public static List <BanDTO> Ban_List()
{
DataTable dt = Ban_Load();
List <BanDTO> listBan = new List <BanDTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
BanDTO ban = new BanDTO();
ban.Ban_id = dt.Rows[i]["ban_id"].ToString();
ban.Ban_ten = dt.Rows[i]["ban_ten"].ToString();
ban.Ban_trangthai = dt.Rows[i]["ban_trangthai"].ToString();
ban.Kv_id = int.Parse(dt.Rows[i]["kv_id"].ToString());
listBan.Add(ban);
}
return(listBan);
}
public static List <BanDTO> Ban_List_KhuVuc(int maKhuVuc)
{
DataTable dt = conn.getTable("EXEC Ban_Load_KhuVuc " + maKhuVuc + "");
List <BanDTO> listBan = new List <BanDTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
BanDTO ban = new BanDTO();
ban.Ban_id = dt.Rows[i]["ban_id"].ToString();
ban.Ban_ten = dt.Rows[i]["ban_ten"].ToString();
ban.Ban_trangthai = dt.Rows[i]["ban_trangthai"].ToString();
ban.Kv_id = int.Parse(dt.Rows[i]["kv_id"].ToString());
listBan.Add(ban);
}
return(listBan);
}
public void LoadDsBan(BanDTO banglobal)
{
flpBan.Controls.Clear();
List <BanDTO> dsBan = banBUS.LoadDsBan();
foreach (BanDTO item in dsBan)
{
Button button = new Button()
{
Width = Instance.ChieuDaiBan, Height = Instance.ChieuRongBan
};
button.Click += button_Click;
button.Tag = item;
button.Image = Image.FromFile(Instance.HinhAnhBan);
button.ImageAlign = ContentAlignment.MiddleLeft;
button.TextAlign = ContentAlignment.MiddleRight;
if (item.Trangthai == 1)
{
button.Text = item.Tenban + Instance.BanTrong;
if (banglobal.Soban != item.Soban)
{
button.BackColor = Color.LightGreen;
}
else
{
button.BackColor = Color.SkyBlue;
}
}
else if (item.Trangthai == 2)
{
button.Text = item.Tenban + Instance.BanKhongTrong;
if (banglobal.Soban != item.Soban)
{
button.BackColor = Color.LightPink;
}
else
{
button.BackColor = Color.SkyBlue;
}
}
flpBan.Controls.Add(button);
}
}
public bool ThanhToan(BanDTO ban, double tongTien, HoaDonTamDTO hdtam, int Manvlap)
{
bool flag;
try
{
//HOA_DON hd = db.HOA_DON.Where(u => u.SOBAN == ban.Soban && u.TRANGTHAI == 0).SingleOrDefault();
//hd.TONGTIEN = tongTien;
//hd.TRANGTHAI = 1;
//db.SaveChanges();
//BAN bandb = db.BANs.Where(u => u.SOBAN == ban.Soban).SingleOrDefault();
//bandb.TRANGTHAI = 1;
//db.SaveChanges();
HOA_DON hd = new HOA_DON
{
SOBAN = hdtam.MaBan,
NGAYLAP = DateTime.Now,
MANVLAP = Manvlap,
TONGTIEN = tongTien
};
db.HOA_DON.Add(hd);
db.SaveChanges();
foreach (ThucUongDTO tu in hdtam.ListTUTam)
{
CHI_TIET_HOA_DON cthd = new CHI_TIET_HOA_DON
{
MAHD = hd.MAHD,
MATU = tu.Matu,
SL = tu.Soluong,
GIABAN = tu.Gia
};
db.CHI_TIET_HOA_DON.Add(cthd);
db.SaveChanges();
}
flag = true;
}
catch (Exception e)
{
flag = false;
}
return(flag);
}
//xoa
private void button2_Click(object sender, EventArgs e)
{
BanDTO ban = new BanDTO();
ban.soban = int.Parse(comboBox1.Text);
bool kq = banBUS.Xoa(ban);
if (kq == false)
{
MessageBox.Show("Xóa bàn thất bại. Vui lòng kiểm tra lại dũ liệu");
}
else
{
MessageBox.Show("Xóa bàn thành công");
Loaddatavaocombo();
}
}
private void datbanToolStripMenuItem_Click(object sender, EventArgs e)
{
BanDTO ban = new BanDTO();
ban.Ban_id = maban;
if (DialogResult.Yes == XtraMessageBox.Show("Bạn có chắc chắn muốn đặt trước bàn" + maban, "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
if (BanBUS.Ban_CapNhatTrangThaiBan(maban, "Đặt trước"))
{
XtraMessageBox.Show("Bàn" + maban + "đã được đặt");
}
else
{
XtraMessageBox.Show("Lỗi không đặt trước được!");
}
Tao_Ban();
}
}
public bool ThemBan(BanDTO ban)
{
try
{
BAN banDB = new BAN()
{
SOCHO = ban.Socho,
TENBAN = ban.Tenban
};
db.BANs.Add(banDB);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool ThemBan(BanDTO ban)
{
try
{
BAN banDB = new BAN()
{
SOCHO = ban.Socho,
TENBAN = ban.Tenban,
TRANGTHAI = Instance.TrangThaiBanTrong
};
db.BANs.Add(banDB);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
