//public static IEnumerable<SanPham> ChiTiet(String id)
//{
// var db = new PetproShopConnectionDB();
// return db.Query<SanPham>("select * From SanPham where MaNSX='" + id + "'");
//}
//--------------Admin
public static void ThemHD(ThanhToan tt)
{
var db = new PetproShopConnectionDB();
db.Insert(tt);
}
public static void UpdateHD(String id, ThanhToan tt)
{
var db = new PetproShopConnectionDB();
db.Update(tt, id);
}
public async Task <long> VanThuRaSoatHoSo(VanThuRaSoatHoSo37Input input)
{
var hoso = await _hoSoRepos.FirstOrDefaultAsync(x => x.Id == input.HoSoId);
var hsxl = await _hoSoXuLyRepos.FirstOrDefaultAsync(x => x.Id == input.HoSoXuLyId);
if (hoso != null && hsxl != null)
{
if (input.TrangThaiXuLy == (int)CommonENum.KET_QUA_XU_LY.DAT)
{
if (hoso.IsHoSoBS != true)
{
int tenantId = GetTenantIdFromHoSo(hoso);
var thanhToan = new ThanhToan()
{
HoSoId = hoso.Id,
DoanhNghiepId = hoso.DoanhNghiepId,
PhiDaNop = input.PhiDaNop,
NgayGiaoDich = DateTime.Now,
PhiXacNhan = input.PhiDaNop,
TenantId = tenantId,
PhanHeId = _thuTucId,
TrangThaiNganHang = (int)CommonENum.TRANG_THAI_GIAO_DICH.GIAO_DICH_THANH_CONG
};
hoso.ThanhToanId_Active = await _thanhToanRepos.InsertAndGetIdAsync(thanhToan);
}
hoso.TrangThaiHoSo = (int)CommonENum.TRANG_THAI_HO_SO.CHO_TRA_GIAY_TIEP_NHAN;
hsxl.VanThuId = _session.UserId;
hsxl.DonViGui = (int)CommonENum.DON_VI_XU_LY.MOT_CUA_TIEP_NHAN;
hsxl.NguoiGuiId = SessionCustom.UserCurrent.Id;
hsxl.DonViXuLy = (int)CommonENum.DON_VI_XU_LY.MOT_CUA_TIEP_NHAN;
hsxl.NguoiXuLyId = SessionCustom.UserCurrent.Id;
hsxl.NgayGui = DateTime.Now;
await _hoSoRepos.UpdateAsync(hoso);
await _hoSoXuLyRepos.UpdateAsync(hsxl);
}
else if (input.TrangThaiXuLy == (int)CommonENum.KET_QUA_XU_LY.KHONG_DAT)
{
hsxl.DonViGui = (int)CommonENum.DON_VI_XU_LY.MOT_CUA_TIEP_NHAN;
hsxl.NguoiGuiId = SessionCustom.UserCurrent.Id;
hsxl.DonViXuLy = (int)CommonENum.DON_VI_XU_LY.DOANH_NGHIEP;
hsxl.LyDoTraLai = input.LyDoTuChoi;
hsxl.NgayGui = DateTime.Now;
hsxl.VanThuId = _session.UserId;
hoso.TrangThaiHoSo = (int)CommonENum.TRANG_THAI_HO_SO.MOT_CUA_TRA_LAI;
await _hoSoRepos.UpdateAsync(hoso);
await _hoSoXuLyRepos.UpdateAsync(hsxl);
}
#region Lưu lịch sử
var _history = new XHoSoXuLyHistory();
_history.HoSoId = hoso.Id;
_history.HoSoXuLyId = hsxl.Id;
_history.LoaiHoSoId = hoso.LoaiHoSoId;
_history.NguoiXuLyId = SessionCustom.UserCurrent.Id;
_history.DonViXuLy = (int)CommonENum.DON_VI_XU_LY.MOT_CUA_TIEP_NHAN;
_history.ActionEnum = (int)CommonENum.FORM_FUNCTION.MOT_CUA_RA_SOAT_HO_SO;
_history.NgayXuLy = DateTime.Now;
var _historyId = _hoSoXuLyHistoryRepos.InsertOrUpdateAndGetId(_history);
#endregion
}
return(hoso.Id);
}
//Lấy danh sách phòng vé
public async Task <object> LayDanhSachPhongVe(int maLichChieu)
{
using (var connection = new SqlConnection(connectionString))
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
if (maLichChieu == 0)
{
return(await thongBaoLoi.thongBaoLoi(ThongBaoLoi.Loi500, "Mã lịch chiếu không hợp lệ!"));
}
LichChieu lichChieu = connection.QuerySingleOrDefault <LichChieu>("SELECT * FROM [dbo].[View_LICH_CHIEU_COMMON] " +
"WHERE MaLichChieu = " + maLichChieu, commandType: CommandType.Text);
if (lichChieu == null)
{
return(await thongBaoLoi.thongBaoLoi(ThongBaoLoi.Loi500, "Mã lịch chiếu không tồn tại!"));
}
decimal giaVe = lichChieu.GiaVe;
var listDanhSachGheDuocDat = connection.Query <Ve>("SELECT * FROM [dbo].[VE] " +
"WHERE MaLichChieu = " + maLichChieu, commandType: CommandType.Text);
bool flag = false;
LichChieuTheoRapViewModel rap = new LichChieuTheoRapViewModel();
List <GheTheoHangVM> listGhe = new List <GheTheoHangVM>();
int?MaRap = lichChieu.MaRap;
IEnumerable <Ghe> listGheTheoRap = connection.Query <Ghe>("SELECT * FROM [dbo].[GHE] WHERE MaRap = " + lichChieu.MaRap, commandType: CommandType.Text);
IEnumerable <LoaiGhe> listLoaiGhe = connection.Query <LoaiGhe>("SELECT * FROM dbo.LOAIGHE", commandType: CommandType.Text);
IEnumerable <ThanhVien> listThanhVien = connection.Query <ThanhVien>("SELECT * FROM dbo.THANHVIEN", commandType: CommandType.Text);
IEnumerable <ThanhToan> listThanhToan = connection.Query <ThanhToan>("SELECT * FROM dbo.PHIEUTHANHTOAN", commandType: CommandType.Text);
foreach (var phongRap in listGheTheoRap.GroupBy(n => new { n.TenHang })) //Lấy ra rạp đang chiếu
{
GheTheoHangVM gheTheoHang = new GheTheoHangVM();
gheTheoHang.TenHang = phongRap.Key.TenHang;
foreach (var pr in phongRap)
{
flag = false;
GheViewModel ghe = new GheViewModel();
LoaiGhe loaiGhe = new LoaiGhe();
loaiGhe = listLoaiGhe.Single(n => n.MaLoaiGhe == pr.MaLoaiGhe);
ghe.MaRap = pr.MaRap;
// (phongRap.MaLoaiGheNavigation.ChietKhau * giaVe) / 100 +
int phuThu = loaiGhe.PhuThu;
ghe.GiaVe = (phuThu * giaVe) / 100 + giaVe;
ghe.LoaiGhe = loaiGhe.TenLoaiGhe;
ghe.MaGhe = pr.MaGhe;
ghe.TenGhe = pr.TenGhe;
ghe.STT = pr.SoThuTu;
ghe.PhuThu = phuThu;
foreach (var rapDatVe in listDanhSachGheDuocDat) //Lấy ra danh sách ghế được đặt
{
//ghe.TaiKhoanNguoiDat= connection.QuerySingleOrDefault<string>("SELECT TaiKhoan FROM [dbo].[THANHVIEN] WHERE TaiKhoan = '" + rapDatVe.TaiKhoan + "'", commandType: CommandType.Text);
if (pr.MaGhe == rapDatVe.MaGhe && !rapDatVe.TrangThaiHuy)
{
ThanhToan thanhToan = listThanhToan.Single(n => n.MaThanhToan == rapDatVe.MaThanhToan);
ThanhVien tv = listThanhVien.Single(n => n.MaThanhVien == thanhToan.MaThanhVien);
ghe.TaiKhoanNguoiDat = tv.TaiKhoan;
flag = true;
}
}
if (flag == true)
{
ghe.DaDat = true;
}
gheTheoHang.DanhSachGheTheoHang.Add(ghe);
}
listGhe.Add(gheTheoHang);
}
rap.DanhSachGhe = listGhe;
rap.ThongTinPhim.NgayChieu = lichChieu.NgayChieuGioChieu.ToString("dd/MM/yyyy");
rap.ThongTinPhim.GioChieu = lichChieu.NgayChieuGioChieu.ToString("HH:mm");
//rap.ThongTinPhim.hinhAnh = DomainImage + LichChieu.MaPhimNavigation.HinhAnh;
rap.ThongTinPhim.MaLichChieu = maLichChieu;
rap.ThongTinPhim.TenRap = connection.QuerySingleOrDefault <string>("SELECT TenRap FROM [dbo].[RAP] WHERE MaRap = '" + lichChieu.MaRap + "'", commandType: CommandType.Text);
rap.ThongTinPhim.TenCumRap = connection.QuerySingleOrDefault <string>("SELECT TenCumRap FROM [dbo].[CUMRAP] WHERE MaCumRap = '" + lichChieu.MaCumRap + "'", commandType: CommandType.Text);
rap.ThongTinPhim.DiaChi = connection.QuerySingleOrDefault <string>("SELECT ThongTin FROM [dbo].[CUMRAP] WHERE MaCumRap = '" + lichChieu.MaCumRap + "'", commandType: CommandType.Text);
var phim = connection.QuerySingleOrDefault <Phim>("SELECT * FROM [dbo].[PHIM] WHERE MaPhim = '" + lichChieu.MaPhim + "'", commandType: CommandType.Text);
rap.ThongTinPhim.TenPhim = phim.TenPhim;
rap.ThongTinPhim.DoTuoi = phim.DoTuoi;
return(rap);
}
}
public ActionResult TaoBaoCao(ThanhToanViewModel thanhToanVm, string TenNXB)
{
if (Request.Form["analyze"] != null)
{
if (ModelState.IsValid)
{
var nxb = nxbService.GetSingleByName(TenNXB);
if (nxb == null)
{
ModelState.AddModelError("", "Thông tin nhà xuất bản không tồn tại.");
}
else
{
thanhToanVm.IdNXB = nxb.Id;
var ngayBatDau = thanhToanService.GetStartDateToCreateReport(nxb.Id);
if (ngayBatDau != null)
{
if (ngayBatDau <= thanhToanVm.NgayKetThuc)
{
thanhToanVm.NgayBatDau = ngayBatDau.Value;
}
else
{
ModelState.AddModelError("", "Thời gian báo cáo không hợp lệ.");
return(View(thanhToanVm));
}
}
else
{
var ngayBatDauTaoPhieuXuat = phieuNhapService.GetFirstDateToCreateReport(nxb.Id).Value;
if (ngayBatDauTaoPhieuXuat != null)
{
if (ngayBatDauTaoPhieuXuat <= thanhToanVm.NgayKetThuc)
{
thanhToanVm.NgayBatDau = ngayBatDauTaoPhieuXuat;
}
else
{
ModelState.AddModelError("", "Thời gian báo cáo không hợp lệ.");
return(View(thanhToanVm));
}
}
else
{
ModelState.AddModelError("", "Chưa nhập sách từ NXB này, không thể lập báo cáo.");
return(View(thanhToanVm));
}
}
var listThongKe = thanhToanService.GetListAnalysisReport(thanhToanVm.IdNXB, thanhToanVm.NgayBatDau, thanhToanVm.NgayKetThuc);
if (listThongKe.Count == 0)
{
ModelState.AddModelError("", "Chưa nhập hàng từ nhà xuất bản này.");
}
else if (thanhToanService.CheckReportIsCreated(thanhToanVm.IdNXB, thanhToanVm.NgayBatDau))
{
ModelState.AddModelError("", "Khoảng thời gian đã được lập báo cáo rồi.");
}
else
{
// Clear at the second click
Session["ThanhToan"] = null;
// Add new value for session
thanhToanVm.NhaXuatBan = Mapper.Map <NhaXuatBan, NhaXuatBanViewModel>(nxb);
thanhToanVm.dsThongKeNXB = listThongKe;
foreach (var ct in listThongKe)
{
thanhToanVm.TongTienConNo += ct.TongTienNo;
if (ct.TongTienXuat != null)
{
thanhToanVm.TongTienSachBan += (double)ct.TongTienXuat;
}
}
Session["ThanhToan"] = thanhToanVm;
}
}
}
}
else if (Request.Form["create"] != null)
{
var tt = (ThanhToanViewModel)Session["ThanhToan"];
var newThanhToan = new ThanhToan();
newThanhToan.UpdateThanhToan(tt);
newThanhToan.TongTienConNo += tt.TienNoThangTruoc;
newThanhToan.IdTinhTrang = CommonConstant.DA_BAO_CAO;
newThanhToan.NgayXacNhan = newThanhToan.ThoiGianLapPhieu;
thanhToanService.Add(newThanhToan);
thanhToanService.Save();
foreach (var ct in tt.dsThongKeNXB)
{
if (ct.SoLuongXuat == null)
{
ct.TongTienXuat = 0;
ct.SoLuongXuat = 0;
}
var ctThanhToan = new CtThanhToan
{
IdSach = ct.Id,
IdThanhToan = newThanhToan.Id,
SoLuongNhap = ct.SoLuongNhap,
SoLuongTonDotTruoc = ct.SoLuongTonDotTruoc,
TongTienNhap = ct.TongTienNhap,
SoLuongXuat = ct.SoLuongXuat,
TongTienXuat = ct.TongTienXuat,
SoLuongCon = (ct.SoLuongNhap + ct.SoLuongTonDotTruoc) - ct.SoLuongXuat,
TienNo = ct.TongTienNo,
DonGiaNhap = ct.DonGiaNhap
};
ctThanhToanService.Add(ctThanhToan);
}
thanhToanService.Save();
Session["ThanhToan"] = null;
TempData["Success"] = "Đã thêm thành công một báo cáo NXB.";
Session.RemoveAll();
return(Redirect("/bao-cao/nxb/"));
}
return(View(thanhToanVm));
}
//public Task<string> CreateDeXuat(CreateDeXuatRequest request)
//{
//}
public async Task <string> CreateDeXuat(CreateDeXuatRequest request)
{
var SoLuongNhanVien = from NV in _context.nhanVienCongTacs
where NV.MaChuyenCongTac == request.MaChuyenCongTac
select NV.MaNhanVien;
var SoluongHoaDon = from HD in _context.thanhToans
select HD.MaHoaDon;
var SoDeXuat = from HD in _context.deXuatThanhToans
select HD.MaDeXuat;
var chuyenCongTac = await _context.chuyenCongTacs.FindAsync(request.MaChuyenCongTac);
var checkCCT = from DX in _context.deXuatThanhToans
select DX;
foreach (var item in checkCCT)
{
if (item.MaChuyenCongTac == request.MaChuyenCongTac)
{
return(null);
}
}
if (chuyenCongTac.TrangThai == "Chua thuc hien")
{
throw new TLUException("Chuyến Công tác chua xong không thể de xuat thanh toan");
}
string soLuongDeXuat = SoDeXuat.Count().ToString();
do
{
soLuongDeXuat = (Convert.ToInt32(soLuongDeXuat) + 1).ToString();
}while (_context.deXuatThanhToans.Find("DX" + soLuongDeXuat) != null);
var DeXuat = new DeXuatThanhToan()
{
MaDeXuat = "DX" + soLuongDeXuat,
MaChuyenCongTac = request.MaChuyenCongTac,
SoNhanVien = SoLuongNhanVien.Count(),
TinhTrang = "Chua xet duyet",
MaNhanVien = request.NhanVienDeXuat,
TongTien = request.TongTien,
ThoiGianDeXuat = DateTime.Now
};
//var ChuyenCongTacdf = await _context.chuyenCongTacs.FirstOrDefaultAsync
// (x => x.MaChuyenCongTac == request.MaChuyenCongTac);
//ChuyenCongTacdf.TrangThai = "Da thuc hien";
string soLuongHoaDon = SoluongHoaDon.Count().ToString();
do
{
soLuongHoaDon = (Convert.ToInt32(soLuongHoaDon) + 1).ToString();
}while (_context.deXuatThanhToans.Find("HD" + soLuongHoaDon) != null);
var ThanhToan = new ThanhToan()
{
MaHoaDon = "HD" + soLuongHoaDon,
MaDeXuat = DeXuat.MaDeXuat,
ThoiGianDeXuat = DeXuat.ThoiGianDeXuat,
TinhTrang = "Chua xet duyet",
TongChiPhi = request.TongTien
};
//if (FileHoaDon != null)
//{
// DeXuat.deXuatFiles = new List<DeXuatFile>()
// {
// new DeXuatFile()
// {
// FilePath= await this.SaveFile(FileHoaDon)
// }
// };
//}
await _context.deXuatThanhToans.AddAsync(DeXuat);
await _context.thanhToans.AddAsync(ThanhToan);
await _context.SaveChangesAsync();
return(DeXuat.MaDeXuat);
}
public ActionResult AddDonHang(DonHang dh, string AddTaiKhoan)
{
using (DBNoiThat db = new DBNoiThat())
{
try
{
dh.ThoiGian = DateTime.Now.ToString("dd/MM/yyyy");
dh.TinhTrangThanhToan = 0;
dh.TinhTrangGiaoHang = 0;
ThanhToan tt = (ThanhToan)Session["thanhtoan"];
dh.TongTien = tt.CanThanhToan;
dh.DaGiamGia = tt.GiamGia;
db.DonHangs.Add(dh);
db.SaveChanges();
foreach (SanPhamCart item in (List <SanPhamCart>)Session["cart"])
{
ChiTietDonHang ct = new ChiTietDonHang();
ct.IDSanPham = item.ID;
ct.IDDonHang = db.DonHangs.OrderByDescending(p => p.ID).FirstOrDefault().ID;
ct.SoLuong = item.SoLuong;
ct.DonGia = item.Gia;
ct.ThanhTien = item.SoLuong * item.Gia;
db.ChiTietDonHangs.Add(ct);
db.SaveChanges();
}
if (AddTaiKhoan == "Add" && db.TaiKhoans.Where(p => p.Email == dh.Email).FirstOrDefault() == null)
{
DBNoiThat_User db_u = new DBNoiThat_User();
NoiThat_v2._0.Models.TaiKhoan tk = new NoiThat_v2._0.Models.TaiKhoan();
tk.Email = dh.Email;
tk.HoTen = dh.HoTen;
tk.DiaChi = dh.DiaChiGiaoHang;
tk.Sdt = dh.Sdt;
Random r = new Random();
tk.Salt = r.Next(100, 1000);
tk.MatKhau = GetMD5(dh.Sdt + tk.Salt.ToString());
tk.XacNhanMatKhau = tk.MatKhau;
tk.IDQuyen = 2;
db_u.TaiKhoans.Add(tk);
db.SaveChanges();
tk = db_u.TaiKhoans.Where(p => p.Email == tk.Email).FirstOrDefault();
Session.Add("user", tk);
}
Session.Remove("cart");
Session.Remove("thanhtoan");
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
}
public frmThanhToanPDH()
{
InitializeComponent();
DGV_ThanhToan.DataSource = ThanhToan.GetAllHoaDon();
}
public void Update(ThanhToan thanhToan)
{
thanhToanRepository.Update(thanhToan);
}
public ThanhToan Delete(ThanhToan thanhToan)
{
return(thanhToanRepository.Delete(thanhToan));
}
public ThanhToan Add(ThanhToan thanhToan)
{
return(thanhToanRepository.Add(thanhToan));
}
public static bool updatePTTT(ThanhToan thanhtoan)
{
return(ThanhToan_DB.updateThanhToan(thanhtoan));
}
public static bool insertPTTT(ThanhToan thanhtoan)
{
return(ThanhToan_DB.insertThanhToan(thanhtoan));
}
public ActionResult AddToCart(int ID)
{
using (DBNoiThat db = new DBNoiThat())
{
if (Session["cart"] == null)
{
List <SanPhamCart> cart = new List <SanPhamCart>();
SanPhamCart sp = (from s in db.SanPhams
join n in db.NhaCungCaps on s.IDNCC equals n.ID
join d in db.DanhMucSanPhams on s.IDDanhMucSP equals d.ID
join nh in db.NhomSanPhams on d.IDNhomSP equals nh.ID
where (s.ID == ID)
select new SanPhamCart
{
ID = s.ID,
Ten = s.Ten,
Gia = s.Gia,
Mota = s.MoTa,
PathImg = "/storage/" + nh.Ten_slug + "/" + d.Ten_slug + "/" + s.Ten_img
}).FirstOrDefault();
sp.SoLuong = 1;
cart.Add(sp);
Session["cart"] = cart;
ThanhToan tt = new ThanhToan();
tt.TongTien = sp.Gia;
tt.GiamGia = 0;
tt.CanThanhToan = tt.TongTien;
Session["thanhtoan"] = tt;
}
else
{
List <SanPhamCart> cart = (List <SanPhamCart>)Session["cart"];
SanPhamCart sp = cart.Where(p => p.ID == ID).FirstOrDefault();
if (sp != null)
{
sp.SoLuong = sp.SoLuong + 1;
}
else
{
sp = (from s in db.SanPhams
join n in db.NhaCungCaps on s.IDNCC equals n.ID
join d in db.DanhMucSanPhams on s.IDDanhMucSP equals d.ID
join nh in db.NhomSanPhams on d.IDNhomSP equals nh.ID
where (s.ID == ID)
select new SanPhamCart
{
ID = s.ID,
Ten = s.Ten,
Gia = s.Gia,
PathImg = "/storage/" + nh.Ten_slug + "/" + d.Ten_slug + "/" + s.Ten_img
}).FirstOrDefault();
sp.SoLuong = 1;
cart.Add(sp);
}
ThanhToan tt = (ThanhToan)Session["thanhtoan"];
tt.TongTien = tt.TongTien + sp.Gia;
tt.CanThanhToan = tt.TongTien - tt.GiamGia;
Session["thanhtoan"] = tt;
}
}
return(RedirectToAction("Index", "TrangChu"));
}
protected override void Render(HtmlTextWriter writer)
{
StringBuilder sb = new StringBuilder();
ClientScriptManager cs = this.Page.ClientScript;
#region Tham số
string _ID = Request["ID"];
string _SoDu = Request["SoDu"];
string _Duyet = Request["Duyet"];
string _DaChuyenTien = Request["DaChuyenTien"];
string _MoTa = Request["MoTa"];
string _q = Request["q"];
List<jgridRow> ListRow = new List<jgridRow>();
ThanhToan Item;
TaiKhoan ItemTk;
string Username = Security.Username;
bool logged = Security.IsAuthenticated();
sendEmailDele _dele = new sendEmailDele(sendmailThongbao);
#endregion
switch (subAct)
{
case "get":
#region lấy dữ liệu cho grid
if (string.IsNullOrEmpty(jgrsidx)) jgrsidx = "ID";
if (string.IsNullOrEmpty(jgrsord)) jgrsord = "asc";
Pager<ThanhToan> PagerGet = ThanhToanDal.pagerByUser("T_" + jgrsidx + " " + jgrsord, Convert.ToInt32(jgRows), Username);
foreach (ThanhToan item in PagerGet.List)
{
ListRow.Add(new jgridRow(item.ID.ToString(),
new string[] {
item.ID.ToString(),
item.SoDu.ToString("C",new CultureInfo("vi-Vn")),
item.NgayTao.ToString("hh:mm dd/MM/yy"),
string.Format(@"<input disabled=""disabled"" type=""checkbox"" {0}/> {1}",item.Duyet ? @" checked=""checked""" : @"class=""yctt-unchecked""",item.Duyet ? "" : string.Format(@"- <a href=""javascript:;"" onclick=""ThanhToanMgrthongTinFn.edit1('{0}')"">Sửa</a>",item.ID))
}));
}
jgrid grid = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage, PagerGet.TotalPages.ToString(), PagerGet.Total.ToString(), ListRow);
sb.Append(JavaScriptConvert.SerializeObject(grid));
break;
#endregion
case "saveSoDu":
#region lưu
if (!MemberDal.SelectChungThuc(Username))
{
_dele.BeginInvoke("*****@*****.**"
, string.Format("potbai - Yeu cau chung thuc: {0} - {1}", Username, DateTime.Now.ToString("hh:mm-dd/MM/yy"))
, string.Format("Username:{0}<br/>So du:{1}<br/>Date:{2}<br/>IP:{3}", Username, _SoDu, DateTime.Now.ToString("hh:mm-dd/MM/yy"), Request.UserHostAddress)
, null, null);
sb.Append("-1");
}
else
{
if (!string.IsNullOrEmpty(_ID))
{
Item = ThanhToanDal.SelectById(Convert.ToInt32(_ID));
}
else
{
Item = new ThanhToan();
}
if (!string.IsNullOrEmpty(_Duyet))
{
Item.Duyet = Convert.ToBoolean(_Duyet);
}
if (!string.IsNullOrEmpty(_DaChuyenTien))
{
Item.DaChuyenTien = Convert.ToBoolean(_DaChuyenTien);
}
Item.SoDu = Convert.ToInt32(_SoDu);
if (!string.IsNullOrEmpty(_ID))
{
Item = ThanhToanDal.Update(Item);
_dele.BeginInvoke("*****@*****.**"
, string.Format("potbai - Yeu cau thanh toan sua: {0} - {1}", Username, DateTime.Now.ToString("hh:mm-dd/MM/yy"))
, string.Format("ID:{4}<br/>Username:{0}<br/>SoDu:{1}<br/>Date:{2}<br/>IP:{3}", Username, Item.SoDu, DateTime.Now.ToString("hh:mm-dd/MM/yy"), Request.UserHostAddress, Item.ID)
, null, null);
}
else
{
Item.NguoiYeuCau = Security.Username;
Item.NgayTao = DateTime.Now;
Item = ThanhToanDal.Insert(Item);
_dele.BeginInvoke("*****@*****.**"
, string.Format("potbai - Yeu cau thanh toan moi: {0} - {1}", Username, DateTime.Now.ToString("hh:mm-dd/MM/yy"))
, string.Format("ID:{4}<br/>Username:{0}<br/>SoDu:{1}<br/>Date:{2}<br/>IP:{3}", Username, Item.SoDu, DateTime.Now.ToString("hh:mm-dd/MM/yy"), Request.UserHostAddress,Item.ID)
, null, null);
}
sb.Append("1");
}
break;
#endregion
case "saveTaiKhoan":
#region lưu
TaiKhoanDal.UpdateThongTinByUser(new TaiKhoan()
{
Username = Username,
ThongTin = _MoTa
});
sb.Append("1");
break;
#endregion
case "editSoDu":
#region chỉnh sửa
if (!string.IsNullOrEmpty(_ID))
{
Item = ThanhToanDal.SelectById(Convert.ToInt32(_ID));
if (!Item.Duyet)
{
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(Item));
}
else
{
sb.Append("0");
}
}
break;
#endregion
case "editTaiKhoan":
#region chỉnh sửa
sb.Append(TaiKhoanDal.SelectByUsername(Security.Username, DAL.con()).ThongTin);
break;
#endregion
case "del":
#region xóa
if (!string.IsNullOrEmpty(_ID))
{
Item = ThanhToanDal.SelectById(Convert.ToInt32(_ID));
if (!Item.Duyet)
{
LinkDal.DeleteById(Item.ID);
}
}
break;
#endregion
case "scpt":
#region Nạp js
sb.AppendFormat(@"{0}"
, cs.GetWebResourceUrl(typeof(Class1), "seo.plugin.thanhToanMgr.thongTin.JScript1.js"));
break;
#endregion
default:
#region nạp
FunctionCollection ListFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId);
if (!logged)
{
renderText("un-authorized", "text/plain");
}
double total = 0;
TaiKhoan tkItem = TaiKhoanDal.SelectByUsername(Username, DAL.con());
if(!string.IsNullOrEmpty(tkItem.Tk))
{
total = Convert.ToDouble(maHoa.DecryptString(tkItem.Tk, Username));
}
sb.AppendFormat(@"
<div class=""mdl-head"">
<a class=""mdl-head-btn mdl-head-del"" id=""ThanhToanMgrthongTin-tkBtn"" _value=""{1}"" href=""javascript:;"">Số dư: {0}</a>
<a class=""mdl-head-btn mdl-head-del"" id=""ThanhToanMgrthongTin-thanhToanBtn"" href=""javascript:;"" onclick=""ThanhToanMgrthongTinFn.add1();"">Yêu cầu thanh toán</a>
<a class=""mdl-head-btn mdl-head-del"" id=""ThanhToanMgrthongTin-thongTinBtn"" href=""javascript:;"" onclick=""ThanhToanMgrthongTinFn.edit2();"">Thông tin thanh toán</a>
</div>
<table id=""ThanhToanMgrthongTin-List"" class=""mdl-list""></table>
<div id=""ThanhToanMgrthongTin-Pager""></div>
", total.ToString("C", new CultureInfo("vi-Vn")),total);
sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>"
, cs.GetWebResourceUrl(typeof(Class1), "seo.plugin.thanhToanMgr.thongTin.JScript1.js")
, "{ThanhToanMgrthongTinFn.loadgrid();}");
sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(ListFn));
break;
#endregion
}
writer.Write(sb.ToString());
base.Render(writer);
}
