public void InitData(PYC pyc, List <D_PYC_ViewModel> data) { using (var db = new RestaurantManagerDataEntities()) { var toDay = DateTime.Now; lblidpyc.Text = pyc.idyc.ToString(); lblFooterDate.Text = string.Format("Ngày {0} tháng {1} năm {2}", toDay.Day, toDay.Month, toDay.Year); ///var details = new PYCBll().GetListD_PYC(pyc.idyc); objectDataSource1.DataSource = data; } }
private void button2_Click(object sender, EventArgs e) { try { using (var db = new RestaurantManagerDataEntities()) { int idpnhap = int.Parse(txtid.Text); var ngaynhap = dtngaynhap.Value; int.TryParse(lueDONGIAO.EditValue.ToString(), out int idgiaohang); int.TryParse(lueStorekeeper.EditValue.ToString(), out int thukho); string thukhoName = lueStorekeeper.Text; string nguoigiao = txtNguoiGiao.Text; string nguoinhap = txtNguoiNhan.Text; if (ngaynhap == null) { XtraMessageBox.Show("Bạn chưa chọn ngày nhập!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (lstD_PNHAP_ViewModel.Count == 0) { XtraMessageBox.Show("Bạn chưa nhập hàng hóa!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (lstD_PNHAP_ViewModel.Count() == 0) { XtraMessageBox.Show("Bạn chưa nhập hàng hóa!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } var model = new PNHAP_ViewModel(); var nameLog = Properties.Settings.Default.NameLog; model.idpnhap = idpnhap; model.idpgiao = idgiaohang; model.ngaynhap = ngaynhap; model.thukho = thukhoName; model.nguoilapphieu = nameLog; model.nguoigiao = nameLog; var res = new PNHAPBll().savePNHAP(model, lstD_PNHAP_ViewModel, Properties.Settings.Default.NameLog); if (res != "success") { XtraMessageBox.Show(res, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } XtraMessageBox.Show("Thêm phiếu giao hàng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public void InitData(DateTime fromday, DateTime today, List <HOADONTT_ViewModel> data) { using (var db = new RestaurantManagerDataEntities()) { var toDay = DateTime.Now; lblfromday.Text = fromday.ToString("dd/MM/yyyy"); lbltoday.Text = today.ToString("dd/MM/yyyy"); lblFooterDate.Text = string.Format("Ngày {0} tháng {1} năm {2}", toDay.Day, toDay.Month, toDay.Year); ///var details = new PYCBll().GetListD_PYC(pyc.idyc); objectDataSource3.DataSource = data; } }
public void InitData(DONMH_ViewModel obj, List <D_DONMH_ViewModel> lstDetail) { using (var db = new RestaurantManagerDataEntities()) { var toDay = DateTime.Now; lbliddonmua.Text = obj.iddonmh.ToString(); lbldiachi.Text = obj.diachi; lbltenncc.Text = obj.tenncc; lblsdt.Text = obj.sdt; lblFooterDate.Text = string.Format("Ngày {0} tháng {1} năm {2}", toDay.Day, toDay.Month, toDay.Year); objectDataSource3.DataSource = lstDetail; } }
public HOADONTT AddHOADONTT(HOADONTT_ViewModel model) { using (var db = new RestaurantManagerDataEntities()) { using (var trans = db.Database.BeginTransaction()) { try { var check = db.HOADONTTs.FirstOrDefault(x => x.idhoadontt == model.idhoadontt); if (check == null) { var HOADONTT = new HOADONTT { iddondat = model.iddondat, ngayhd = model.ngayhd, thoigian = DateTime.Now, thungan = model.CreateBy, idkh = model.idkh, CreateBy = model.CreateBy, CreateDate = DateTime.Now, }; var result = db.HOADONTTs.Add(HOADONTT); db.SaveChanges(); foreach (D_HOADONTT_ViewModel item in model.D_HOADONTT) { var D_HOADONTT = new D_HOADONTT { idhoadontt = HOADONTT.idhoadontt, idmon = item.idmon, slban = item.slban, dongiaban = item.dongiaban, CreateBy = model.CreateBy, CreateDate = DateTime.Now, }; db.D_HOADONTT.Add(D_HOADONTT); } db.SaveChanges(); trans.Commit(); return(result); } } catch { trans.Rollback(); return(null); } return(null); } } }
public void InitData(DONDATDA_ViewModel obj, List <D_DONDATDA_ViewModel> data) { using (var db = new RestaurantManagerDataEntities()) { var toDay = DateTime.Now; lblid.Text = obj.iddondat.ToString(); lblKhachHang.Text = obj.tenkh.ToString(); lblsdt.Text = obj.sdt.ToString(); lblBan.Text = obj.ban.ToString(); lblNgay.Text = obj.ngaydat.Value.ToString("dd/MM/yyyy"); lblFooterDate.Text = string.Format("Ngày {0} tháng {1} năm {2}", toDay.Day, toDay.Month, toDay.Year); objectDataSource2.DataSource = data; } }
public string AddGIAOHANG(GIAOHANG_ViewModel model, List <D_GIAOHANG_ViewModel> lstD_GIAOHANG, string userLogin) { try { using (var db = new RestaurantManagerDataEntities()) { var check = db.GIAOHANGs.FirstOrDefault(x => x.idpgiao == model.idpgiao); if (check == null) { var GIAOHANG = new GIAOHANG { iddonmh = model.iddonmh, idncc = model.idncc, diachi = model.diachi, cuahang = model.cuahang, ngaygiao = model.ngaygiao, nguoigiao = model.nguoigiao, nguoilapphieu = model.nguoilapphieu, nguoinhan = model.nguoinhan, CreateBy = userLogin, CreateDate = DateTime.Now, }; var result = db.GIAOHANGs.Add(GIAOHANG); db.SaveChanges(); foreach (D_GIAOHANG_ViewModel item in lstD_GIAOHANG) { var D_GIAOHANG = new D_GIAOHANG { idpgiao = GIAOHANG.idpgiao, idhang = item.idhang, slgiaohang = item.slgiaohang, slnhanhang = item.slnhanhang, CreateBy = userLogin, CreateDate = DateTime.Now, }; db.D_GIAOHANG.Add(D_GIAOHANG); } db.SaveChanges(); return("success"); } return("Tạo phiếu giao hàng không thành công!"); } } catch (Exception ex) { return(ex.Message); } }
//lấy danh sách đơn chưa thanh toán public List <DONDATDA_ViewModel> GetOuterOrder() { try { using (var db = new RestaurantManagerDataEntities()) { var result = db.Database.SqlQuery <DONDATDA_ViewModel>("EXEC dbo.Proc_GetDonDatDA_OutLeft").ToList(); return(result); } } catch { return(null); } }
//lấy danh sách hóa đơn đặt public List <DONDATDA> GetLisDONDATDA() { try { using (var db = new RestaurantManagerDataEntities()) { var result = db.DONDATDAs.AsNoTracking().ToList(); return(result); } } catch { return(null); } }
public List <KHACHHANG> GetListKHACHHANG() { try { using (var db = new RestaurantManagerDataEntities()) { var result = db.KHACHHANGs.AsNoTracking().OrderBy(x => x.idkh).ToList(); return(result); } } catch { return(null); } }
public void InitData(PNHAP_ViewModel master, List <D_PNHAP_ViewModel> detail) { using (var db = new RestaurantManagerDataEntities()) { var toDay = DateTime.Now; lblidpnhap.Text = master.idpnhap.ToString(); lblidgiaohang.Text = master.idpgiao.ToString(); lblngaynhap.Text = string.Format("{0}/{1}/{2}", master.ngaynhap.Value.Day, master.ngaynhap.Value.Month, master.ngaynhap.Value.Year); lblnguoigiao.Text = master.nguoigiao; lblnguoilap.Text = master.nguoilapphieu; lblthukho.Text = master.thukho; objectDataSource2.DataSource = detail; lblFooterDate.Text = string.Format("Ngày {0} tháng {1} năm {2}", toDay.Day, toDay.Month, toDay.Year); } }
/// <summary> /// lấy id mới đơn mua hàng /// </summary> /// <returns></returns> public string getNewIdDONMH() { try { using (var db = new RestaurantManagerDataEntities()) { var result = db.Database.SqlQuery <DONMH_ViewModel>("EXEC dbo.[Proc_GetNewIdDONMH]").FirstOrDefault(); return((result.iddonmh).ToString()); } } catch (Exception ex) { return(ex.Message); } }
public List <DANHMUC> GetListDANHMUC() { try { using (var db = new RestaurantManagerDataEntities()) { var result = db.DANHMUCs.AsNoTracking().OrderBy(x => x.iddmuc).ToList(); return(result); } } catch { return(null); } }
public List <NLIEU> GetListNLIEU() { try { using (var db = new RestaurantManagerDataEntities()) { var result = db.NLIEUx.AsNoTracking().OrderBy(x => x.idhang).ToList(); return(result); } } catch { return(null); } }
public List <USER> GetListUsers() { try { using (var db = new RestaurantManagerDataEntities()) { var lst = db.USERS.AsNoTracking().ToList(); return(lst); } } catch (Exception ex) { return(null); } }
//lấy danh sách hóa đơn public List <HOADONM> GetLisHOADONM() { try { using (var db = new RestaurantManagerDataEntities()) { var result = db.HOADONMs.AsNoTracking().ToList(); return(result); } } catch { return(null); } }
/// <summary> /// Get danh sachs mon an co cong thuc /// </summary> /// <returns></returns> public List <MONAN_ViewModel> GetListMONAN_OutLeft() { try { using (var db = new RestaurantManagerDataEntities()) { var result = db.Database.SqlQuery <MONAN_ViewModel>("EXEC dbo.Proc_GetMONAN_OutLeft").ToList(); return(result); } } catch (Exception ex) { return(null); } }
public static int getNewId(string table) { try { using (var db = new RestaurantManagerDataEntities()) { var _table = new SqlParameter("@table", table); var result = db.Database.SqlQuery <int>("EXEC dbo.[Proc_GetNewId] @table", _table).FirstOrDefault(); return(result); } } catch { return(1); } }
public List <PYC_ViewModel> GetListPYC() { using (var db = new RestaurantManagerDataEntities()) { var result = db.PYCs.AsNoTracking() .Select(p => new PYC_ViewModel { idyc = p.idyc, ngayyc = p.ngayyc, CreateBy = p.CreateBy, CreateDate = p.CreateDate }) .ToList(); return(result); } }
public List <USER> GetUsersByPosition(string position, string loginCode, ref string outmess) { try { using (var db = new RestaurantManagerDataEntities()) { var lst = db.USERS.AsNoTracking().Where(e => e.ChucVu == position).ToList(); outmess = "success"; return(lst); } } catch (Exception ex) { outmess = ex.Message; return(null); } }
private void btnPrint_Click(object sender, EventArgs e) { // var obj = lstD_PYC.Current as PYC; if (this.idyc > 0) { using (var db = new RestaurantManagerDataEntities()) { var obj = db.PYCs.AsNoTracking().FirstOrDefault(x => x.idyc == this.idyc); var details = new PYCBll().GetListD_PYC(this.idyc); using (frmPrint frm = new frmPrint()) { frm.PrintPYC(obj, details); frm.ShowDialog(); } } } }
public DONMH_ViewModel GetDONMHById(int id) { try { using (var db = new RestaurantManagerDataEntities()) { var master = (from h in db.DONMHs.AsNoTracking() where h.iddonmh == id join k in db.NCCs.AsNoTracking() on h.idncc equals k.idncc select new DONMH_ViewModel { iddonmh = h.iddonmh, ngaydonmh = h.ngaydonmh.Value, idncc = h.idncc, tenncc = k.tenncc, diachi = k.diachi, sdt = k.sdt, CreateBy = h.CreateBy, CreateDate = h.CreateDate } ).FirstOrDefault(); if (master != null) { master.lstDetail = (from p in db.D_DONMH.AsNoTracking() join d in db.NLIEUx.AsNoTracking() on p.idhang equals d.idhang where p.iddonmh == master.iddonmh select new D_DONMH_ViewModel { idhang = p.idhang, iddonmh = p.iddonmh, slmh = p.slmh.Value, dongiamh = p.dongiamh.Value, totalamount = p.slmh.Value * p.dongiamh.Value, tenhang = d.tenhang, CreateDate = p.CreateDate, CreateBy = p.CreateBy }).ToList(); } return(master); } } catch { return(null); } }
public List <HOADONM_ViewModel> GetListFullHOADONM(DateTime FromDate, DateTime ToDate) { try { using (var db = new RestaurantManagerDataEntities()) { var _FromDate = new SqlParameter("@FromDate", FromDate); var _ToDate = new SqlParameter("@ToDate", ToDate); var result = db.Database.SqlQuery <HOADONM_ViewModel>("EXEC dbo.Proc_GetListHOADONM @FromDate,@ToDate", _FromDate, _ToDate).ToList(); return(result); } } catch (Exception ex) { return(null); } }
public void InitData(HOADONM_ViewModel obj, List <D_HOADONM_ViewModel> data) { using (var db = new RestaurantManagerDataEntities()) { var toDay = DateTime.Now; lblid.Text = obj.idhoadonm.ToString(); lblFooterDate.Text = string.Format("Ngày {0} tháng {1} năm {2}", toDay.Day, toDay.Month, toDay.Year); ///var details = new PYCBll().GetListD_PYC(pyc.idyc); lblid.Text = obj.idhoadonm.ToString(); lblNCC.Text = obj.tenncc.ToString(); lblNgayMua.Text = obj.ngaymua.Value.ToString("dd/MM/yyyy"); lblDiaChi.Text = obj.diachi; lblsdt.Text = obj.sdt; objectDataSource4.DataSource = data; } }
/// <summary> /// ds đơn mua /// </summary> /// <returns></returns> public List <DONMH_ViewModel> GetListDONMH() { using (var db = new RestaurantManagerDataEntities()) { var result = (from p in db.DONMHs.AsNoTracking() join d in db.NCCs.AsNoTracking() on p.idncc equals d.idncc select new DONMH_ViewModel { iddonmh = p.iddonmh, ngaydonmh = p.ngaydonmh.Value, idncc = p.idncc.Value, tenncc = d.tenncc, CreateBy = p.CreateBy, CreateDate = p.CreateDate }).ToList(); return(result); } }
public PNHAP_ViewModel GetPNHAPById(int id) { try { using (var db = new RestaurantManagerDataEntities()) { var master = (from h in db.PNHAPs.AsNoTracking() where h.idpnhap == id select new PNHAP_ViewModel { idpnhap = h.idpnhap, idpgiao = h.idpgiao, ngaynhap = h.ngaynhap, nguoigiao = h.nguoigiao, nguoilapphieu = h.nguoilapphieu, thukho = h.thukho, } ).FirstOrDefault(); if (master != null) { master.lstDetail = (from p in db.D_PNHAP.AsNoTracking() join d in db.NLIEUx.AsNoTracking() on p.idhang equals d.idhang where p.idpnhap == master.idpnhap select new D_PNHAP_ViewModel { idhang = p.idhang, idpnhap = p.idpnhap, slnhan = p.slnhan, dongia = d.dongianl, thanhtien = p.slnhan * d.dongianl, slgiao = p.slgiao, tenhang = d.tenhang, CreateDate = p.CreateDate, CreateBy = p.CreateBy }).ToList(); } return(master); } } catch { return(null); } }
/// <summary> /// ds chi tiết phiếu nhập /// </summary> /// <returns></returns> public List <D_PNHAP_ViewModel> GetListD_PNHAP_Full(int idpnhap) { try { using (var db = new RestaurantManagerDataEntities()) { var _idpnhap = new SqlParameter("@idpnhap", idpnhap); var result = db.Database.SqlQuery <D_PNHAP_ViewModel>("EXEC dbo.Proc_GetListD_PNHAP @idpnhap", _idpnhap).ToList(); return(result); } } catch (Exception ex) { return(null); } // return result; //} }
public List <DONDATDA_ViewModel> GetListDONDATDA(int iddondat, DateTime FromDate, DateTime ToDate) { try { using (var db = new RestaurantManagerDataEntities()) { var _iddondat = new SqlParameter("@iddondat", iddondat); var _FromDate = new SqlParameter("@FromDate", FromDate); var _ToDate = new SqlParameter("@ToDate", ToDate); var result = db.Database.SqlQuery <DONDATDA_ViewModel>("EXEC dbo.Proc_GetListDONDATDA @iddondat,@FromDate,@ToDate", _iddondat, _FromDate, _ToDate).ToList(); return(result); } } catch (Exception ex) { return(null); } }
public string AddMONAN(MONAN_ViewModel model) { try { using (var db = new RestaurantManagerDataEntities()) { var check = db.MONANs.FirstOrDefault(x => x.idmon == model.idmon); if (check == null) { var MONAN = new MONAN { temon = model.temon, dongiamon = model.dongiamon, dvt = model.dvt, hinhanh = model.hinhanh, iddmuc = model.iddmuc, CreateBy = model.CreateBy, CreateDate = DateTime.Now, }; var result = db.MONANs.Add(MONAN); db.SaveChanges(); return("Thêm món ăn thành công!"); } else { check.temon = model.temon; check.dongiamon = model.dongiamon; check.dvt = model.dvt; check.hinhanh = model.hinhanh; check.iddmuc = model.iddmuc; check.ModifyBy = model.ModifyBy; check.ModifyDate = DateTime.Now; db.SaveChanges(); return("Cập nhật món ăn thành công!"); } } } catch (Exception ex) { return(ex.Message); } }
public USER Login(string username, string password, ref string outmess) { try { using (var db = new RestaurantManagerDataEntities()) { var result = db.USERS.AsNoTracking().FirstOrDefault(x => x.UserName == username && x.Password == password); if (result == null) { return(null); } return(result); } } catch (Exception ex) { outmess = ex.Message; return(null); } }