public async Task <PagedResultDto <LoaiHoSoDto> > GetAllServerPaging(LoaiHoSoInputDto input) { var query = (from lhs in _LoaiHoSoRepos.GetAll() select new LoaiHoSoDto { Id = lhs.Id, TenLoaiHoSo = lhs.TenLoaiHoSo, IsActive = lhs.IsActive, MoTa = lhs.MoTa, IsXuLy = lhs.IsXuLy, QuiTrinhXuLy = lhs.QuiTrinhXuLy, PhiXuLy = lhs.PhiXuLy, SoNgayXuLy = lhs.SoNgayXuLy, DataImage = lhs.DataImage, ThuTucId = lhs.ThuTucId, IsCoChiTieu = lhs.IsCoChiTieu, NiisId = lhs.NiisId, SoNgaySuaDoiBoSung = lhs.SoNgaySuaDoiBoSung }) .WhereIf(!string.IsNullOrEmpty(input.Filter), u => u.TenLoaiHoSo.LocDauLowerCaseDB().Contains(input.Filter.Trim().LocDauLowerCaseDB()) || u.MoTa.LocDauLowerCaseDB().Contains(input.Filter.Trim().LocDauLowerCaseDB())); var LoaiHoSoCount = await query.CountAsync(); var LoaiHoSoGrids = await query .OrderBy(p => p.Id) .PageBy(input) .ToListAsync(); foreach (var item in LoaiHoSoGrids) { item.TenThuTuc = item.ThuTucId != null?CommonENum.GetEnumDescription((CommonENum.THU_TUC_ID)(int) item.ThuTucId) : ""; } return(new PagedResultDto <LoaiHoSoDto>(LoaiHoSoCount, LoaiHoSoGrids)); }
public string SinhSoDangKy(long doanhNghiepId, int thuTucId = 0) { try { CommonENum.THU_TUC_ID thuTuc = CommonENum.THU_TUC_ID.THU_TUC_99; if (thuTucId > 0) { thuTuc = (CommonENum.THU_TUC_ID)thuTucId; } string strThuTuc = ""; var res = string.Empty; if (doanhNghiepId > 0) { var doanhNghiepKySoNam = _doanhNghiepRepos.FirstOrDefault(x => x.NamCA == DateTime.Now.Year && x.Id == doanhNghiepId); if (doanhNghiepKySoNam != null) { strThuTuc = CommonENum.GetEnumDescription(thuTuc); var soMoi = SoDangKyMax(doanhNghiepKySoNam, thuTuc) + 1; res = string.Format("{0}/{1}/{2}", soMoi, doanhNghiepKySoNam.MaSoThue, DateTime.Now.Year); UpdateSoDangKyMax(ref doanhNghiepKySoNam, thuTuc, soMoi); _doanhNghiepRepos.Update(doanhNghiepKySoNam); } else { var doanhNghiepNull = _doanhNghiepRepos.FirstOrDefault(x => x.Id == doanhNghiepId); doanhNghiepNull.NamCA = DateTime.Now.Year; #region UpDate Số Thủ tục doanhNghiepNull.SoThuTuc0CA = 0; doanhNghiepNull.SoThuTuc1CA = 0; doanhNghiepNull.SoThuTuc2CA = 0; doanhNghiepNull.SoThuTuc3CA = 0; doanhNghiepNull.SoThuTuc4CA = 0; doanhNghiepNull.SoThuTuc5CA = 0; doanhNghiepNull.SoThuTuc6CA = 0; doanhNghiepNull.SoThuTuc7CA = 0; doanhNghiepNull.SoThuTuc8CA = 0; doanhNghiepNull.SoThuTuc9CA = 0; doanhNghiepNull.SoThuTuc10CA = 0; #endregion strThuTuc = CommonENum.GetEnumDescription(thuTuc); var soMoi = 1; res = string.Format("{0}/{1}/{2}", soMoi, doanhNghiepNull.MaSoThue, DateTime.Now.Year); UpdateSoDangKyMax(ref doanhNghiepNull, thuTuc, 1); _doanhNghiepRepos.Update(doanhNghiepNull); } } return(res); } catch (Exception ex) { throw ex; } }
public async Task <List <ThanhToanDto> > GetListThanhToanByHoSoId(int thuTucId = 0, long hoSoId = 0) { try { var query = (from tt in _thanhToanRepos.GetAll() where tt.PhanHeId == thuTucId && tt.HoSoId == hoSoId select new ThanhToanDto { PhanHeId = tt.PhanHeId, Id = tt.Id, DoanhNghiepId = tt.DoanhNghiepId, HoSoId = tt.HoSoId, GhiChu = tt.GhiChu, KenhThanhToan = tt.KenhThanhToan, PhiDaNop = tt.PhiDaNop, PhiXacNhan = tt.PhiXacNhan, SoTaiKhoanNop = tt.SoTaiKhoanNop, SoTaiKhoanHuong = tt.SoTaiKhoanHuong, MaGiaoDich = tt.MaGiaoDich, MaDonHang = tt.MaDonHang, NgayGiaoDich = tt.NgayGiaoDich, TrangThaiKeToan = tt.TrangThaiKeToan, TrangThaiNganHang = tt.TrangThaiNganHang, TenantId = tt.TenantId, KetQuaGiaoDichJson = tt.KetQuaGiaoDichJson, LyDoHuyThanhToan = tt.LyDoHuyThanhToan, RequestJson = tt.RequestJson, ResponseJson = tt.ResponseJson, ArrHoSoId = tt.ArrHoSoId }); var listTT = await query .OrderBy(x => x.NgayGiaoDich) .ToListAsync(); foreach (var item in listTT) { if (item.KenhThanhToan.HasValue) { var kenhThanhToan = (CommonENum.KENH_THANH_TOAN)item.KenhThanhToan; item.StrKenhThanhToan = CommonENum.GetEnumDescription(kenhThanhToan); } var trangThai = (CommonENum.TRANG_THAI_GIAO_DICH)item.TrangThaiNganHang; item.StrTrangThaiNganHang = CommonENum.GetEnumDescription(trangThai); item.StrNgayGiaoDich = item.NgayGiaoDich.HasValue ? item.NgayGiaoDich.Value.ToString("yyyyMMdd") : string.Empty; } return(listTT); } catch (Exception ex) { throw ex; } }
public List <ItemObj <int> > GetVaiTroThamDinhToDDL() { var _list = new List <ItemObj <int> >(); foreach (object iEnumItem in Enum.GetValues(typeof(CommonENum.VAI_TRO_THAM_DINH))) { int iEnum = Convert.ToInt32(iEnumItem); _list.Add(new ItemObj <int> { Id = (int)iEnumItem, Name = CommonENum.GetEnumDescription((Enum)Enum.ToObject(typeof(CommonENum.VAI_TRO_THAM_DINH), iEnum)) }); } return(_list); }
public List <ItemObj <int> > GetListChucVuByLoaiTK(int loaiTK) { var ro_level = GetROLE_LEVELs((LOAI_TAI_KHOAN)loaiTK); var _list = new List <ItemObj <int> >(); foreach (var item in ro_level) { _list.Add(new ItemObj <int>() { Id = (int)item, Name = CommonENum.GetEnumDescription(item) }); } return(_list); }
public async Task GuiMailThongBaoBoSungHoSo(long hoSoId) { try { var hoso = await _hoSoRepos.GetAsync(hoSoId); var hosoxl = await _hoSoXuLyRepos.GetAsync(hoso.HoSoXuLyId_Active.Value); var subject = "Thông báo bổ sung hồ sơ"; var tenancyName = GetTenancyNameOrNull(_session.TenantId); var thuTucStr = CommonENum.GetEnumDescription((CommonENum.THU_TUC_TEXT)hoso.ThuTucId); var emailTemplate = new StringBuilder(_emailTemplateProvider.GetDefaultTemplate(_session.TenantId)); emailTemplate.Replace("{EMAIL_TITLE}", "Thông báo"); emailTemplate.Replace("{EMAIL_SUB_TITLE}", "Cục quản lý Y Dược cổ truyền Hà Nội thông báo"); var doanhNghiep = await _doanhNghiepRepos.GetAsync(hoso.DoanhNghiepId.Value); var link = _webUrlService.GetSiteRootAddress(tenancyName); var linkViewCongVan = _webUrlService.GetSiteRootAddress(tenancyName) + "File/GoToViewTaiLieu?url=" + hosoxl.DuongDanTepCA; var mailMessage = new StringBuilder(); mailMessage.AppendLine("<b>" + "Yêu cầu " + doanhNghiep.TenDoanhNghiep + " chỉnh sửa bổ sung hồ sơ " + hoso.MaHoSo + " của thủ tục " + thuTucStr + "</b>" + "<br />"); if (!String.IsNullOrEmpty(hosoxl.DuongDanTepCA)) { mailMessage.AppendLine("<b>" + "Nội dung yêu cầu bổ sung vui lòng xem chi tiết tại công văn yêu cầu bổ sung" + "</b>" + "<br />"); mailMessage.AppendLine("Click vào link phía dưới để xem công văn yêu cầu bổ sung" + "<br />"); mailMessage.AppendLine("<a href=\"" + linkViewCongVan + "\">" + linkViewCongVan + "</a>"); mailMessage.AppendLine("<br />"); } mailMessage.AppendLine("Click vào link phía dưới để đăng nhập vào hệ thống" + "<br />"); mailMessage.AppendLine("<a href=\"" + link + "\">" + link + "</a>"); emailTemplate.Replace("{EMAIL_BODY}", mailMessage.ToString()); await _emailSender.SendAsync(doanhNghiep.EmailDoanhNghiep, subject, emailTemplate.ToString()); } catch (Exception ex) { Logger.Error($"{DateTime.Now.ToString("HH:mm:ss dd/MM/yyyy")} GuiMailThongBaoBoSungHoSo {ex.Message} {JsonConvert.SerializeObject(ex)}"); } }
public List <ItemObj <int> > GetListFormCaseDoanhNghiep() { try { var _list = new List <ItemObj <int> >(); foreach (object iEnumItem in Enum.GetValues(typeof(CommonENum.FORM_CASE_DOANH_NGHIEP))) { _list.Add(new ItemObj <int> { Id = (int)iEnumItem, Name = CommonENum.GetEnumDescription((CommonENum.FORM_CASE_DOANH_NGHIEP)(int) iEnumItem) }); } return(_list); } catch { return(null); } }
public List <DropDownListOutput> GetTrangThaiTraCuu() { List <DropDownListOutput> objTemList = new List <DropDownListOutput>(); try { foreach (object iEnumItem in Enum.GetValues(typeof(CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37))) { DropDownListOutput objTem = new DropDownListOutput(); objTem.Name = CommonENum.GetEnumDescription((CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37)(int) iEnumItem); objTem.Id = ((int)iEnumItem); objTemList.Add(objTem); } } catch (Exception ex) { Logger.Error($"{DateTime.Now.ToString("HH:mm:ss dd/MM/yyyy")} GetTrangThaiTraCuu {ex.Message} {JsonConvert.SerializeObject(ex)}"); } return(objTemList); }
public async Task <GetCurrentLoginInformationsOutput> GetCurrentLoginInformations() { var output = new GetCurrentLoginInformationsOutput { User = (await GetCurrentUserAsync()).MapTo <UserLoginInfoDto>() }; if (AbpSession.TenantId.HasValue) { output.Tenant = (await GetCurrentTenantAsync()).MapTo <TenantLoginInfoDto>(); } if (output.User.RoleLevel.HasValue) { var roleLevel = (CommonENum.ROLE_LEVEL)output.User.RoleLevel; output.User.RoleLevelName = CommonENum.GetEnumDescription(roleLevel); } if (SessionCustom.UserCurrent != null) { output.User.ThuTucEnum = SessionCustom.UserCurrent.ThuTucEnum; } return(output); }
public async Task <dynamic> QueryBildToKeypay(KeypayDto input) { try { if (input != null && input.TenantId.HasValue && input.ThanhToanId.HasValue) { var res = await _thanhToanKeyPayAppService.QueryBillStatusV2_MD5(input.TenantId.Value, input.Merchant_trans_id, input.Good_code, input.Trans_time); var resSplit = res.Split('|'); string _statusCode = ""; if (resSplit.Length > 2) { _statusCode = resSplit[1]; if (_statusCode == CommonENum.KEYPAY_RESPONSE.THANH_CONG) { var maDonHangSplit = input.Good_code.Split('.'); long hoSoId = Convert.ToInt64(maDonHangSplit.Last()); var maThuTuc = maDonHangSplit.First(); //THU_TUC_99 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_99)) { //await _xuLyHoSoDoanhNghiep99AppService.NopHoSoMoi(hoSoId, true); } #region Thủ Tục hành Chính //THU_TUC_01 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_01)) { //await _xuLyHoSoDoanhNghiep01AppService.NopHoSoMoi(hoSoId, true); } //THU_TUC_02 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_02)) { //await _xuLyHoSoDoanhNghiep02AppService.NopHoSoMoi(hoSoId, true); } //THU_TUC_03 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_03)) { //await _xuLyHoSoDoanhNghiep03AppService.NopHoSoMoi(hoSoId, true); } //THU_TUC_04 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_04)) { //await _xuLyHoSoDoanhNghiep04AppService.NopHoSoMoi(hoSoId, true); } //THU_TUC_05 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_05)) { //await _xuLyHoSoDoanhNghiep05AppService.NopHoSoMoi(hoSoId, true); } //THU_TUC_06 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_06)) { //await _xuLyHoSoDoanhNghiep06AppService.NopHoSoMoi(hoSoId, true); } //THU_TUC_07 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_07)) { //await _xuLyHoSoDoanhNghiep07AppService.NopHoSoMoi(hoSoId, true); } //THU_TUC_08 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_08)) { //await _xuLyHoSoDoanhNghiep08AppService.NopHoSoMoi(hoSoId, true); } //THU_TUC_09 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_09)) { //await _xuLyHoSoDoanhNghiep09AppService.NopHoSoMoi(hoSoId, true); } //THU_TUC_10 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_10)) { //await _xuLyHoSoDoanhNghiep10AppService.NopHoSoMoi(hoSoId, true); } #endregion } } return(new { Status = 1, Data = res, StatusCode = _statusCode }); } return(new { Status = 0, Error = true }); } catch (Exception ex) { throw ex; } }
public async Task <PagedResultDto <XHoSoDto> > GetListHoSoTraCuuPaging(TraCuuHoSoInput input) { try { var query = (from hoso in _hoSoRepos.GetAll() join hsxl in _hoSoXuLyRepos.GetAll() on hoso.HoSoXuLyId_Active equals hsxl.Id join r_dn in _doanhNghiepRepos.GetAll() on hoso.DoanhNghiepId equals r_dn.Id into tb_dn //Left Join from dn in tb_dn.DefaultIfEmpty() where hoso.PId == null select new XHoSoDto { Id = hoso.Id, DoanhNghiepId = hoso.DoanhNghiepId, SoDangKy = hoso.SoDangKy, TenDoanhNghiep = hoso.TenDoanhNghiep, TenNguoiDaiDien = hoso.TenNguoiDaiDien, NgaySinh = hoso.NgaySinh, TinhId = (dn != null) ? dn.TinhId : 0, HuyenId = dn.HuyenId, XaId = dn.XaId, StrTinh = (dn != null) ? dn.Tinh : string.Empty, DiaChi = hoso.DiaChi, NgayTraKetQua = hoso.NgayTraKetQua, MaHoSo = hoso.MaHoSo, GiayTiepNhan = hoso.GiayTiepNhan, GiayTiepNhanCA = hsxl.GiayTiepNhanCA, SoGiayTiepNhan = hoso.SoGiayTiepNhan, LoaiHoSoId = hoso.LoaiHoSoId, TrangThaiHoSo = hoso.TrangThaiHoSo, VanThuId = hsxl.VanThuId, ChuyenVienThuLyId = hsxl.ChuyenVienThuLyId, TruongPhongId = hsxl.TruongPhongId, LanhDaoCucId = hsxl.LanhDaoCucId, NgayNopRaSoat = hoso.NgayNopRaSoat, NgayTiepNhan = hsxl.NgayTiepNhan, DonViGui = hsxl.DonViGui, DonViXuLy = hsxl.DonViXuLy, NguoiXuLyId = hsxl.NguoiXuLyId, NguoiGuiId = hsxl.NguoiGuiId, NgayGui = hsxl.NgayGui, HoTenNguoiDeNghi = hoso.HoTenNguoiDeNghi, DiaChiCuTru = hoso.DiaChiCuTru, EmailNguoiDeNghi = hoso.EmailNguoiDeNghi, DienThoaiNguoiDeNghi = hoso.DienThoaiNguoiDeNghi, SoNhanBiet = hoso.SoNhanBiet }).WhereIf(input.TinhId.HasValue, x => x.TinhId == input.TinhId) .WhereIf(input.HuyenId.HasValue, x => x.HuyenId == input.HuyenId) .WhereIf(input.XaId.HasValue, x => x.XaId == input.XaId) .WhereIf(input.VanThuId.HasValue, x => x.VanThuId == input.VanThuId) .WhereIf(input.ChuyenVienThuLyId.HasValue, x => x.ChuyenVienThuLyId == input.ChuyenVienThuLyId) .WhereIf(input.TruongPhongId.HasValue, x => x.TruongPhongId == input.TruongPhongId) .WhereIf(input.LanhDaoCucId.HasValue, x => x.LanhDaoCucId == input.LanhDaoCucId) .WhereIf(!String.IsNullOrEmpty(input.HoTenNguoiDeNghi), x => x.HoTenNguoiDeNghi.Contains(input.HoTenNguoiDeNghi)) .WhereIf(!String.IsNullOrEmpty(input.MaHoSo), x => x.MaHoSo.Contains(input.MaHoSo)) .WhereIf(!String.IsNullOrEmpty(input.MaSoThue), x => x.MaHoSo.Contains(input.MaSoThue)) .WhereIf(!String.IsNullOrEmpty(input.DiaChi), x => x.DiaChi.Contains(input.DiaChi)); var a = query.ToList(); if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.DA_NOP_HO_SO_MOI) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.DA_NOP_HO_SO_MOI); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.MOT_CUA_DA_TIEP_NHAN) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.MOT_CUA_DA_TIEP_NHAN); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.MOT_CUA_TRA_LAI) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.MOT_CUA_TRA_LAI); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.CHO_TRA_GIAY_TIEP_NHAN) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.CHO_TRA_GIAY_TIEP_NHAN); } if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.LANH_DAO_DA_PHAN_CONG_HO_SO) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.LANH_DAO_DA_PHAN_CONG_HO_SO); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.PHONG_BAN_TU_CHOI_TIEP_NHAN_HO_SO) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.PHONG_BAN_TU_CHOI_TIEP_NHAN_HO_SO); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.CHUYEN_VIEN_TU_CHOI_TIEP_NHAN_HO_SO) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.CHUYEN_VIEN_TU_CHOI_TIEP_NHAN_HO_SO); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.HO_SO_THAM_XET_LAI) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.HO_SO_THAM_XET_LAI); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.SUA_DOI_BO_SUNG) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.SUA_DOI_BO_SUNG); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.HO_SO_CHO_THAM_DINH) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_THAM_DINH_HO_SO_37.HO_SO_CHO_THAM_DINH); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.TONG_HOP_THAM_DINH_LAI) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_THAM_DINH_HO_SO_37.TONG_HOP_THAM_DINH_LAI); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.HO_SO_TONG_HOP_THAM_DINH_DA_LUU) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_THAM_DINH_HO_SO_37.HO_SO_TONG_HOP_THAM_DINH_DA_LUU); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.LANH_DAO_CUC_DUYET_THAM_DINH) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_THAM_DINH_HO_SO_37.LANH_DAO_CUC_DUYET_THAM_DINH); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.HO_SO_CHO_VAN_THU_TRA_KET_QUA) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_THAM_DINH_HO_SO_37.HO_SO_CHO_VAN_THU_TRA_KET_QUA); } else if (input.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO_FOR_TRA_CUU_TT37.DA_HOAN_TAT) { query = query.Where(x => x.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.DA_HOAN_TAT); } var _total = await query.CountAsync(); var dataGrids = await query .OrderByDescending(p => p.NgayTraKetQua) .PageBy(input) .ToListAsync(); foreach (var item in dataGrids) { using (CurrentUnitOfWork.DisableFilter(AbpDataFilters.MayHaveTenant)) { if (item.ChuyenVienThuLyId.HasValue) { var chuyenVienThuLyObj = _userRepos.FirstOrDefault(item.ChuyenVienThuLyId.Value); item.ChuyenVienThuLyName = chuyenVienThuLyObj.Surname + " " + chuyenVienThuLyObj.Name; } if (item.NguoiGuiId.HasValue) { var objUser = _userRepos.FirstOrDefault(item.NguoiGuiId.Value); item.TenNguoiGui = objUser.Surname + " " + objUser.Name; } if (item.NguoiXuLyId.HasValue) { var objUser = _userRepos.FirstOrDefault(item.NguoiXuLyId.Value); item.TenNguoiXuLy = objUser.Surname + " " + objUser.Name; } } #region Trạng thái hồ sơ item.StrTrangThai = GetTrangThaiXuLyHoSo(item); #endregion item.StrDonViXuLy = item.DonViXuLy != null?CommonENum.GetEnumDescription((CommonENum.DON_VI_XU_LY)(int) item.DonViXuLy) : ""; item.StrDonViGui = item.DonViGui != null?CommonENum.GetEnumDescription((CommonENum.DON_VI_XU_LY)(int) item.DonViGui) : ""; } return(new PagedResultDto <XHoSoDto>(_total, dataGrids)); } catch (Exception ex) { Logger.Fatal(ex.Message); return(null); } }
public void KeyPayResultIPN() { var data = Request.RequestUri.ParseQueryString(); Keypay keypay = new Keypay(); // lấy tham số để truyền vào hàm keypay.Merchant_trans_id = data["merchant_trans_id"]; keypay.Good_code = data["good_code"]; keypay.Trans_id = data["trans_id"]; keypay.Merchant_code = data["merchant_code"]; keypay.Merchant_secure_key = string.Empty; keypay.Bank_code = data["bank_code"]; keypay.Command = data["command"]; keypay.Nest_code = data["net_cost"]; keypay.Response_code = data["response_code"]; keypay.Service_code = data["service_code"]; keypay.Ship_fee = data["ship_fee"]; keypay.Tax = data["tax"]; keypay.Current_code = data["currency_code"]; keypay.Secure_hash = data["secure_hash"]; if (!string.IsNullOrEmpty(keypay.Good_code) && keypay.Good_code.Contains(".")) { var arr = keypay.Good_code.Split('.'); var maThuTuc = arr.First(); //THU_TUC_TT-99 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_99)) { _xuLyHoSoDoanhNghiepAppService.UpdateThanhToanKeyPay(keypay, true); } #region Thủ Tục hành Chính //THU_TUC_TT-01 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_01)) { //_xuLyHoSoDoanhNghiep01AppService.UpdateThanhToanKeyPay(keypay, true); } //THU_TUC_TT-02 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_02)) { //_xuLyHoSoDoanhNghiep02AppService.UpdateThanhToanKeyPay(keypay, true); } //THU_TUC_TT-03 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_03)) { //_xuLyHoSoDoanhNghiep03AppService.UpdateThanhToanKeyPay(keypay, true); } //THU_TUC_TT-04 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_04)) { //_xuLyHoSoDoanhNghiep04AppService.UpdateThanhToanKeyPay(keypay, true); } //THU_TUC_TT-05 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_05)) { //_xuLyHoSoDoanhNghiep05AppService.UpdateThanhToanKeyPay(keypay, true); } //THU_TUC_TT-06 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_06)) { //_xuLyHoSoDoanhNghiep06AppService.UpdateThanhToanKeyPay(keypay, true); } //THU_TUC_TT-07 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_07)) { //_xuLyHoSoDoanhNghiep07AppService.UpdateThanhToanKeyPay(keypay, true); } //THU_TUC_TT-08 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_08)) { //_xuLyHoSoDoanhNghiep08AppService.UpdateThanhToanKeyPay(keypay, true); } //THU_TUC_TT-09 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_09)) { //_xuLyHoSoDoanhNghiep09AppService.UpdateThanhToanKeyPay(keypay, true); } ////THU_TUC_TT-10 //else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_10)) //{ // _xuLyHoSoDoanhNghiep09AppService.UpdateThanhToanKeyPay(keypay, true); //} #endregion } }
public async Task <ActionResult> KeyPayResponse() { Keypay keypay = new Keypay(); // lấy tham số để truyền vào hàm keypay.Merchant_trans_id = Request.QueryString["merchant_trans_id"]; keypay.Good_code = Request.QueryString["good_code"]; keypay.Trans_id = Request.QueryString["trans_id"]; keypay.Merchant_code = Request.QueryString["merchant_code"]; //keypay.Merchant_secure_key = string.Empty; keypay.Bank_code = Request.QueryString["bank_code"]; keypay.Command = Request.QueryString["command"]; keypay.Nest_code = Request.QueryString["net_cost"]; keypay.Response_code = Request.QueryString["response_code"]; keypay.Service_code = Request.QueryString["service_code"]; keypay.Ship_fee = Request.QueryString["ship_fee"]; keypay.Tax = Request.QueryString["tax"]; keypay.Current_code = Request.QueryString["currency_code"]; keypay.Secure_hash = Request.QueryString["secure_hash"]; if (!string.IsNullOrEmpty(keypay.Good_code) && keypay.Good_code.Contains(".")) { var arr = keypay.Good_code.Split('.'); var maThuTuc = arr.First(); //THU_TUC_TT-99 if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_99)) { await _xuLyHoSoDoanhNghiepAppService.UpdateThanhToanKeyPay(keypay, false); return(Redirect("/Application#!/dangkyhoso?kp_statuscode=" + keypay.Response_code)); } #region Thủ Tục hành Chính //THU_TUC_TT-01 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_01)) { //await _xuLyHoSoDoanhNghiep01AppService.UpdateThanhToanKeyPay(keypay, false); return(Redirect("/Application#!/tt01/dangkyhoso?kp_statuscode=" + keypay.Response_code)); } //THU_TUC_TT-02 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_02)) { //await _xuLyHoSoDoanhNghiep02AppService.UpdateThanhToanKeyPay(keypay, false); return(Redirect("/Application#!/tt02/dangkyhoso?kp_statuscode=" + keypay.Response_code)); } //THU_TUC_TT-03 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_03)) { //await _xuLyHoSoDoanhNghiep03AppService.UpdateThanhToanKeyPay(keypay, false); return(Redirect("/Application#!/tt03/dangkyhoso?kp_statuscode=" + keypay.Response_code)); } //THU_TUC_TT-04 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_04)) { //await _xuLyHoSoDoanhNghiep04AppService.UpdateThanhToanKeyPay(keypay, false); return(Redirect("/Application#!/tt04/dangkyhoso?kp_statuscode=" + keypay.Response_code)); } //THU_TUC_TT-05 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_05)) { //await _xuLyHoSoDoanhNghiep05AppService.UpdateThanhToanKeyPay(keypay, false); return(Redirect("/Application#!/tt05/dangkyhoso?kp_statuscode=" + keypay.Response_code)); } //THU_TUC_TT-06 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_06)) { //await _xuLyHoSoDoanhNghiep06AppService.UpdateThanhToanKeyPay(keypay, false); return(Redirect("/Application#!/tt06/dangkyhoso?kp_statuscode=" + keypay.Response_code)); } //THU_TUC_TT-07 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_07)) { //await _xuLyHoSoDoanhNghiep07AppService.UpdateThanhToanKeyPay(keypay, false); return(Redirect("/Application#!/tt07/dangkyhoso?kp_statuscode=" + keypay.Response_code)); } //THU_TUC_TT-08 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_08)) { //await _xuLyHoSoDoanhNghiep08AppService.UpdateThanhToanKeyPay(keypay, false); return(Redirect("/Application#!/tt08/dangkyhoso?kp_statuscode=" + keypay.Response_code)); } //THU_TUC_TT-09 else if (maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_09)) { //await _xuLyHoSoDoanhNghiep09AppService.UpdateThanhToanKeyPay(keypay, false); return(Redirect("/Application#!/tt09/dangkyhoso?kp_statuscode=" + keypay.Response_code)); } ////THU_TUC_TT-10 // else if(maThuTuc == CommonENum.GetEnumDescription(THU_TUC_ID.THU_TUC_10)) // { // await _xuLyHoSoDoanhNghiep10AppService.UpdateThanhToanKeyPay(keypay, false); // return Redirect("/Application#!/tt10/dangkyhoso?kp_statuscode=" + keypay.Response_code); // } #endregion Thủ Tục hành Chính } return(Redirect("/Application#!/tenant/dashboard")); }
public PagedResultDto <HoSoReportDto> GetTraCuuHoSo(HoSoReportInputDto input) { int total = 0; var dataGrids = new List <HoSoReportDto>(); try { var sqlUnionThuTuc = ""; foreach (int tt in _userCurrent.ThuTucEnum) { string maTT = tt < 10 ? $"0{tt}" : tt.ToString(); string thuTucQuery = $@" select {SelectStringSql(tt, input)} from dbo.TT{maTT}_HoSo hs left join dbo.TT{maTT}_HoSoXuLy hsxl on hs.HoSoXuLyId_Active = hsxl.Id where hs.IsDeleted = 0 and hs.PId is null and {WhereStringSql(tt, input)} "; sqlUnionThuTuc = string.IsNullOrEmpty(sqlUnionThuTuc) ? thuTucQuery : $"{sqlUnionThuTuc} UNION ALL {thuTucQuery}"; } string sqlQuery = $@"select TotalRows = Count(1) Over(), A.* from ( {sqlUnionThuTuc} ) as A order by A.CreationTime OFFSET (@skip) ROWS FETCH NEXT @rows ROWS ONLY; " ; using (var ctx = new AppDbContext()) { SqlParameter[] prm = ParmeterThuTucReport(input); dataGrids = ctx.Database.SqlQuery <HoSoReportDto>(sqlQuery, prm).ToList(); total = dataGrids.Count > 0 ? dataGrids[0].TotalRows.Value : 0; } for (int idx = 0; idx < dataGrids.Count; idx++) { var item = dataGrids[idx]; item.FormId = input.FormId; item.FormCase = input.FormCase; item = GetTrangThaiXuLyHoSo(item, input); item = GetPhongBanPhanCong(item, input); item.StrDonViXuLy = item.DonViXuLy != null?CommonENum.GetEnumDescription((CommonENum.DON_VI_XU_LY)(int) item.DonViXuLy) : ""; item.StrDonViGui = item.DonViGui != null?CommonENum.GetEnumDescription((CommonENum.DON_VI_XU_LY)(int) item.DonViGui) : ""; using (CurrentUnitOfWork.DisableFilter(AbpDataFilters.MayHaveTenant)) { if (item.ChuyenVienThuLyId.HasValue) { var chuyenVienThuLyObj = _userRepos.FirstOrDefault(item.ChuyenVienThuLyId.Value); item.ChuyenVienThuLyName = chuyenVienThuLyObj.Surname + " " + chuyenVienThuLyObj.Name; } if (item.ChuyenVienPhoiHopId.HasValue) { var chuyenVienPhoiHopObj = _userRepos.FirstOrDefault(item.ChuyenVienPhoiHopId.Value); item.ChuyenVienPhoiHopName = chuyenVienPhoiHopObj.Surname + " " + chuyenVienPhoiHopObj.Name; } if (item.NguoiGuiId.HasValue) { var objUser = _userRepos.FirstOrDefault(item.NguoiGuiId.Value); item.TenNguoiGui = objUser.Surname + " " + objUser.Name; } if (item.NguoiXuLyId.HasValue) { var objUser = _userRepos.FirstOrDefault(item.NguoiXuLyId.Value); item.TenNguoiXuLy = objUser.Surname + " " + objUser.Name; } } if (item.IsChiCuc != true) { item.TenChiCuc = "Cục Quản Lý Dược - Bộ Y Tế"; } #region Số ngày quá hạn item.SoNgayQuaHan = 0; if (item.TrangThaiHoSo != (int)CommonENum.TRANG_THAI_HO_SO.DA_HOAN_TAT && item.TrangThaiHoSo != (int)CommonENum.TRANG_THAI_HO_SO.SUA_DOI_BO_SUNG && item.NgayHenTra != null) { DateTime ngay_begin = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); DateTime ngay_end = new DateTime(item.NgayHenTra.Value.Year, item.NgayHenTra.Value.Month, item.NgayHenTra.Value.Day); if (ngay_begin > ngay_end) { TimeSpan Time = ngay_begin - ngay_end; item.SoNgayQuaHan = Time.Days; item.StrQuaHan = "Quá hạn " + item.SoNgayQuaHan + " ngày"; } else { item.SoNgayQuaHan = _lichLamViecAppService.GetSoNgayLamViec(ngay_begin, ngay_end); item.StrQuaHan = "Còn " + item.SoNgayQuaHan + " ngày làm việc"; item.SoNgayQuaHan = item.SoNgayQuaHan * (-1); } } else if (item.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.SUA_DOI_BO_SUNG) { item.StrQuaHan = "Đã trả công văn (TB)"; } else if (item.TrangThaiHoSo == (int)CommonENum.TRANG_THAI_HO_SO.DA_HOAN_TAT) { item.StrQuaHan = "Xử lý xong"; } #endregion #region Các phòng ban có thể xử lý (một cửa phân công) if (input.FormId == (int)CommonENum.FORM_ID.FORM_MOT_CUA_PHAN_CONG) { var _listPhongBan = (from ploai in _phongBanLoaiHoSoRepos.GetAll() join pb in _phongBanRepos.GetAll() on ploai.PhongBanId equals pb.Id where ploai.LoaiHoSoId == item.LoaiHoSoId select new ItemDto <int> { Id = pb.Id, Name = pb.TenPhongBan, Checked = false }).ToList(); if (item.PhongBanId.HasValue && item.PhongBanId > 0) { foreach (var phongban in _listPhongBan) { if (phongban.Id == item.PhongBanId) { phongban.Checked = true; } } } item.ArrPhongBanXuLy = _listPhongBan; } #endregion #region Chức năng trên grid List <int> _arrChucNang = new List <int>(); //FORM 2 if (input.FormId == (int)CommonENum.FORM_ID.FORM_MOT_CUA_PHAN_CONG) { _arrChucNang.Add((int)CommonENum.FORM_FUNCTION.XEM_HO_SO); _arrChucNang.Add((int)CommonENum.FORM_FUNCTION.XEM_BAN_DANG_KY); if (!item.TruongPhongId.HasValue) { _arrChucNang.Add((int)CommonENum.FORM_FUNCTION.MOT_CUA_RA_SOAT_HO_SO); } } //FORM 7 if (input.FormId == (int)CommonENum.FORM_ID.FORM_VAN_THU_DUYET) { _arrChucNang.Add((int)CommonENum.FORM_FUNCTION.XEM_HO_SO); _arrChucNang.Add((int)CommonENum.FORM_FUNCTION.XEM_BAN_DANG_KY); if (item.DonViXuLy == (int)CommonENum.DON_VI_XU_LY.VAN_THU) { if (item.HoSoIsDat == true) { _arrChucNang.Add((int)CommonENum.FORM_FUNCTION.VAN_THU_DUYET); _arrChucNang.Add((int)CommonENum.FORM_FUNCTION.VAN_THU_DONG_DAU); } else { _arrChucNang.Add((int)CommonENum.FORM_FUNCTION.XEM_CONG_VAN); _arrChucNang.Add((int)CommonENum.FORM_FUNCTION.VAN_THU_DUYET); _arrChucNang.Add((int)CommonENum.FORM_FUNCTION.VAN_THU_DONG_DAU); _arrChucNang.Add((int)CommonENum.FORM_FUNCTION.VAN_THU_BAO_CAO_CONG_VAN_CO_SAI_SOT); } } } item.ArrChucNang = _arrChucNang; #endregion dataGrids[idx] = item; } } catch (Exception ex) { Logger.Error(ex.Message); } return(new PagedResultDto <HoSoReportDto>(total, dataGrids)); }