public static bool Delete(HoaDon data, User user)
{
try
{
if (data != null)
{
HoaDon objDb = GetById(data.Id);
if (objDb != null)
{
objDb.DeleteFlag = true;
dbContext.SubmitChanges();
return true;
}
}
}
catch
{
}
CreateSQlConnection();
return false;
}
public List<HoaDon> getHoaDonList()
{
DataTable tb = db.LoadData("HOADON_proc_load");
List<DTO.HoaDon> list = new List<HoaDon>();
foreach (DataRow row in tb.Rows)
{
HoaDon hd = new HoaDon();
hd.MaHoaDon = row["MaHoaDon"].ToString();
Ban bansd = new Ban();
bansd.maBan = row["MaBan"].ToString();
bansd.tenBan = row["TenBan"].ToString();
Ban bantt = new Ban();
bantt.maBan = row["MaBanThanhToan"].ToString();
bantt.tenBan = row["TenBan"].ToString();
hd.BanSuDung = bansd;
hd.BanThanhToan = bantt;
hd.TongTien = decimal.Parse(row["TongTien"].ToString());
hd.ThoiGian = DateTime.Parse(row["ThoiGian"].ToString());
hd.DaThanhToan = bool.Parse(row["DaThanhToan"].ToString());
list.Add(hd);
}
return list;
}
public List<HoaDon> getHoaDonList_With_Date(DateTime thoiGian)
{
List<HoaDon> list = new List<HoaDon>();
HoaDonDAO _hoaDonDAO = new HoaDonDAO();
DataTable tb = _hoaDonDAO.findHoaDon_With_Date(thoiGian);
foreach(DataRow row in tb.Rows)
{
HoaDon hoaDon = new HoaDon();
hoaDon.MaHoaDon = row["MaHoaDon"].ToString();
hoaDon.BanSuDung = new Ban()
{
tenBan=row["TenBan"].ToString()
};
hoaDon.BanThanhToan = new Ban()
{
tenBan = row["TenBan"].ToString()
};
hoaDon.ThoiGian = DateTime.Parse(row["ThoiGian"].ToString());
hoaDon.TongTien = decimal.Parse(row["TongTien"].ToString());
list.Add(hoaDon);
}
return list;
}
public UcInfo()
{
InitializeComponent();
dataHoaDon = new HoaDon();
dataHoaDonDetail = new HoaDonDetail();
dataSP = new DTO.SanPham();
dataChietKhau = new ChietKhau();
isUpdate = false;
if (InitSP() && Init())
{
RefreshDataSP();
RefreshData();
CreateNewId();
pbAvatar.Image = Image.FromFile(ConstantResource.SANPHAM_DEFAULT_SP);
}
else
{
this.Visible = false;
}
}
public List<CTHoaDon> loadCTHoaDon_with_MaHoaDon(string mahoadon)
{
int param = 1;
string[] names = new string[param];
Object[] values = new Object[param];
names[0] = "@maHoaDon";
values[0] = mahoadon;
DataTable dt = db.LoadData("CTHOADON_proc_load_with_MaHoaDon", names, values, param);
List<CTHoaDon> list = new List<CTHoaDon>();
foreach (DataRow row in dt.Rows)
{
CTHoaDon cthd = new CTHoaDon();
MonAn ma = new MonAn();
HoaDon hd = new HoaDon();
ma.MaMonAn = row["MaMonAn"].ToString();
ma.TenMonAn = row["TenMonAn"].ToString();
ma.DonGia = decimal.Parse(row["DonGia"].ToString());
cthd.MonAn = ma;
cthd.MaCTHoaDon = row["MaCTHoaDon"].ToString();
hd.MaHoaDon = row["MaHoaDon"].ToString();
cthd.HoaDon = hd;
cthd.SoLuong = int.Parse(row["SoLuong"].ToString());
cthd.DaChuanBi = bool.Parse(row["DaChuanBi"].ToString());
cthd.GhiChu = row["GhiChu"].ToString();
list.Add(cthd);
}
return list;
}
public HoaDon getHoaDon_with_BanSuDung(string maBan)
{
int param = 1;
string[] names = new string[param];
Object[] values = new Object[param];
names[0] = "@maBan";
values[0] = maBan;
DataTable tb = db.LoadData("[HOADON_proc_get_with_BanSuDung]", names, values, param);
HoaDon hd = new HoaDon();
foreach(DataRow row in tb.Rows)
{
hd.MaHoaDon = row["MaHoaDon"].ToString();
Ban bansd = new Ban();
bansd.maBan = row["MaBan"].ToString();
Ban bantt = new Ban();
bantt.maBan = row["MaBanThanhToan"].ToString();
hd.BanSuDung = bansd;
hd.BanThanhToan = bantt;
hd.TongTien = decimal.Parse(row["TongTien"].ToString());
hd.ThoiGian = DateTime.Parse(row["ThoiGian"].ToString());
hd.DaThanhToan = bool.Parse(row["DaThanhToan"].ToString());
}
return hd;
}
public UcInfo()
{
InitializeComponent();
dataHoaDon = new DTO.HoaDon();
isUpdate = false;
InitThu();
}
public UcInfo()
{
InitializeComponent();
data = new DTO.HoaDon();
isUpdate = false;
Init();
RefreshData();
}
public UcDetail(DTO.HoaDon data)
{
InitializeComponent();
Init();
LoadData(data);
this.dataHD = data;
}
public static int insertHoaDon(HoaDon m)
{
try
{
return bhD.insertHoaDon(m);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi thêm hóa đơn");
}
return -1;
}
public UcInfo(DTO.HoaDon data)
{
InitializeComponent();
this.data = data;
isUpdate = true;
lbSelect.Text = Constant.DEFAULT_TITLE_EDIT;
Init();
tbMa.Text = data.MaHoaDon;
tbTien.Text = data.ThanhTien.ToString(Constant.DEFAULT_FORMAT_MONEY);
cbMaKH.Text = data.KhachHang == null ? string.Empty : data.KhachHang.MaKhachHang;
tbGhiChu.Text = data.GhiChu;
cbMaKH.Enabled = false;
}
public UcInfo(DTO.HoaDon data)
{
InitializeComponent();
dataHoaDon = data;
isUpdate = true;
lbSelect.Text = Constant.DEFAULT_TITLE_EDIT;
if (data.IdType == Constant.ID_TYPE_THU)
{
InitThu();
}
if (data.IdType == Constant.ID_TYPE_BAN)
{
InitTraSP();
}
}
public UcInfo(DTO.HoaDon data)
{
InitializeComponent();
dataHoaDon = data;
if (Init())
{
RefreshData();
AddToBill(data.Id);
tbMaHD.Text = data.Id.ToString();
tbGhiChu.Text = data.GhiChu;
dtpFilter.Value = data.Date;
lbNgayGio.Text = dtpFilter.Value.ToString(Constant.DEFAULT_DATE_TIME_FORMAT);
}
else
{
this.Visible = false;
}
}
public int updateHoaDon(HoaDon hd)
{
int param = 6;
string[] names = new string[param];
Object[] values = new Object[param];
names[0] = "@maHoaDon";
names[1] = "@maBan";
names[2] = "@maBanThanhToan";
names[3] = "@thoiGian";
names[4] = "@tongTien";
names[5] = "@daThanhToan";
values[0] = hd.MaHoaDon;
values[1] = hd.BanSuDung.maBan;
values[2] = hd.BanThanhToan.maBan;
values[3] = hd.ThoiGian;
values[4] = hd.TongTien;
values[5] = hd.DaThanhToan;
return db.Update("HOADON_proc_update", names, values, param);
}
public static bool Update(HoaDon data, User user)
{
try
{
if (data != null)
{
dbContext.SubmitChanges();
return true;
}
return false;
}
catch
{
return false;
}
}
public static bool Insert(HoaDon data, User user)
{
try
{
dbContext.HoaDons.InsertOnSubmit(data);
dbContext.SubmitChanges();
return true;
}
catch
{
return false;
}
}
private void InsertDataHoaDon()
{
dataHoaDon = new HoaDon();
dataHoaDon.MaHoaDon = tbMaHD.Text;
dataHoaDon.IdUser = FormMain.user.Id;
dataHoaDon.IdKhachHang = dataKH.Id;
dataHoaDon.IdType = Constant.ID_TYPE_BAN;
dataHoaDon.IdStatus = ConvertUtil.ConvertToInt(((CommonComboBoxItems)cbStatus.SelectedItem).Value);
dataHoaDon.IsCKTichLuy = rbTichLuy.Checked;
dataHoaDon.IsCKTongHD = chbCKTongHD.Checked;
if (dataHoaDon.IsCKTongHD)
{
dataHoaDon.TienChietKhau = ConvertUtil.ConvertToInt(tbTongCK.Text.Replace(Constant.SYMBOL_LINK_MONEY, string.Empty));
}
dataHoaDon.SuDung = ConvertUtil.ConvertToInt(tbTienSuDung.Text.Replace(Constant.SYMBOL_LINK_MONEY, string.Empty));
if (dataHoaDon.IdStatus == Constant.ID_STATUS_DEBT)
{
dataHoaDon.ConLai = ConvertUtil.ConvertToLong(tbTienHoiLai.Text.Replace(Constant.SYMBOL_LINK_MONEY, string.Empty));
}
dataHoaDon.ThanhTien = ConvertUtil.ConvertToInt(tbTongHoaDon.Text.Replace(Constant.SYMBOL_LINK_MONEY, string.Empty));
dataHoaDon.GhiChu = tbGhiChu.Text;
if (HoaDonBus.Insert(dataHoaDon, FormMain.user))
{
InsertDataHoaDonDetail(dataHoaDon.Id);
}
else
{
try
{
HoaDonBus.Delete(dataHoaDon, FormMain.user);
}
catch
{
//
}
MessageBox.Show(Constant.MESSAGE_INSERT_ERROR + Constant.MESSAGE_NEW_LINE + Constant.MESSAGE_EXIT, Constant.CAPTION_ERROR, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
}
}
partial void UpdateHoaDon(HoaDon instance);
partial void InsertHoaDon(HoaDon instance);
private void detach_HoaDons(HoaDon entity)
{
this.SendPropertyChanging();
entity.User = null;
}
private void attach_HoaDons(HoaDon entity)
{
this.SendPropertyChanging();
entity.User = this;
}
void listview_SelectedIndexChanged(object sender, EventArgs e)
{
ListViewEx listView = sender as ListViewEx;
if (listView.SelectedItems.Count > 0)
{
/// chọn currentBan, currentHD của mỗi bàn, bàn còn trống thì enable Mở bàn btn.
/// chuyển các trạng thái
currentItem = listView.SelectedItems[0];
//lblTenBan.Text = currentItem.Text;
//lblTrangThai.Text = currentItem.Tag.ToString();
// currentBan = banBUS.getBan_theo_maBan(currentItem.Name);
currentBan = Global.getBanByMaBan(currentItem.Name);
lblTenBan.Text = currentBan.tenBan;
switch (currentBan.tinhTrang)
{
case 0:
lblTrangThai.Text = bantrong;
dgvMonDaGoi.DataSource = null;
dgvMonDaGoi.Update();
lblThanhTien.Text = "0";
lblGioDen.Text = "";
lblBanThanhToan.Text = "";
btnMoBan.Enabled = true;
btnDatBan.Enabled = true;
btnHuyBan.Enabled = false;
btnGoiMon.Enabled = false;
btnHuyMon.Enabled = false;
btnChuanBi.Enabled = false;
btnThanhToan.Enabled = false;
btnChuyenBan.Enabled = false;
btnGopBan.Enabled = false;
btnTachBan.Enabled = false;
break;
case 1:
lblTrangThai.Text = bandadat;
btnTachBan.Enabled = false;
break;
case 2:
lblTrangThai.Text = bancokhach;
currentHD = hoaDonBus.getHoaDon_with_BanSuDung(currentBan.maBan);
if (currentHD.MaHoaDon != null)
{
currentHD.BanSuDung = currentBan;
currentListCTHD = ctHoaDonBus.loadCTHoaDon_with_MaHoaDon(currentHD.MaHoaDon);
parseDataDgvMonDaGoi(currentListCTHD);
lblThanhTien.Text = currentHD.TongTien.ToString("#,###");
lblGioDen.Text = currentHD.ThoiGian.ToShortTimeString();
lblBanThanhToan.Text = currentHD.BanThanhToan.tenBan;
}
btnDatBan.Enabled = false;
btnMoBan.Enabled = false;
btnGoiMon.Enabled = true;
btnHuyBan.Enabled = true;
btnGopBan.Enabled = true;
btnChuyenBan.Enabled = true;
btnTachBan.Enabled = true;
break;
case 3:
lblTrangThai.Text = bandathanhtoan;
lblGioDen.Text = "";
lblThanhTien.Text = "0";
dgvMonDaGoi.DataSource = null;
dgvMonDaGoi.Update();
btnMoBan.Enabled = false;
btnHuyBan.Enabled = true;
btnGoiMon.Enabled = false;
btnGopBan.Enabled = false;
btnChuyenBan.Enabled = false;
btnTachBan.Enabled = false;
break;
}
}
}
public int insertHoaDon(HoaDon hd)
{
return hoaDonDAO.insertHoaDon(hd);
}
public int updateHoaDon(HoaDon hd)
{
return hoaDonDAO.updateHoaDon(hd);
}
public static bool Delete(HoaDon data, User user)
{
return HoaDonDao.Delete(data, user);
}
/// <summary>
/// Deprecated Method for adding a new object to the HoaDons EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToHoaDons(HoaDon hoaDon)
{
base.AddObject("HoaDons", hoaDon);
}
public static bool Insert(HoaDon data, User user)
{
return HoaDonDao.Insert(data, user);
}
public List<HoaDon> search_with_MaHoaDon(string ma)
{
int param = 1;
string[] names = new string[param];
object[] values = new object[param];
names[0] = "@maHoaDon";
values[0] = ma;
DataTable tb = db.LoadData("HOADON_proc_search_with_MaHoaDon", names, values, param);
List<DTO.HoaDon> list = new List<HoaDon>();
foreach (DataRow row in tb.Rows)
{
HoaDon hd = new HoaDon();
hd.MaHoaDon = row["MaHoaDon"].ToString();
Ban bansd = new Ban();
bansd.maBan = row["MaBan"].ToString();
bansd.tenBan = row["TenBan"].ToString();
Ban bantt = new Ban();
bantt.maBan = row["MaBanThanhToan"].ToString();
bantt.tenBan = row["TenBan"].ToString();
hd.BanSuDung = bansd;
hd.BanThanhToan = bantt;
hd.TongTien = decimal.Parse(row["TongTien"].ToString());
hd.ThoiGian = DateTime.Parse(row["ThoiGian"].ToString());
hd.DaThanhToan = bool.Parse(row["DaThanhToan"].ToString());
list.Add(hd);
}
return list;
}
public static bool Update(HoaDon data, User user)
{
return HoaDonDao.Update(data, user);
}
partial void DeleteHoaDon(HoaDon instance);
private void btnMoBan_Click(object sender, EventArgs e)
{
//lblTrangThai.Text = currentItem.Tag.ToString();
//TODO tạo mới hóa đơn here
moBan();
string mahd = DataBus.getInstance().getMaHoaDonMoi();
currentHD = new DTO.HoaDon();
//Ban bansudung = new Ban();
//bansudung.maBan = currentItem.Name;
//bansudung.tenBan = currentItem.Text;
//bansudung.tinhTrang = 2;
//Ban banThanhToan = new Ban();
//banThanhToan.maBan = currentItem.Name;
//banThanhToan.tenBan = currentItem.Text;
currentHD.MaHoaDon = mahd;
currentHD.BanSuDung = currentBan;
currentHD.BanThanhToan = currentBan;
currentHD.TongTien = 0;
currentHD.ThoiGian = DateTime.Now;
currentHD.DaThanhToan = false;
banBUS.updateTinhTrang(currentBan);
hoaDonBus.insertHoaDon(currentHD);
currentListCTHD = ctHoaDonBus.loadCTHoaDon_with_MaHoaDon(currentHD.MaHoaDon);
lblTrangThai.Text = bancokhach;
lblThanhTien.Text = currentHD.TongTien.ToString("#,###");
lblGioDen.Text = currentHD.ThoiGian.ToShortTimeString();
lblBanThanhToan.Text = currentItem.Text;
btnGoiMon.Enabled = true;
btnHuyBan.Enabled = true;
}
