public List<HOATDONG> SelectHOATDONGsAll() { List<HOATDONG> list = new List<HOATDONG>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<HOATDONG_getallResult> lp = db.HOATDONG_getall(); foreach (HOATDONG_getallResult HOATDONG in lp) { HOATDONG var1 = new HOATDONG(); var1.MaHoatDong = HOATDONG.MaHoatDong ; var1.TenHoatDong = HOATDONG.TenHoatDong ; var1.NgayDienRa = HOATDONG.NgayDienRa ; var1.MaLoaiHoatDong = HOATDONG.MaLoaiHoatDong ; var1.ThoiGianBatDauDangKy = HOATDONG.ThoiGianBatDauDangKy ; var1.ThoiGianKetThucDangKy = HOATDONG.ThoiGianKetThucDangKy ; var1.HinhAnh = HOATDONG.HinhAnh; list.Add(var1); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return list; }
public JsonResult InHoaDon(int ban) { int SoHD = TableStatus.Get_HoaDonID_by_TableNumber(ban); if (SoHD == -1) { return(Json(-1, JsonRequestBehavior.AllowGet));//không tìm được hóa đơn } else { var hd = db.HOADONs.Single(n => n.HoaDonID == SoHD); hd.TrangThaiHoaDon = 2; db.HOADONs.Attach(hd); db.Entry(hd).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); NGUOIDUNG thungan = Session[Common.CommonConstants.CASHIER_SESSION_NAME] as NGUOIDUNG; var hoatdong2 = new HOATDONG(); hoatdong2.NoiDung = "In hóa đơn bàn " + hd.SoBan + ""; hoatdong2.ThoiGian = DateTime.Now; hoatdong2.LoaiHoatDong = 1;//nhóm hoạt động của thu ngân hoatdong2.NguoiThucHien = thungan.NguoiDungID; db.HOATDONGs.Add(hoatdong2); db.SaveChanges(); return(Json(1, JsonRequestBehavior.AllowGet)); } }
public JsonResult XoaCong(int id) { NGUOIDUNG thungan = Session[Common.CommonConstants.CASHIER_SESSION_NAME] as NGUOIDUNG; Result res = new Result(); var cong = db.CHAMCONGs.FirstOrDefault(n => n.ChamCongID == id); if (cong != null) { ///Lưu vào nhật ký var hoatdong = new HOATDONG(); hoatdong.NoiDung = thungan.HoTenNV + " đã xóa công " + cong.NGUOIDUNG.HoTenNV; hoatdong.ThoiGian = DateTime.Now; hoatdong.LoaiHoatDong = 1;//nhóm hoạt động của thu ngân hoatdong.NguoiThucHien = thungan.NguoiDungID; db.HOATDONGs.Add(hoatdong); db.SaveChanges(); db.CHAMCONGs.Remove(cong); db.SaveChanges(); res.res = 1; return(Json(res, JsonRequestBehavior.AllowGet)); } res.res = -1;//không tồn tại công return(Json(res, JsonRequestBehavior.AllowGet)); }
public List<HOATDONG> SelectHOATDONGByLoai(int iMaLoaiHoatDong) { List<HOATDONG> KetQua = new List<HOATDONG>(); using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString)) { ISingleResult<HOATDONG_GetByLoaiResult> dsHoatDong = db.HOATDONG_GetByLoai(iMaLoaiHoatDong); foreach (HOATDONG_GetByLoaiResult HOATDONG in dsHoatDong) { HOATDONG aHoatDong = new HOATDONG(); aHoatDong.MaHoatDong = HOATDONG.MaHoatDong; aHoatDong.TenHoatDong = HOATDONG.TenHoatDong; aHoatDong.NgayDienRa = HOATDONG.NgayDienRa; aHoatDong.MaLoaiHoatDong = HOATDONG.MaLoaiHoatDong; aHoatDong.ThoiGianBatDauDangKy = HOATDONG.ThoiGianBatDauDangKy; aHoatDong.ThoiGianKetThucDangKy = HOATDONG.ThoiGianKetThucDangKy; aHoatDong.HinhAnh = HOATDONG.HinhAnh; KetQua.Add(aHoatDong); } try { // Save the changes. db.SubmitChanges(); } // Detect concurrency conflicts. catch (ChangeConflictException) { // Resolve conflicts. db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } } return KetQua; }
public ActionResult ThemNhanVien(HttpPostedFileBase file, NGUOIDUNG nv) { if (ModelState.IsValid) { if (file != null) { if (file.ContentLength > 0) { string filename = Path.GetFileName(file.FileName); /*Saving the file in server folder*/ //Xử lý upload trùng tên var FullPath = Request.MapPath("~/Images/User/" + filename); if (System.IO.File.Exists(FullPath)) { filename = "1_" + filename; } //upload file.SaveAs(Server.MapPath("~/Images/User/" + filename)); nv.AnhDaiDien = filename; } else { nv.AnhDaiDien = "default.jpg"; } } else { nv.AnhDaiDien = "default.jpg"; } nv.LanCuoiDangNhap = DateTime.Now; nv.SoLanDangNhap = 0; nv.NgayVaoLam = DateTime.Now; nv.MatKhau = Common.Encryptor.MD5Hash(nv.MatKhau); nv.TenDangNhap = nv.TenDangNhap.Trim().ToLower(); nv.NgayTao = DateTime.Now; db.NGUOIDUNGs.Add(nv); db.SaveChanges(); var hd = new HOATDONG(); hd.NoiDung = "Thêm nhân viên " + nv.HoTenNV; hd.ThoiGian = DateTime.Now; hd.LoaiHoatDong = 2;//Nhóm hoạt động của quản trị viên db.HOATDONGs.Add(hd); db.SaveChanges(); return(RedirectToAction("DanhSachPhucVu")); } return(View()); }
public int CapNhat(HOATDONG lpDTO) { try { LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString); return db.HOATDONG_update( lpDTO.MaHoatDong, lpDTO.TenHoatDong, lpDTO.NgayDienRa, lpDTO.MaLoaiHoatDong , lpDTO.ThoiGianBatDauDangKy , lpDTO.ThoiGianKetThucDangKy , lpDTO.HinhAnh ); } catch (Exception ex) { throw (ex); } }
protected void btCapNhat_Click(object sender, EventArgs e) { if (KiemTra() == false) { txtThongTin.Text = "Thời gian không hợp lệ"; return; } HOATDONG hoatdong = new HOATDONG(); hoatdong.MaHoatDong = int.Parse(ddlMaHoatDong.SelectedValue); hoatdong.TenHoatDong = txtTenHoatDong.Text; hoatdong.MaLoaiHoatDong = int.Parse(ddlMaHoatDong.SelectedValue); hoatdong.NgayDienRa = new DateTime(int.Parse(txtNgayDienRa.Text.Substring(6, 4)), int.Parse(txtNgayDienRa.Text.Substring(3, 2)), int.Parse(txtNgayDienRa.Text.Substring(0, 2))); hoatdong.ThoiGianBatDauDangKy = new DateTime(int.Parse(txtThoiGianBatDauDK.Text.Substring(6, 4)), int.Parse(txtThoiGianBatDauDK.Text.Substring(3, 2)), int.Parse(txtThoiGianBatDauDK.Text.Substring(0, 2))); hoatdong.ThoiGianKetThucDangKy = new DateTime(int.Parse(txtThoiGianKetThucDK.Text.Substring(6, 4)), int.Parse(txtThoiGianKetThucDK.Text.Substring(3, 2)), int.Parse(txtThoiGianKetThucDK.Text.Substring(0, 2))); BUSHoatDong bushoatdong = new BUSHoatDong(); bushoatdong.CapNhat(hoatdong); }
public ActionResult Order(FormCollection form) { NGUOIDUNG thungan = Session[Common.CommonConstants.CASHIER_SESSION_NAME] as NGUOIDUNG; int soBan; int.TryParse(form["ip_SoBan"].ToString(), out soBan); string MH = form["ip_mon"].ToString(); int SoLuong; int.TryParse(form["ip_sl"].ToString(), out SoLuong); string NhanVien = form["ip_manv"].ToString(); string GhiChu = form["ip_ghi_chu"].ToString(); ////Validate data input int flag = 0;//Không lỗi if (SoLuong <= 0) { flag = -1; //Lỗi số lượng } MATHANG mon = db.MATHANGs.FirstOrDefault(n => n.TenMatHang.Equals(MH)); if (mon == null) { flag = -2;//Tên món lỗi } NGUOIDUNG nhanvien = db.NGUOIDUNGs.FirstOrDefault(n => n.HoTenNV.Equals(NhanVien)); if (nhanvien == null) { flag = -3;//Lỗi tên nhân viên } if (flag == 0) { int SoHD = TableStatus.Get_HoaDonID_by_TableNumber(soBan); if (SoHD != -1)//Đã có hóa đơn { CTHD order = new CTHD(); MATHANG mh = db.MATHANGs.SingleOrDefault(n => n.TenMatHang == MH); NGUOIDUNG nv = db.NGUOIDUNGs.SingleOrDefault(n => n.HoTenNV == NhanVien); //Order món //Lưu vào CSDL order.SoHD = SoHD; order.MatHang = mh.MatHangID; order.NhanVienPhucVu = nv.NguoiDungID; order.GhiChu = GhiChu; order.SoLuong = SoLuong; order.TrangThai = true; db.CTHDs.Add(order); db.SaveChanges(); ///Cập nhật tổng tiền decimal tongtienHD = 0; var hd = db.HOADONs.SingleOrDefault(n => n.HoaDonID == SoHD); var lsCT = db.CTHDs.Where(n => n.SoHD == hd.HoaDonID).ToList(); foreach (var i in lsCT) { tongtienHD += (decimal)(i.MATHANG1.DonGia * i.SoLuong); } hd.TongTien = tongtienHD; db.HOADONs.Attach(hd); var entry = db.Entry(hd); entry.State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else//Chưa có hóa đơn: Bàn đang trống { HOADON hd_new = new HOADON(); hd_new.SoBan = soBan; hd_new.KhachHang = Common.CommonConstants.anonymousUserID; hd_new.ThoiGianVao = DateTime.Now; hd_new.ThoiGianRa = Common.CommonConstants.minDateTime; hd_new.TongTien = 0; hd_new.TrangThai = true; hd_new.TrangThaiHoaDon = 1; hd_new.GiamGia = 0; hd_new.GhiChu = ""; db.HOADONs.Add(hd_new); db.SaveChanges(); //var hoatdong = new HOATDONG(); //hoatdong.NoiDung = "Khách vào bàn " + hd_new.SoBan; //hoatdong.ThoiGian = DateTime.Now; //hoatdong.LoaiHoatDong = 1;//nhóm hoạt động của thu ngân //hoatdong.NguoiThucHien = thungan.NguoiDungID; //db.HOATDONGs.Add(hoatdong); CTHD order = new CTHD(); MATHANG mh = db.MATHANGs.SingleOrDefault(n => n.TenMatHang == MH); NGUOIDUNG nv = db.NGUOIDUNGs.SingleOrDefault(n => n.HoTenNV == NhanVien); order.SoHD = hd_new.HoaDonID; order.MatHang = mh.MatHangID; order.NhanVienPhucVu = nv.NguoiDungID; order.GhiChu = GhiChu; order.SoLuong = SoLuong; order.TrangThai = true; db.CTHDs.Add(order); db.SaveChanges(); var hoatdong2 = new HOATDONG(); hoatdong2.NoiDung = "Thêm khách vào bàn " + hd_new.SoBan; hoatdong2.ThoiGian = DateTime.Now; hoatdong2.LoaiHoatDong = 1;//nhóm hoạt động của thu ngân hoatdong2.NguoiThucHien = thungan.NguoiDungID; db.HOATDONGs.Add(hoatdong2); ///Cập nhật tổng tiền decimal tongtienHD = 0; var lsCT = db.CTHDs.Where(n => n.SoHD == hd_new.HoaDonID).ToList(); foreach (var i in lsCT) { tongtienHD += (decimal)(i.MATHANG1.DonGia * i.SoLuong); } hd_new.TongTien = tongtienHD; db.HOADONs.Attach(hd_new); var entry = db.Entry(hd_new); entry.State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } ViewBag.Ban = soBan; return(Redirect("/Cashier/TongQuan/?ban=" + soBan.ToString())); }
public JsonResult ThemCongMoi(string tenNhanVien, string TenCaLam, string DiMuon = "", string GhiChu = "") { NGUOIDUNG thungan = Session[Common.CommonConstants.CASHIER_SESSION_NAME] as NGUOIDUNG; Result res = new Result(); var nhanvien = db.NGUOIDUNGs.FirstOrDefault(n => n.HoTenNV.Equals(tenNhanVien) && n.TrangThai == true); if (nhanvien == null) { res.res = -1; return(Json(res, JsonRequestBehavior.AllowGet)); } var calam = db.CALAMVIECs.FirstOrDefault(c => (c.TenCa.Equals(TenCaLam))); if (calam == null) { res.res = -2; return(Json(res, JsonRequestBehavior.AllowGet)); } var cong = new CHAMCONG(); cong.NhanVienID = nhanvien.NguoiDungID; cong.CaLam = calam.CaLamID; cong.TrangThai = true; cong.Ngay = DateTime.Now; cong.GhiChu = GhiChu; cong.NgayCham = DateTime.Now; QUYDINHDIMUON dimuon; if (DiMuon != null && !DiMuon.Equals("")) { dimuon = db.QUYDINHDIMUONs.FirstOrDefault(c => c.GhiChu.Equals(DiMuon)); if (dimuon != null) { cong.DiMuon = dimuon.QuyDinhDiMuonID; } else { res.res = -3;//Đi muộn lỗi return(Json(res, JsonRequestBehavior.AllowGet)); } } db.CHAMCONGs.Add(cong); db.SaveChanges(); ///Lưu vào nhật ký var hoatdong = new HOATDONG(); hoatdong.NoiDung = "Chấm công " + nhanvien.HoTenNV; hoatdong.ThoiGian = DateTime.Now; hoatdong.LoaiHoatDong = 1;//nhóm hoạt động của thu ngân hoatdong.NguoiThucHien = thungan.NguoiDungID; db.HOATDONGs.Add(hoatdong); db.SaveChanges(); res.res = cong.ChamCongID; return(Json(res, JsonRequestBehavior.AllowGet)); }
public int Them(HOATDONG lpDTO) { DAOHoatDong HOATDONG = new DAOHoatDong(); return HOATDONG.Them(lpDTO); }
public int CapNhat(HOATDONG lpDTO) { DAOHoatDong HOATDONG = new DAOHoatDong(); return HOATDONG.CapNhat(lpDTO); }
protected void btnCapNhat_Click(object sender, EventArgs e) { if (KiemTra() == false) { return; } try { //lay thong tin tu textbox HOATDONG lpDTO = new HOATDONG(); lpDTO.MaHoatDong = int.Parse(Request.QueryString["id"]); lpDTO.TenHoatDong = txttenhoatdong.Text; lpDTO.MaLoaiHoatDong = int.Parse(ddlLoaiHoatDong.SelectedValue); // IFormatProvider culture = new CultureInfo("vi-VN", true); lpDTO.NgayDienRa = DateTime.Parse(txtngaydienra.Text, culture); lpDTO.ThoiGianBatDauDangKy = DateTime.Parse(txtthoigianbatdaudangky.Text, culture); lpDTO.ThoiGianKetThucDangKy = DateTime.Parse(txtthoigianketthucdangky.Text, culture); if (image.ImageUrl == link) { lpDTO.HinhAnh = link.Substring(defaultLink.Length); } else { if (image.ImageUrl != "") { lpDTO.HinhAnh = RenameHinhAnh(image.ImageUrl, lpDTO.TenHoatDong).Substring(defaultLink.Length); } } //Goi ham cap nhat BUSHoatDong BUSHoatDong = new BUSHoatDong(); if (BUSHoatDong.CapNhat(lpDTO) == 0) { //Thong bao lbThongBao.Text = "Cập Nhật Thành Công"; lbThongBao.Visible = true; link = ""; linkTemp = ""; Response.Redirect("~/administration/HoatDong.aspx?id=" + Request.QueryString["id"]); } else { lbThongBao.Text = "Cập Nhật Không Thành Công"; lbThongBao.Visible = true; } } catch { lbThongBao.Text = "Cập nhật Không Thành Công"; lbThongBao.Visible = true; } DeleteHinhAnh(linkTemp); link = ""; linkTemp = ""; }