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; }