protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; var dichVuList = new List<PhieuDichVuDichVu>(); var listThuChi = new List<ThuChi>(); using (var con = DAL.con()) { if (string.IsNullOrEmpty(id)) { Item = PhieuDichVuDal.SelectDraff(con); Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1; Item.ID = Guid.NewGuid(); } else { Item = PhieuDichVuDal.SelectById(con, new Guid(id)); dichVuList = PhieuDichVuDichVuDal.SelectByPdvId(con, id); listThuChi = ThuChiDal.SelectByPdvId(con, Item.ID); } Add.ListDichVu = dichVuList; Add.Item = Item; ; Add.ListThuChi = listThuChi; Add.ListUrl = "/lib/pages/PhieuDichVu/List-Kt.aspx"; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; var dichVuList=new List<PhieuDichVuDichVu>(); var listDuyetAnh = new List<DuyetAnh>(); var listBaiHat = new List<BaiHat>(); var listThuChi = new List<ThuChi>(); using (var con = DAL.con()) { if (string.IsNullOrEmpty(id)) { Item = PhieuDichVuDal.SelectDraff(con); Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1; Item.ID = Guid.NewGuid(); Item.TuVanVien = Security.UserId; Item.TuVanVien_Ten = Security.Ten; } else { Item = PhieuDichVuDal.SelectById(con, new Guid(id)); dichVuList = PhieuDichVuDichVuDal.SelectByPdvId(con, id); listDuyetAnh = DuyetAnhDal.SelectByPdvId(con, id); listBaiHat = BaiHatDal.SelectByPdvId(con, id); listThuChi = ThuChiDal.SelectByPdvId(con, Item.ID); } Add.ListDichVu = dichVuList; Add.Item = Item; ; Add.ListDuyetAnh = listDuyetAnh; Add.ListBaiHat = listBaiHat; Add.ListThuChi = listThuChi; Add.ListUrl = "/lib/pages/PhieuDichVu/Default.aspx"; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; var listDuyetAnh = new List<DuyetAnh>(); var listBaiHat = new List<BaiHat>(); using (var con = DAL.con()) { if (string.IsNullOrEmpty(id)) { Item = PhieuDichVuDal.SelectDraff(con); Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1; Item.ID = Guid.NewGuid(); } else { Item = PhieuDichVuDal.SelectById(con, new Guid(id)); listDuyetAnh = DuyetAnhDal.SelectByPdvId(con, id); listBaiHat = BaiHatDal.SelectByPdvId(con, id); var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description; Add.LogoStr = logoStr; } Add.ListDuyetAnh = listDuyetAnh; Add.ListBaiHat = listBaiHat; Add.Item = Item; ; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; var listDuyetAnh = new List <DuyetAnh>(); var listBaiHat = new List <BaiHat>(); using (var con = DAL.con()) { if (string.IsNullOrEmpty(id)) { Item = PhieuDichVuDal.SelectDraff(con); Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1; Item.ID = Guid.NewGuid(); } else { Item = PhieuDichVuDal.SelectById(con, new Guid(id)); listDuyetAnh = DuyetAnhDal.SelectByPdvId(con, id); listBaiHat = BaiHatDal.SelectByPdvId(con, id); var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description; Add.LogoStr = logoStr; } Add.ListDuyetAnh = listDuyetAnh; Add.ListBaiHat = listBaiHat; Add.Item = Item;; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; var dichVuList = new List <PhieuDichVuDichVu>(); var listDuyetAnh = new List <DuyetAnh>(); var listBaiHat = new List <BaiHat>(); var listThuChi = new List <ThuChi>(); using (var con = DAL.con()) { if (string.IsNullOrEmpty(id)) { Item = PhieuDichVuDal.SelectDraff(con); Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1; Item.ID = Guid.NewGuid(); } else { Item = PhieuDichVuDal.SelectById(con, new Guid(id)); dichVuList = PhieuDichVuDichVuDal.SelectByPdvId(con, id); listDuyetAnh = DuyetAnhDal.SelectByPdvId(con, id); listBaiHat = BaiHatDal.SelectByPdvId(con, id); listThuChi = ThuChiDal.SelectByPdvId(con, Item.ID); } Add.ListDichVu = dichVuList; Add.Item = Item;; Add.ListDuyetAnh = listDuyetAnh; Add.ListBaiHat = listBaiHat; Add.ListThuChi = listThuChi; Add.ListUrl = "/lib/pages/ThungRac/PhieuDichVu.aspx"; } }
private void InHoaDon(PhieuDichVu dv, List <CT_DichVu> ct) { FrmInHD inHD = new FrmInHD(); inHD.print(dv, ct); inHD.ShowDialog(); }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; var dichVuList = new List<PhieuDichVuDichVu>(); var listDuyetAnh = new List<DuyetAnh>(); var listBaiHat = new List<BaiHat>(); using (var con = DAL.con()) { if (string.IsNullOrEmpty(id)) { Item = PhieuDichVuDal.SelectDraff(con); Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1; Item.ID = Guid.NewGuid(); } else { Item = PhieuDichVuDal.SelectById(con, new Guid(id)); dichVuList = PhieuDichVuDichVuDal.SelectByPdvId(con, id); listDuyetAnh = DuyetAnhDal.SelectByPdvId(con, id); listBaiHat = BaiHatDal.SelectByPdvId(con, id); } Add.ListDichVu = dichVuList; Add.Item = Item; ; Add.ListDuyetAnh = listDuyetAnh; Add.ListBaiHat = listBaiHat; } }
public void EditPhieuDichVu(PhieuDichVu p) { openConnection(); string query = "update PHIEUDICHVU set MaPhieuDangKy = @MaPhieuDangKy, TenDichVu = @TenDichVu, GiaDichVu = @GiaDichVu where MaPhieuDichVu = @MaPhieuDichVu"; SqlCommand cmd = new SqlCommand(query, Conn); cmd.Parameters.AddWithValue("@MaPhieuDichVu", p.MaPhieuDichVu); cmd.Parameters.AddWithValue("@MaPhieuDangKy", p.MaPhieuDangKy); cmd.Parameters.AddWithValue("@TenDichVu", p.TenDichVu); cmd.Parameters.AddWithValue("@GiaDichVu", p.GiaDichVu); cmd.ExecuteNonQuery(); }
public void insertPhieuDichVu(PhieuDichVu p) { openConnection(); string query = "insert into PHIEUDICHVU(MaPhieuDichVu, MaPhieuDangKy, TenDichVu, GiaDichVu) values (@MaPhieuDichVu, @MaPhieuDangKy, @TenDichVu, @GiaDichVu)"; SqlCommand cmd = new SqlCommand(query, Conn); cmd.Parameters.AddWithValue("@MaPhieuDichVu", p.MaPhieuDichVu); cmd.Parameters.AddWithValue("@MaPhieuDangKy", p.MaPhieuDangKy); cmd.Parameters.AddWithValue("@TenDichVu", p.TenDichVu); cmd.Parameters.AddWithValue("@GiaDichVu", p.GiaDichVu); cmd.ExecuteNonQuery(); }
public bool KTSoPhieuDV(string pSoPhieuDV) { PhieuDichVu phieuDichVu = nhakhoa.PhieuDichVus.Where(sp => sp.SoPhieuDV == pSoPhieuDV).FirstOrDefault(); if (phieuDichVu != null) { return(false); } else { return(true); } }
//Hóa đơn dịch vụ #region public string LayMaHoaDVTuSinh() { string result = "AEON_MPDV" + 1.ToString().PadLeft(4, '0'); PhieuDichVu hd = db.PhieuDichVus.Where(x => x.MaPhieuDV.Contains($"AEON_MPDV")) .OrderByDescending(x => x.MaPhieuDV).FirstOrDefault(); if (hd != null && !string.IsNullOrWhiteSpace(hd.MaPhieuDV)) { int so = Convert.ToInt32(hd.MaPhieuDV.Replace("AEON_MPDV", "")) + 1; result = "AEON_MPDV" + so.ToString().PadLeft(4, '0'); } return(result); }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; if (string.IsNullOrEmpty(id)) id = PdvId; using (var con = DAL.con()) { var selected = DuyetAnhDal.SelectByPdvId(con, id); var pdv = PhieuDichVuDal.SelectById(con, new Guid(id)); Item = pdv; var listBaiHat = BaiHatDal.SelectByPdvId(con, id); var pdvDic = pdv.PTS_ThuMuc; if (string.IsNullOrEmpty(pdvDic)) pdvDic = ImgPath; var dic = new DirectoryInfo(pdvDic); var targetDic = Lib.ImgDomain() + pdvDic; var wc = new WebClient(); var filesInTargetDic = wc.DownloadString(targetDic); if (string.IsNullOrEmpty(filesInTargetDic)) { } else { var files = filesInTargetDic.Split(new char[] {'|'}); var list = (from f in files where f.Length > 1 select new DuyetAnh() { Ten = f , FullName = string.Format("{0}{1}", targetDic, f) }).ToList(); foreach (var item in selected) { var items = list.FirstOrDefault(x => x.Ten.ToLower() == item.Ten.ToLower()); if (items == null) continue; items.ID = item.ID; items.Selected = true; items.GhiChu = item.GhiChu; items.ThuTu = item.ThuTu; } View.DuyetAnhs = list.Where(x => x.Selected).ToList(); View.DanhSachAnh = list; View.Item = pdv; View.ListBaiHat = listBaiHat; } } }
public void ThemPhieuDichVu(string pSoPhieuDV, string pMaBN, string pMaPhong, string pNgayLap) { PhieuDichVu phieuDichVu = new PhieuDichVu(); phieuDichVu.SoPhieuDV = pSoPhieuDV; phieuDichVu.MaBenhNhan = pMaBN; phieuDichVu.MaPhong = pMaPhong; phieuDichVu.NgayLap = DateTime.Parse(pNgayLap); phieuDichVu.TinhTrang = "Chờ thực hiện"; phieuDichVu.TongTien = 0; phieuDichVu.ThanhToan = "Chưa Thanh Toán"; nhakhoa.PhieuDichVus.InsertOnSubmit(phieuDichVu); nhakhoa.SubmitChanges(); }
public bool KiemTraCoViPhamPhiDichVu(string ma) { DateTime dateTime = DateTime.Now; string nam = dateTime.ToString("yyyy"); string thang = dateTime.ToString("MM"); PhieuDichVu kt = db.PhieuDichVus.Where( t => t.MaThueMB.Equals(ma)).OrderByDescending(t => t.NgayLap).FirstOrDefault(); if (kt != null && kt.TinhTrang != 1) { return(true); } return(false); }
public bool XoaHoaDonDichVu(string maHD) { try { PhieuDichVu hd = db.PhieuDichVus.Where(t => t.MaPhieuDV.Equals(maHD)).FirstOrDefault(); db.PhieuDichVus.DeleteOnSubmit(hd); db.SubmitChanges(); return(true); } catch (Exception) { return(false); throw; } }
public void print(PhieuDichVu dv, List <CT_DichVu> data) { XtraReport1 report = new XtraReport1(); foreach (var item in report.Parameters) { item.Visible = false; } report.report((DateTime)dv.NgayLap, dv.MaThueMB, dv.ThueMatBang.DangKyThue.MaKhachHang, dv.ThueMatBang.DangKyThue.KhachHang.SDT, dv.ThueMatBang.DangKyThue.KhachHang.Email, dv.MaPhieuDV, dv.ThueMatBang.DangKyThue.KhachHang.HoTenKH, data); { documentViewer1.DocumentSource = report; report.CreateDocument(); } }
public bool ThemHoaDonDichVu(PhieuDichVu dv) { try { PhieuDichVu pdv = new PhieuDichVu(); pdv = dv; db.PhieuDichVus.InsertOnSubmit(pdv); db.SubmitChanges(); return(true); } catch (Exception) { return(false); throw; } }
public bool SuaHoaDonDichVu(PhieuDichVu ct) { try { PhieuDichVu pdv = db.PhieuDichVus.Where(t => t.MaPhieuDV.Equals(ct.MaPhieuDV)).FirstOrDefault(); pdv.TinhTrang = ct.TinhTrang; pdv.TongTien = ct.TongTien; db.PhieuDichVus.InsertOnSubmit(pdv); db.SubmitChanges(); return(true); } catch (Exception) { return(false); throw; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; using (var con = DAL.con()) { if (string.IsNullOrEmpty(id)) { Item = PhieuDichVuDal.SelectDraff(con); Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1; Item.ID = Guid.NewGuid(); } else { Item = PhieuDichVuDal.SelectById(con, new Guid(id)); Item._KhachHang = KhachHangDal.SelectById(Item.KH_ID, con); } var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description; Add.LogoStr = logoStr; Add.Item = Item; ; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; var dichVuList = new List <PhieuDichVuDichVu>(); using (var con = DAL.con()) { if (string.IsNullOrEmpty(id)) { Item = PhieuDichVuDal.SelectDraff(con); Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1; Item.ID = Guid.NewGuid(); } else { Item = PhieuDichVuDal.SelectById(con, new Guid(id)); dichVuList = PhieuDichVuDichVuDal.SelectByPdvId(con, id); } AddTd.Item = Item;; AddTd.ListDichVu = dichVuList; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; using (var con = DAL.con()) { if (string.IsNullOrEmpty(id)) { Item = PhieuDichVuDal.SelectDraff(con); Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1; Item.ID = Guid.NewGuid(); } else { Item = PhieuDichVuDal.SelectById(con, new Guid(id)); Item._KhachHang = KhachHangDal.SelectById(Item.KH_ID, con); } var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description; Add.LogoStr = logoStr; Add.Item = Item;; } }
private void btnLuu_ItemClick(object sender, ItemClickEventArgs e) { if (txtMaDK.EditValue == null) { MessageBox.Show("Hãy chọn mã thuê", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtMaDK.Focus(); return; } if (string.IsNullOrEmpty(cboTrangThai.Text)) { MessageBox.Show("Hãy chọn trạng thái", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); cboTrangThai.Focus(); return; } if (txtSoDienCu.Text == txtSoDienMoi.Text && txtSoNuocMoi.Text == txtSoNuocCu.Text) { MessageBox.Show("Hãy chọn số điện nước", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtSoDienMoi.Focus(); return; } if (check) { try { PhieuDichVu pdv = new PhieuDichVu(); pdv.MaPhieuDV = txtHoaDon.EditValue.ToString(); pdv.NgayLap = Commons.ConvertStringToDate(txtNgayLap.Text); pdv.NgayThanhToan = Commons.ConvertStringToDate(txtNgayLap.Text); pdv.TongTien = tongTien; if (cboTrangThai.SelectedIndex == 1) { pdv.TinhTrang = 1; } else { pdv.TinhTrang = 0; } pdv.MaThueMB = txtMaDK.EditValue.ToString(); pdv.MaNhanVien = maNV; CT_DichVu ctdvDien = new CT_DichVu(); ctdvDien.MaPhieuDV = txtHoaDon.EditValue.ToString(); ctdvDien.MaDichVu = "AEON_MDV0001"; ctdvDien.ChiSoMoi = int.Parse(txtSoDienMoi.EditValue.ToString()); ctdvDien.ChiSoCu = int.Parse(txtSoDienCu.EditValue.ToString()); ctdvDien.Gia = thueMB.LayGiaDien(); CT_DichVu ctdvNuoc = new CT_DichVu(); ctdvNuoc.MaPhieuDV = txtHoaDon.EditValue.ToString(); ctdvNuoc.MaDichVu = "AEON_MDV0002"; ctdvNuoc.ChiSoMoi = int.Parse(txtSoNuocMoi.EditValue.ToString()); ctdvNuoc.ChiSoCu = int.Parse(txtSoNuocCu.EditValue.ToString()); ctdvNuoc.Gia = thueMB.LayGiaNuoc(); bool keys = true; if (!thueMB.ThemHoaDonDichVu(pdv)) { keys = false; thueMB.XoaHoaDonDichVu(pdv.MaPhieuDV); } if (!thueMB.ThemCTHoaDonDichVu(ctdvDien) || !thueMB.ThemCTHoaDonDichVu(ctdvNuoc)) { keys = false; thueMB.XoaCTHoaDonDichVu(pdv.MaPhieuDV); } if (keys) { DialogResult r = MessageBox.Show("Thêm hóa đơn thành công, bạn có muốn in hóa đơn không", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information); DAL.ThongBao tt = new DAL.ThongBao(); tt.NgayTao = Commons.ConvertStringToDate(txtNgayLap.Text); tt.TaiKhoan = pdv.ThueMatBang.DangKyThue.KhachHang.SDT; tt.MaLoaiTT = 1; tt.TrangThai = 1; tt.NoiDung = string.Format(QL_MatBang.NOIDUNGTHONGBAO, (DateTime.Now).Month + "/" + (DateTime.Now).Year); tt.TieuDe = QL_MatBang.TIEUDETHONGBAO; thueMB.ThemThongBaoDichVu(tt); if (thueMB.KiemTraToken(dgvDSHoaDon.GetFocusedRowCellDisplayText(colKhachHang))) { Root root = new Root(); Notification notification = new Notification(); NotificationForCustomer thongbao = new NotificationForCustomer(); root.to = thueMB.LayToken(dgvDSHoaDon.GetFocusedRowCellDisplayText(colKhachHang)); notification.title = tt.TieuDe; notification.body = tt.NoiDung; notification.mutable_content = "True"; notification.sound = "Tri-tone"; root.notification = notification; thongbao.ThongBaoChoKhachHang(root); } if (r == DialogResult.Yes) { PhieuDichVu p = new PhieuDichVu(); p = thueMB.LayThongTinPhieuDV(txtHoaDon.EditValue.ToString()); List <CT_DichVu> c = new List <CT_DichVu>(); c = thueMB.LayThongTinCT_DichVu2(txtHoaDon.EditValue.ToString()); InHoaDon(p, c); } } Click_BtnLuu(); LoadDSHoaDon(); LoadCboMaThue(); LoadCboAllMaThue(); dgvDSHoaDon_FocusedRowChanged(null, null); } catch (Exception) { MessageBox.Show("Đã có lỗi xẩy ra", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); throw; } } else { PhieuDichVu pdv = new PhieuDichVu(); pdv.TongTien = tongTien; if (cboTrangThai.SelectedIndex == 1) { pdv.TinhTrang = 1; } else { pdv.TinhTrang = 0; } var ctdvd = thueMB.LayThongTinCT_DichVu(txtMaDK.EditValue.ToString(), "AEON_MDV0001"); var ctdvm = thueMB.LayThongTinCT_DichVu(txtMaDK.EditValue.ToString(), "AEON_MDV0002"); if (!thueMB.SuaHoaDonDichVu(pdv)) { MessageBox.Show("Đã có lỗi xẩy ra không thể sửa hóa đơn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (!ctdvd.ChiSoMoi.ToString().Equals(txtSoDienMoi.EditValue)) { CT_DichVu ctdvDien = new CT_DichVu(); ctdvd.MaPhieuDV = txtHoaDon.EditValue.ToString(); ctdvDien.MaDichVu = "AEON_MDV0001"; ctdvDien.ChiSoMoi = int.Parse(txtSoDienMoi.EditValue.ToString()); if (!thueMB.SuaCTHoaDonDichVu(ctdvDien)) { MessageBox.Show("Đã có lỗi xẩy ra không thể sửa hóa đơn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } if (!ctdvm.ChiSoMoi.ToString().Equals(txtSoNuocMoi.EditValue)) { CT_DichVu ctdvNuoc = new CT_DichVu(); ctdvd.MaPhieuDV = txtHoaDon.EditValue.ToString(); ctdvNuoc.MaDichVu = "AEON_MDV0002"; ctdvNuoc.ChiSoMoi = int.Parse(txtSoDienMoi.EditValue.ToString()); if (!thueMB.SuaCTHoaDonDichVu(ctdvNuoc)) { MessageBox.Show("Đã có lỗi xẩy ra không thể sửa hóa đơn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } MessageBox.Show("Sửa thành công hóa đơn dịch vụ :" + txtHoaDon.EditValue, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); Click_BtnLuu(); LoadDSHoaDon(); LoadCboMaThue(); LoadCboAllMaThue(); dgvDSHoaDon_FocusedRowChanged(null, null); } }
protected void Page_Load(object sender, EventArgs e) { var logged = Security.IsAuthenticated(); var Id = Request["Id"]; var IdNull = string.IsNullOrEmpty(Id); var Ma = Request["Ma"]; var KH_ID = Request["KH_ID"]; var GDV_ID = Request["GDV_ID"]; var TongTien = Request["TongTien"]; var ChietKhau = Request["ChietKhau"]; var DatCoc = Request["DatCoc"]; var ThanhToan = Request["ThanhToan"]; var ConNo = Request["ConNo"]; var TuVanVien = Request["TuVanVien"]; var NgayTuVan = Request["NgayTuVan"]; var CHUP_NhanVien = Request["CHUP_NhanVien"]; var CHUP_NgayBatDau = Request["CHUP_NgayBatDau"]; var CHUP_NgayKetThuc = Request["CHUP_NgayKetThuc"]; var CHUP_DiaDiem = Request["CHUP_DiaDiem"]; var CHUP_LoaiAlbum = Request["CHUP_LoaiAlbum"]; var CHUP_YeuCauKhach = Request["CHUP_YeuCauKhach"]; var CHUP_DaChuyenAnh = Request["CHUP_DaChuyenAnh"]; var CHUP_DaChuyenAnh_U = Request["CHUP_DaChuyenAnh_U"]; var CHUP_NgayChuyenAnh = Request["CHUP_NgayChuyenAnh"]; var TD_NhanVien = Request["TD_NhanVien"]; var TD_NgayBatDau = Request["TD_NgayBatDau"]; var TD_NgayKetThuc = Request["TD_NgayKetThuc"]; var TOC_NhanVien = Request["TOC_NhanVien"]; var TOC_NgayBatDau = Request["TOC_NgayBatDau"]; var TOC_NgayKetThuc = Request["TOC_NgayKetThuc"]; var TD_DiaDiem = Request["TD_DiaDiem"]; var TD_KhoangCach = Request["TD_KhoangCach"]; var TD_PhiDiLai = Request["TD_PhiDiLai"]; var TD_KhoanPhaiThu = Request["TD_KhoanPhaiThu"]; var PTS_NhanVien = Request["PTS_NhanVien"]; var PTS_NhanVienDaNhan = Request["PTS_NhanVienDaNhan"]; var PTS_NhanVienDaNhan_U = Request["PTS_NhanVienDaNhan_U"]; var PTS_NgayXemMaket = Request["PTS_NgayXemMaket"]; var PTS_NgayBatDau = Request["PTS_NgayBatDau"]; var PTS_NgayKetThuc = Request["PTS_NgayKetThuc"]; var PTS_YeuCauKhachHang = Request["PTS_YeuCauKhachHang"]; var PTS_HenSanPham = Request["PTS_HenSanPham"]; var PTS_DaCoSanPham = Request["PTS_DaCoSanPham"]; var PTS_DaCoSanPham_U = Request["PTS_DaCoSanPham_U"]; var PTS_NgayCoSanPham = Request["PTS_NgayCoSanPham"]; var PTS_NgayLaySanPham = Request["PTS_NgayLaySanPham"]; var PTS_AnhPhong = Request["PTS_AnhPhong"]; var PTS_AnhPhongGhiChu = Request["PTS_AnhPhongGhiChu"]; var PTS_AnhBan = Request["PTS_AnhBan"]; var PTS_AnhBanGhiChu = Request["PTS_AnhBanGhiChu"]; var PTS_AnhBanQuyCach = Request["PTS_AnhBanQuyCach"]; var PTS_AnhBia = Request["PTS_AnhBia"]; var PTS_CD3D = Request["PTS_CD3D"]; var PTS_CD3D_U = Request["PTS_CD3D_U"]; var PTS_AnhBiaMau = Request["PTS_AnhBiaMau"]; var PTS_ThuMuc = Request["PTS_ThuMuc"]; var HoanThanh = Request["HoanThanh"]; var HoanThanh_U = Request["HoanThanh_U"]; var Voucher = Request["Voucher"]; var Voucher_Ma = Request["Voucher_Ma"]; var NguoiTao = Request["NguoiTao"]; var NguoiCapNhat = Request["NguoiCapNhat"]; var NgayTao = Request["NgayTao"]; var NgayCapNhat = Request["NgayCapNhat"]; var Xoa = Request["Xoa"]; var TrangThai = Request["TrangThai"]; var Huy = Request["Huy"]; var LyDoHuy = Request["LyDoHuy"]; var NgayHuy = Request["NgayHuy"]; var TD_NgoaiCanh = Request["TD_NgoaiCanh"]; var TD_NgoaiCanh_U = Request["TD_NgoaiCanh_U"]; var NhanVienHuy = Request["NhanVienHuy"]; var DuyetEkip = Request["DuyetEkip"]; var DeNghiDuyetEkip = Request["DeNghiDuyetEkip"]; var CHUP_NgayBatDau_Gio = Request["CHUP_NgayBatDau_Gio"]; var CHUP_NgayKetThuc_Gio = Request["CHUP_NgayKetThuc_Gio"]; var TD_NgayBatDau_Gio = Request["TD_NgayBatDau_Gio"]; var TD_NgayKetThuc_Gio = Request["TD_NgayKetThuc_Gio"]; var TOC_NgayBatDau_Gio = Request["TOC_NgayBatDau_Gio"]; var TOC_NgayKetThuc_Gio = Request["TOC_NgayKetThuc_Gio"]; var PTS_NgayBatDau_Gio = Request["PTS_NgayBatDau_Gio"]; var PTS_NgayKetThuc_Gio = Request["PTS_NgayKetThuc_Gio"]; CHUP_DaChuyenAnh = !string.IsNullOrEmpty(CHUP_DaChuyenAnh_U) ? string.IsNullOrEmpty(CHUP_DaChuyenAnh) ? "false" : "true" : ""; PTS_NhanVienDaNhan = !string.IsNullOrEmpty(PTS_NhanVienDaNhan_U) ? string.IsNullOrEmpty(PTS_NhanVienDaNhan) ? "false" : "true" : ""; PTS_CD3D = !string.IsNullOrEmpty(PTS_CD3D_U) ? string.IsNullOrEmpty(PTS_CD3D) ? "false" : "true" : ""; PTS_DaCoSanPham = !string.IsNullOrEmpty(PTS_DaCoSanPham_U) ? string.IsNullOrEmpty(PTS_DaCoSanPham) ? "false" : "true" : ""; Huy = string.IsNullOrEmpty(Huy) ? "false" : "true"; HoanThanh = !string.IsNullOrEmpty(HoanThanh_U) ? string.IsNullOrEmpty(HoanThanh) ? "false" : "true" : ""; DuyetEkip = string.IsNullOrEmpty(DuyetEkip) ? "false" : "true"; TD_NgoaiCanh = !string.IsNullOrEmpty(TD_NgoaiCanh_U) ? string.IsNullOrEmpty(TD_NgoaiCanh) ? "false" : "true" : ""; var refUrl = Request["refUrl"]; if (!string.IsNullOrEmpty(refUrl)) refUrl = Server.UrlDecode(refUrl); var q = Request["q"]; switch (subAct) { case "save": #region Thêm phiếu dịch vụ if (Security.IsAuthenticated()) { var item = PhieuDichVuDal.SelectById(DAL.con(),new Guid(Id)); IdNull = item.ID == Guid.Empty; item.ID=new Guid(Id); if (IdNull) { item = new PhieuDichVu { ID = new Guid(Id), NgayTao = DateTime.Now, NguoiTao = Security.UserId }; } item.NguoiCapNhat = Security.UserId; item.NgayCapNhat = DateTime.Now; if (Convert.ToBoolean(DuyetEkip)) { if(!item.DuyetEkip) { item.NgayDuyetEkip = DateTime.Now; item.NguoiDuyet = Security.UserId; } } if (!string.IsNullOrEmpty(TD_NgoaiCanh)) { item.TD_NgoaiCanh = Convert.ToBoolean(TD_NgoaiCanh); } if (!string.IsNullOrEmpty(DeNghiDuyetEkip)) { item.DuyetEkip = Convert.ToBoolean(DuyetEkip); } if (!string.IsNullOrEmpty(Ma)) { item.Ma = Convert.ToInt32(Ma); } if (!string.IsNullOrEmpty(KH_ID)) { item.KH_ID = new Guid(KH_ID); } if (!string.IsNullOrEmpty(NgayTuVan)) { item.NgayTuVan = Convert.ToDateTime(NgayTuVan, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(TuVanVien)) { item.TuVanVien = Convert.ToInt32(TuVanVien); } if (!string.IsNullOrEmpty(GDV_ID)) { item.GDV_ID = new Guid(GDV_ID); } // Chup anh if (!string.IsNullOrEmpty(CHUP_NhanVien)) { item.CHUP_NhanVien = Convert.ToInt32(CHUP_NhanVien); } if (!string.IsNullOrEmpty(CHUP_NgayBatDau) && !string.IsNullOrEmpty(CHUP_NgayBatDau_Gio)) { item.CHUP_NgayBatDau = Convert.ToDateTime(string.Format("{0} {1}", CHUP_NgayBatDau, CHUP_NgayBatDau_Gio), new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(CHUP_NgayBatDau) && !string.IsNullOrEmpty(CHUP_NgayKetThuc_Gio)) { item.CHUP_NgayKetThuc = Convert.ToDateTime(string.Format("{0} {1}", CHUP_NgayBatDau, CHUP_NgayKetThuc_Gio), new CultureInfo("vi-vn")); } item.CHUP_DiaDiem = CHUP_DiaDiem; item.CHUP_LoaiAlbum = CHUP_LoaiAlbum; item.CHUP_YeuCauKhach = CHUP_YeuCauKhach; if (!string.IsNullOrEmpty(CHUP_DaChuyenAnh)) { item.CHUP_DaChuyenAnh = Convert.ToBoolean(CHUP_DaChuyenAnh); } item.Huy = Convert.ToBoolean(Huy); // Trang diem if (!string.IsNullOrEmpty(TD_NhanVien)) { item.TD_NhanVien = Convert.ToInt32(TD_NhanVien); } if (!string.IsNullOrEmpty(TD_NgayBatDau) && !string.IsNullOrEmpty(TD_NgayBatDau_Gio)) { item.TD_NgayBatDau = Convert.ToDateTime(string.Format("{0} {1}", TD_NgayBatDau, TD_NgayBatDau_Gio), new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(TD_NgayBatDau) && !string.IsNullOrEmpty(TD_NgayKetThuc_Gio)) { item.TD_NgayKetThuc = Convert.ToDateTime(string.Format("{0} {1}", TD_NgayBatDau, TD_NgayKetThuc_Gio), new CultureInfo("vi-vn")); } item.TD_DiaDiem = TD_DiaDiem; if (!string.IsNullOrEmpty(TD_KhoangCach)) { item.TD_KhoangCach = Convert.ToInt32(TD_KhoangCach); } if (!string.IsNullOrEmpty(TD_PhiDiLai)) { item.TD_PhiDiLai = Convert.ToDouble(TD_PhiDiLai); } if (!string.IsNullOrEmpty(TD_KhoanPhaiThu)) { item.TD_KhoanPhaiThu = Convert.ToDouble(TD_KhoanPhaiThu); } // Toc if (!string.IsNullOrEmpty(TOC_NhanVien)) { item.TOC_NhanVien = Convert.ToInt32(TOC_NhanVien); } if (!string.IsNullOrEmpty(TOC_NgayBatDau) && !string.IsNullOrEmpty(TOC_NgayBatDau_Gio)) { item.TOC_NgayBatDau = Convert.ToDateTime(string.Format("{0} {1}", TOC_NgayBatDau, TOC_NgayBatDau_Gio), new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(TOC_NgayBatDau) && !string.IsNullOrEmpty(TOC_NgayKetThuc_Gio)) { item.TOC_NgayKetThuc = Convert.ToDateTime(string.Format("{0} {1}", TOC_NgayBatDau, TOC_NgayKetThuc_Gio), new CultureInfo("vi-vn")); } // Photoshop if (!string.IsNullOrEmpty(PTS_NhanVien)) { item.PTS_NhanVien = Convert.ToInt32(PTS_NhanVien); } if (!string.IsNullOrEmpty(PTS_NgayBatDau)) { item.PTS_NgayBatDau = Convert.ToDateTime(PTS_NgayBatDau, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(PTS_NgayLaySanPham)) { item.PTS_NgayLaySanPham = Convert.ToDateTime(PTS_NgayLaySanPham, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(PTS_NgayKetThuc)) { item.PTS_NgayKetThuc = Convert.ToDateTime(PTS_NgayKetThuc, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(PTS_NhanVienDaNhan)) { item.PTS_NhanVienDaNhan = Convert.ToBoolean(PTS_NhanVienDaNhan); } if (!string.IsNullOrEmpty(PTS_NgayXemMaket)) { item.PTS_NgayXemMaket = Convert.ToDateTime(PTS_NgayXemMaket, new CultureInfo("vi-vn")); } item.PTS_AnhBiaMau = PTS_AnhBiaMau; item.PTS_ThuMuc = PTS_ThuMuc; item.PTS_YeuCauKhachHang = PTS_YeuCauKhachHang; item.PTS_AnhBia = PTS_AnhBia; item.PTS_AnhPhong = PTS_AnhPhong; item.PTS_AnhPhongGhiChu = PTS_AnhPhongGhiChu; item.PTS_AnhBan = PTS_AnhBan; item.PTS_AnhBanQuyCach = PTS_AnhBanQuyCach; item.PTS_AnhBanGhiChu = PTS_AnhBanGhiChu; if (!string.IsNullOrEmpty(PTS_CD3D)) { item.PTS_CD3D = Convert.ToBoolean(PTS_CD3D); } if (!string.IsNullOrEmpty(HoanThanh)) { item.HoanThanh = Convert.ToBoolean(HoanThanh); } if (!string.IsNullOrEmpty(PTS_HenSanPham)) { item.PTS_HenSanPham = Convert.ToDateTime(PTS_HenSanPham, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(PTS_NgayCoSanPham)) { item.PTS_NgayCoSanPham = Convert.ToDateTime(PTS_NgayCoSanPham, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(PTS_DaCoSanPham)) { item.PTS_DaCoSanPham = Convert.ToBoolean(PTS_DaCoSanPham); } if(!string.IsNullOrEmpty(TongTien)) { item.TongTien = Convert.ToDouble(TongTien); } if (!string.IsNullOrEmpty(DatCoc)) { item.DatCoc = Convert.ToDouble(DatCoc); } if (!string.IsNullOrEmpty(ConNo)) { item.ConNo = Convert.ToDouble(ConNo); } // Huy + Trang Thai if(!string.IsNullOrEmpty(TrangThai)) { item.TrangThai = Convert.ToInt32(TrangThai); } if (!string.IsNullOrEmpty(NgayHuy)) { item.NgayHuy = Convert.ToDateTime(NgayHuy, new CultureInfo("vi-vn")); } item.LyDoHuy = LyDoHuy; if(!string.IsNullOrEmpty(NhanVienHuy)) { item.NhanVienHuy = Convert.ToInt32(NhanVienHuy); } if (IdNull) { item = PhieuDichVuDal.Insert(item); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} thêm mới phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 1 , Ten = "Thêm" }); #endregion } else { item = PhieuDichVuDal.Update(item); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} sửa phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 2 , Ten = "Sửa" }); #endregion } //SearchManager.Add(Ten, item.IndexNoiDung, item.IndexContent, Ten, item.ID.ToString(), item.Url, typeof(SuKien).Name); TimKiemDal.Add(item, item.ID); rendertext(item.ID.ToString()); } break; #endregion case "saveDuyetAnh": #region Lưu nhanh phiếu dịch vụ khi khách hàng duyệt ảnh if (Security.IsAuthenticated()) { var item = PhieuDichVuDal.SelectById(DAL.con(), new Guid(Id)); item.PTS_AnhBiaMau = PTS_AnhBiaMau; item.PTS_YeuCauKhachHang = PTS_YeuCauKhachHang; item.PTS_AnhBia = PTS_AnhBia; item.PTS_AnhPhong = PTS_AnhPhong; item.PTS_AnhPhongGhiChu = PTS_AnhPhongGhiChu; item.PTS_AnhBan = PTS_AnhBan; item.PTS_AnhBanQuyCach = PTS_AnhBanQuyCach; item.PTS_AnhBanGhiChu = PTS_AnhBanGhiChu; item.NgayCapNhat = DateTime.Now; item.NguoiCapNhat = Security.UserId; item = PhieuDichVuDal.Update(item); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} sửa phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 2 , Ten = "Sửa" }); #endregion //SearchManager.Add(Ten, item.IndexNoiDung, item.IndexContent, Ten, item.ID.ToString(), item.Url, typeof(SuKien).Name); TimKiemDal.Add(item, item.ID); rendertext(item.ID.ToString()); } break; #endregion case "remove": #region Xóa phiếu dịch vụ if (logged) { var item = PhieuDichVuDal.SelectById(DAL.con(),new Guid(Id)); if (item.NguoiTao != 0) { item.Xoa = true; item.NgayCapNhat = DateTime.Now; item.NguoiCapNhat = Security.UserId; PhieuDichVuDal.Update(item); //SearchManager.Remove(Id); TimKiemDal.DeleteByPRowId(DAL.con(), item.ID); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} xóa phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 3 , Ten = "Xóa" }); #endregion rendertext("1"); } else { rendertext("0"); } } break; #endregion case "removeAdm": #region Xóa phiếu dịch vụ if (Security.IsAuthenticated()) { var item = PhieuDichVuDal.SelectById(DAL.con(), new Guid(Id)); if (item.NguoiTao == Security.UserId) { item.XoaAdm = true; item.NgayCapNhat = DateTime.Now; item.NguoiCapNhat = Security.UserId; PhieuDichVuDal.Update(item); //SearchManager.Remove(Id); TimKiemDal.DeleteByPRowId(DAL.con(), item.ID); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} xóa phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 3 , Ten = "Xóa" }); #endregion rendertext("1"); } else { rendertext("0"); } } break; #endregion case "restore": #region khôi phục phiếu dịch vụ if (Security.IsAuthenticated()) { var item = PhieuDichVuDal.SelectById(DAL.con(), new Guid(Id)); if (item.NguoiTao == Security.UserId) { item.Xoa = false; item.XoaAdm = false; item.NgayCapNhat = DateTime.Now; item.NguoiCapNhat = Security.UserId; PhieuDichVuDal.Update(item); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} khôi phục phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 3 , Ten = "Khôi phục" }); #endregion rendertext("1"); } else { rendertext("0"); } } break; #endregion case "search": #region search var pg = PhieuDichVuDal.TimNhanh(DAL.con(), q, "10"); rendertext(JavaScriptConvert.SerializeObject(pg), "text/javascript"); break; #endregion default: break; } }
public bool SuaHoaDonDichVu(PhieuDichVu tt) { return(dkThue.SuaHoaDonDichVu(tt)); }
public bool ThemHoaDonDichVu(PhieuDichVu dv) { return(dkThue.ThemHoaDonDichVu(dv)); }
protected void Page_Load(object sender, EventArgs e) { var logged = Security.IsAuthenticated(); var Id = Request["Id"]; var IdNull = string.IsNullOrEmpty(Id); var Ma = Request["Ma"]; var KH_ID = Request["KH_ID"]; var GDV_ID = Request["GDV_ID"]; var TongTien = Request["TongTien"]; var ChietKhau = Request["ChietKhau"]; var DatCoc = Request["DatCoc"]; var ThanhToan = Request["ThanhToan"]; var ConNo = Request["ConNo"]; var TuVanVien = Request["TuVanVien"]; var NgayTuVan = Request["NgayTuVan"]; var CHUP_NhanVien = Request["CHUP_NhanVien"]; var CHUP_NgayBatDau = Request["CHUP_NgayBatDau"]; var CHUP_NgayKetThuc = Request["CHUP_NgayKetThuc"]; var CHUP_DiaDiem = Request["CHUP_DiaDiem"]; var CHUP_LoaiAlbum = Request["CHUP_LoaiAlbum"]; var CHUP_YeuCauKhach = Request["CHUP_YeuCauKhach"]; var CHUP_DaChuyenAnh = Request["CHUP_DaChuyenAnh"]; var CHUP_DaChuyenAnh_U = Request["CHUP_DaChuyenAnh_U"]; var CHUP_NgayChuyenAnh = Request["CHUP_NgayChuyenAnh"]; var TD_NhanVien = Request["TD_NhanVien"]; var TD_NgayBatDau = Request["TD_NgayBatDau"]; var TD_NgayKetThuc = Request["TD_NgayKetThuc"]; var TOC_NhanVien = Request["TOC_NhanVien"]; var TOC_NgayBatDau = Request["TOC_NgayBatDau"]; var TOC_NgayKetThuc = Request["TOC_NgayKetThuc"]; var TD_DiaDiem = Request["TD_DiaDiem"]; var TD_KhoangCach = Request["TD_KhoangCach"]; var TD_PhiDiLai = Request["TD_PhiDiLai"]; var TD_KhoanPhaiThu = Request["TD_KhoanPhaiThu"]; var PTS_NhanVien = Request["PTS_NhanVien"]; var PTS_NhanVienDaNhan = Request["PTS_NhanVienDaNhan"]; var PTS_NhanVienDaNhan_U = Request["PTS_NhanVienDaNhan_U"]; var PTS_NgayXemMaket = Request["PTS_NgayXemMaket"]; var PTS_NgayBatDau = Request["PTS_NgayBatDau"]; var PTS_NgayKetThuc = Request["PTS_NgayKetThuc"]; var PTS_YeuCauKhachHang = Request["PTS_YeuCauKhachHang"]; var PTS_HenSanPham = Request["PTS_HenSanPham"]; var PTS_DaCoSanPham = Request["PTS_DaCoSanPham"]; var PTS_DaCoSanPham_U = Request["PTS_DaCoSanPham_U"]; var PTS_NgayCoSanPham = Request["PTS_NgayCoSanPham"]; var PTS_NgayLaySanPham = Request["PTS_NgayLaySanPham"]; var PTS_AnhPhong = Request["PTS_AnhPhong"]; var PTS_AnhPhongGhiChu = Request["PTS_AnhPhongGhiChu"]; var PTS_AnhBan = Request["PTS_AnhBan"]; var PTS_AnhBanGhiChu = Request["PTS_AnhBanGhiChu"]; var PTS_AnhBanQuyCach = Request["PTS_AnhBanQuyCach"]; var PTS_AnhBia = Request["PTS_AnhBia"]; var PTS_CD3D = Request["PTS_CD3D"]; var PTS_CD3D_U = Request["PTS_CD3D_U"]; var PTS_AnhBiaMau = Request["PTS_AnhBiaMau"]; var PTS_ThuMuc = Request["PTS_ThuMuc"]; var HoanThanh = Request["HoanThanh"]; var HoanThanh_U = Request["HoanThanh_U"]; var Voucher = Request["Voucher"]; var Voucher_Ma = Request["Voucher_Ma"]; var NguoiTao = Request["NguoiTao"]; var NguoiCapNhat = Request["NguoiCapNhat"]; var NgayTao = Request["NgayTao"]; var NgayCapNhat = Request["NgayCapNhat"]; var Xoa = Request["Xoa"]; var TrangThai = Request["TrangThai"]; var Huy = Request["Huy"]; var LyDoHuy = Request["LyDoHuy"]; var NgayHuy = Request["NgayHuy"]; var TD_NgoaiCanh = Request["TD_NgoaiCanh"]; var TD_NgoaiCanh_U = Request["TD_NgoaiCanh_U"]; var NhanVienHuy = Request["NhanVienHuy"]; var DuyetEkip = Request["DuyetEkip"]; var DeNghiDuyetEkip = Request["DeNghiDuyetEkip"]; var CHUP_NgayBatDau_Gio = Request["CHUP_NgayBatDau_Gio"]; var CHUP_NgayKetThuc_Gio = Request["CHUP_NgayKetThuc_Gio"]; var TD_NgayBatDau_Gio = Request["TD_NgayBatDau_Gio"]; var TD_NgayKetThuc_Gio = Request["TD_NgayKetThuc_Gio"]; var TOC_NgayBatDau_Gio = Request["TOC_NgayBatDau_Gio"]; var TOC_NgayKetThuc_Gio = Request["TOC_NgayKetThuc_Gio"]; var PTS_NgayBatDau_Gio = Request["PTS_NgayBatDau_Gio"]; var PTS_NgayKetThuc_Gio = Request["PTS_NgayKetThuc_Gio"]; CHUP_DaChuyenAnh = !string.IsNullOrEmpty(CHUP_DaChuyenAnh_U) ? string.IsNullOrEmpty(CHUP_DaChuyenAnh) ? "false" : "true" : ""; PTS_NhanVienDaNhan = !string.IsNullOrEmpty(PTS_NhanVienDaNhan_U) ? string.IsNullOrEmpty(PTS_NhanVienDaNhan) ? "false" : "true" : ""; PTS_CD3D = !string.IsNullOrEmpty(PTS_CD3D_U) ? string.IsNullOrEmpty(PTS_CD3D) ? "false" : "true" : ""; PTS_DaCoSanPham = !string.IsNullOrEmpty(PTS_DaCoSanPham_U) ? string.IsNullOrEmpty(PTS_DaCoSanPham) ? "false" : "true" : ""; Huy = string.IsNullOrEmpty(Huy) ? "false" : "true"; HoanThanh = !string.IsNullOrEmpty(HoanThanh_U) ? string.IsNullOrEmpty(HoanThanh) ? "false" : "true" : ""; DuyetEkip = string.IsNullOrEmpty(DuyetEkip) ? "false" : "true"; TD_NgoaiCanh = !string.IsNullOrEmpty(TD_NgoaiCanh_U) ? string.IsNullOrEmpty(TD_NgoaiCanh) ? "false" : "true" : ""; var refUrl = Request["refUrl"]; if (!string.IsNullOrEmpty(refUrl)) { refUrl = Server.UrlDecode(refUrl); } var q = Request["q"]; switch (subAct) { case "save": #region Thêm phiếu dịch vụ if (Security.IsAuthenticated()) { var item = PhieuDichVuDal.SelectById(DAL.con(), new Guid(Id)); IdNull = item.ID == Guid.Empty; item.ID = new Guid(Id); if (IdNull) { item = new PhieuDichVu { ID = new Guid(Id), NgayTao = DateTime.Now, NguoiTao = Security.UserId }; } item.NguoiCapNhat = Security.UserId; item.NgayCapNhat = DateTime.Now; if (Convert.ToBoolean(DuyetEkip)) { if (!item.DuyetEkip) { item.NgayDuyetEkip = DateTime.Now; item.NguoiDuyet = Security.UserId; } } if (!string.IsNullOrEmpty(TD_NgoaiCanh)) { item.TD_NgoaiCanh = Convert.ToBoolean(TD_NgoaiCanh); } if (!string.IsNullOrEmpty(DeNghiDuyetEkip)) { item.DuyetEkip = Convert.ToBoolean(DuyetEkip); } if (!string.IsNullOrEmpty(Ma)) { item.Ma = Convert.ToInt32(Ma); } if (!string.IsNullOrEmpty(KH_ID)) { item.KH_ID = new Guid(KH_ID); } if (!string.IsNullOrEmpty(NgayTuVan)) { item.NgayTuVan = Convert.ToDateTime(NgayTuVan, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(TuVanVien)) { item.TuVanVien = Convert.ToInt32(TuVanVien); } if (!string.IsNullOrEmpty(GDV_ID)) { item.GDV_ID = new Guid(GDV_ID); } // Chup anh if (!string.IsNullOrEmpty(CHUP_NhanVien)) { item.CHUP_NhanVien = Convert.ToInt32(CHUP_NhanVien); } if (!string.IsNullOrEmpty(CHUP_NgayBatDau) && !string.IsNullOrEmpty(CHUP_NgayBatDau_Gio)) { item.CHUP_NgayBatDau = Convert.ToDateTime(string.Format("{0} {1}", CHUP_NgayBatDau, CHUP_NgayBatDau_Gio), new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(CHUP_NgayBatDau) && !string.IsNullOrEmpty(CHUP_NgayKetThuc_Gio)) { item.CHUP_NgayKetThuc = Convert.ToDateTime(string.Format("{0} {1}", CHUP_NgayBatDau, CHUP_NgayKetThuc_Gio), new CultureInfo("vi-vn")); } item.CHUP_DiaDiem = CHUP_DiaDiem; item.CHUP_LoaiAlbum = CHUP_LoaiAlbum; item.CHUP_YeuCauKhach = CHUP_YeuCauKhach; if (!string.IsNullOrEmpty(CHUP_DaChuyenAnh)) { item.CHUP_DaChuyenAnh = Convert.ToBoolean(CHUP_DaChuyenAnh); } item.Huy = Convert.ToBoolean(Huy); // Trang diem if (!string.IsNullOrEmpty(TD_NhanVien)) { item.TD_NhanVien = Convert.ToInt32(TD_NhanVien); } if (!string.IsNullOrEmpty(TD_NgayBatDau) && !string.IsNullOrEmpty(TD_NgayBatDau_Gio)) { item.TD_NgayBatDau = Convert.ToDateTime(string.Format("{0} {1}", TD_NgayBatDau, TD_NgayBatDau_Gio), new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(TD_NgayBatDau) && !string.IsNullOrEmpty(TD_NgayKetThuc_Gio)) { item.TD_NgayKetThuc = Convert.ToDateTime(string.Format("{0} {1}", TD_NgayBatDau, TD_NgayKetThuc_Gio), new CultureInfo("vi-vn")); } item.TD_DiaDiem = TD_DiaDiem; if (!string.IsNullOrEmpty(TD_KhoangCach)) { item.TD_KhoangCach = Convert.ToInt32(TD_KhoangCach); } if (!string.IsNullOrEmpty(TD_PhiDiLai)) { item.TD_PhiDiLai = Convert.ToDouble(TD_PhiDiLai); } if (!string.IsNullOrEmpty(TD_KhoanPhaiThu)) { item.TD_KhoanPhaiThu = Convert.ToDouble(TD_KhoanPhaiThu); } // Toc if (!string.IsNullOrEmpty(TOC_NhanVien)) { item.TOC_NhanVien = Convert.ToInt32(TOC_NhanVien); } if (!string.IsNullOrEmpty(TOC_NgayBatDau) && !string.IsNullOrEmpty(TOC_NgayBatDau_Gio)) { item.TOC_NgayBatDau = Convert.ToDateTime(string.Format("{0} {1}", TOC_NgayBatDau, TOC_NgayBatDau_Gio), new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(TOC_NgayBatDau) && !string.IsNullOrEmpty(TOC_NgayKetThuc_Gio)) { item.TOC_NgayKetThuc = Convert.ToDateTime(string.Format("{0} {1}", TOC_NgayBatDau, TOC_NgayKetThuc_Gio), new CultureInfo("vi-vn")); } // Photoshop if (!string.IsNullOrEmpty(PTS_NhanVien)) { item.PTS_NhanVien = Convert.ToInt32(PTS_NhanVien); } if (!string.IsNullOrEmpty(PTS_NgayBatDau)) { item.PTS_NgayBatDau = Convert.ToDateTime(PTS_NgayBatDau, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(PTS_NgayLaySanPham)) { item.PTS_NgayLaySanPham = Convert.ToDateTime(PTS_NgayLaySanPham, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(PTS_NgayKetThuc)) { item.PTS_NgayKetThuc = Convert.ToDateTime(PTS_NgayKetThuc, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(PTS_NhanVienDaNhan)) { item.PTS_NhanVienDaNhan = Convert.ToBoolean(PTS_NhanVienDaNhan); } if (!string.IsNullOrEmpty(PTS_NgayXemMaket)) { item.PTS_NgayXemMaket = Convert.ToDateTime(PTS_NgayXemMaket, new CultureInfo("vi-vn")); } item.PTS_AnhBiaMau = PTS_AnhBiaMau; item.PTS_ThuMuc = PTS_ThuMuc; item.PTS_YeuCauKhachHang = PTS_YeuCauKhachHang; item.PTS_AnhBia = PTS_AnhBia; item.PTS_AnhPhong = PTS_AnhPhong; item.PTS_AnhPhongGhiChu = PTS_AnhPhongGhiChu; item.PTS_AnhBan = PTS_AnhBan; item.PTS_AnhBanQuyCach = PTS_AnhBanQuyCach; item.PTS_AnhBanGhiChu = PTS_AnhBanGhiChu; if (!string.IsNullOrEmpty(PTS_CD3D)) { item.PTS_CD3D = Convert.ToBoolean(PTS_CD3D); } if (!string.IsNullOrEmpty(HoanThanh)) { item.HoanThanh = Convert.ToBoolean(HoanThanh); } if (!string.IsNullOrEmpty(PTS_HenSanPham)) { item.PTS_HenSanPham = Convert.ToDateTime(PTS_HenSanPham, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(PTS_NgayCoSanPham)) { item.PTS_NgayCoSanPham = Convert.ToDateTime(PTS_NgayCoSanPham, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(PTS_DaCoSanPham)) { item.PTS_DaCoSanPham = Convert.ToBoolean(PTS_DaCoSanPham); } if (!string.IsNullOrEmpty(TongTien)) { item.TongTien = Convert.ToDouble(TongTien); } if (!string.IsNullOrEmpty(DatCoc)) { item.DatCoc = Convert.ToDouble(DatCoc); } if (!string.IsNullOrEmpty(ConNo)) { item.ConNo = Convert.ToDouble(ConNo); } // Huy + Trang Thai if (!string.IsNullOrEmpty(TrangThai)) { item.TrangThai = Convert.ToInt32(TrangThai); } if (!string.IsNullOrEmpty(NgayHuy)) { item.NgayHuy = Convert.ToDateTime(NgayHuy, new CultureInfo("vi-vn")); } item.LyDoHuy = LyDoHuy; if (!string.IsNullOrEmpty(NhanVienHuy)) { item.NhanVienHuy = Convert.ToInt32(NhanVienHuy); } if (IdNull) { item = PhieuDichVuDal.Insert(item); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} thêm mới phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 1 , Ten = "Thêm" }); #endregion } else { item = PhieuDichVuDal.Update(item); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} sửa phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 2 , Ten = "Sửa" }); #endregion } //SearchManager.Add(Ten, item.IndexNoiDung, item.IndexContent, Ten, item.ID.ToString(), item.Url, typeof(SuKien).Name); TimKiemDal.Add(item, item.ID); rendertext(item.ID.ToString()); } break; #endregion case "saveDuyetAnh": #region Lưu nhanh phiếu dịch vụ khi khách hàng duyệt ảnh if (Security.IsAuthenticated()) { var item = PhieuDichVuDal.SelectById(DAL.con(), new Guid(Id)); item.PTS_AnhBiaMau = PTS_AnhBiaMau; item.PTS_YeuCauKhachHang = PTS_YeuCauKhachHang; item.PTS_AnhBia = PTS_AnhBia; item.PTS_AnhPhong = PTS_AnhPhong; item.PTS_AnhPhongGhiChu = PTS_AnhPhongGhiChu; item.PTS_AnhBan = PTS_AnhBan; item.PTS_AnhBanQuyCach = PTS_AnhBanQuyCach; item.PTS_AnhBanGhiChu = PTS_AnhBanGhiChu; item.NgayCapNhat = DateTime.Now; item.NguoiCapNhat = Security.UserId; item = PhieuDichVuDal.Update(item); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} sửa phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 2 , Ten = "Sửa" }); #endregion //SearchManager.Add(Ten, item.IndexNoiDung, item.IndexContent, Ten, item.ID.ToString(), item.Url, typeof(SuKien).Name); TimKiemDal.Add(item, item.ID); rendertext(item.ID.ToString()); } break; #endregion case "remove": #region Xóa phiếu dịch vụ if (logged) { var item = PhieuDichVuDal.SelectById(DAL.con(), new Guid(Id)); if (item.NguoiTao != 0) { item.Xoa = true; item.NgayCapNhat = DateTime.Now; item.NguoiCapNhat = Security.UserId; PhieuDichVuDal.Update(item); //SearchManager.Remove(Id); TimKiemDal.DeleteByPRowId(DAL.con(), item.ID); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} xóa phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 3 , Ten = "Xóa" }); #endregion rendertext("1"); } else { rendertext("0"); } } break; #endregion case "removeAdm": #region Xóa phiếu dịch vụ if (Security.IsAuthenticated()) { var item = PhieuDichVuDal.SelectById(DAL.con(), new Guid(Id)); if (item.NguoiTao == Security.UserId) { item.XoaAdm = true; item.NgayCapNhat = DateTime.Now; item.NguoiCapNhat = Security.UserId; PhieuDichVuDal.Update(item); //SearchManager.Remove(Id); TimKiemDal.DeleteByPRowId(DAL.con(), item.ID); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} xóa phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 3 , Ten = "Xóa" }); #endregion rendertext("1"); } else { rendertext("0"); } } break; #endregion case "restore": #region khôi phục phiếu dịch vụ if (Security.IsAuthenticated()) { var item = PhieuDichVuDal.SelectById(DAL.con(), new Guid(Id)); if (item.NguoiTao == Security.UserId) { item.Xoa = false; item.XoaAdm = false; item.NgayCapNhat = DateTime.Now; item.NguoiCapNhat = Security.UserId; PhieuDichVuDal.Update(item); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} khôi phục phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 3 , Ten = "Khôi phục" }); #endregion rendertext("1"); } else { rendertext("0"); } } break; #endregion case "search": #region search var pg = PhieuDichVuDal.TimNhanh(DAL.con(), q, "10"); rendertext(JavaScriptConvert.SerializeObject(pg), "text/javascript"); break; #endregion default: break; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; if (string.IsNullOrEmpty(id)) { id = PdvId; } using (var con = DAL.con()) { var selected = DuyetAnhDal.SelectByPdvId(con, id); var pdv = PhieuDichVuDal.SelectById(con, new Guid(id)); Item = pdv; var listBaiHat = BaiHatDal.SelectByPdvId(con, id); var pdvDic = pdv.PTS_ThuMuc; if (string.IsNullOrEmpty(pdvDic)) { pdvDic = ImgPath; } var dic = new DirectoryInfo(pdvDic); var targetDic = Lib.ImgDomain() + pdvDic; var wc = new WebClient(); var filesInTargetDic = wc.DownloadString(targetDic); if (string.IsNullOrEmpty(filesInTargetDic)) { } else { var files = filesInTargetDic.Split(new char[] { '|' }); var list = (from f in files where f.Length > 1 select new DuyetAnh() { Ten = f , FullName = string.Format("{0}{1}", targetDic, f) }).ToList(); foreach (var item in selected) { var items = list.FirstOrDefault(x => x.Ten.ToLower() == item.Ten.ToLower()); if (items == null) { continue; } items.ID = item.ID; items.Selected = true; items.GhiChu = item.GhiChu; items.ThuTu = item.ThuTu; } View.DuyetAnhs = list.Where(x => x.Selected).ToList(); View.DanhSachAnh = list; View.Item = pdv; View.ListBaiHat = listBaiHat; } } }