public async Task <List <CongViecDto> > GetAll(DanhSachCongViecInput input)
{
var UserCache = await _globalCache.GetUserCache((long)AbpSession.UserId);
if (UserCache.Id == 0)
{
return(new List <CongViecDto>());
}
var query = from CongViec in _congViecRepository.GetAll()
.WhereIf(input.TrangThaiIds.Length > 0, w => input.TrangThaiIds.ToList().Contains(w.TrangThaiId))
.WhereIf(UserCache.IsCustomer, w => w.KhachHangId == UserCache.CustomerId)
.WhereIf(!UserCache.IsCustomer, w => w.NhanVienId == AbpSession.UserId)
join DichVu in _dichVuRepository.GetAll() on CongViec.DichVuId equals DichVu.Id into J1
from DichVu in J1.DefaultIfEmpty()
join NhomDichVu in _nhomDichVuRepository.GetAll() on DichVu.NhomDichVuId equals NhomDichVu.Id into J6
from NhomDichVu in J6.DefaultIfEmpty()
join TramDichVu in _tramDichVuRepository.GetAll() on CongViec.TramDichVuId equals TramDichVu.Id into J5
from TramDichVu in J5.DefaultIfEmpty()
join NhanVien in _nhanVienRepository.GetAll() on CongViec.NhanVienId equals NhanVien.Id into J2
from NhanVien in J2.DefaultIfEmpty()
join TinhThanh in _tinhThanhRepository.GetAll() on CongViec.DiaChiTinhThanhId equals TinhThanh.Id into J3
from TinhThanh in J3.DefaultIfEmpty()
join QuanHuyen in _quanHuyenRepository.GetAll() on CongViec.DiaChiQuanHuyenId equals QuanHuyen.Id into J4
from QuanHuyen in J4.DefaultIfEmpty()
select new
{
CongViec,
NhomDichVuId = NhomDichVu != null ? NhomDichVu.Id : 0,
NhomDichVuName = NhomDichVu.Name,
DichVuName = DichVu.Name,
TramDichVuName = TramDichVu.Name,
NhanVienName = NhanVien.Name,
NhanVienPhone = NhanVien.PhoneNumber,
TinhThanhName = TinhThanh.Name,
QuanHuyenName = QuanHuyen.Name
};
var CongViecs = await query.OrderBy(o => o.CongViec.NgayGioHen).Skip((input.Page - 1) * 10).Take(10).ToListAsync();
var CongViecDtos = new List <CongViecDto>();
foreach (var item in CongViecs)
{
var CongViec = ObjectMapper.Map <CongViecDto>(item.CongViec);
if (item.NhomDichVuId > 0)
{
CongViec.NhomDichVuId = item.NhomDichVuId;
}
CongViec.NhomDichVuName = item.NhomDichVuName;
CongViec.DichVuName = item.DichVuName;
CongViec.TramDichVuName = item.TramDichVuName;
CongViec.NhanVienName = item.NhanVienName;
CongViec.NhanVienPhone = item.NhanVienPhone;
CongViec.DiaChi += string.IsNullOrWhiteSpace(item.QuanHuyenName) ? "" : ", " + item.QuanHuyenName;
CongViec.DiaChi += string.IsNullOrWhiteSpace(item.TinhThanhName) ? "" : ", " + item.TinhThanhName;
CongViec.TrangThaiName = item.CongViec.TrangThaiId >= 0 && GlobalModel.TrangThaiCongViec.ContainsKey((int)item.CongViec.TrangThaiId) ? GlobalModel.TrangThaiCongViec[(int)item.CongViec.TrangThaiId] : "";
CongViec.Image1 = string.IsNullOrWhiteSpace(CongViec.Image1) ? "" : string.Format("/Common/CongViecs/{0}/{1}", item.CongViec.TimeId, CongViec.Image1);
CongViec.Image2 = string.IsNullOrWhiteSpace(CongViec.Image2) ? "" : string.Format("/Common/CongViecs/{0}/{1}", item.CongViec.TimeId, CongViec.Image2);
CongViec.Image3 = string.IsNullOrWhiteSpace(CongViec.Image3) ? "" : string.Format("/Common/CongViecs/{0}/{1}", item.CongViec.TimeId, CongViec.Image3);
CongViec.ImageHoanThanh1 = string.IsNullOrWhiteSpace(CongViec.ImageHoanThanh1) ? "" : string.Format("/Common/CongViecs/{0}/{1}", item.CongViec.TimeId, CongViec.ImageHoanThanh1);
CongViec.ImageHoanThanh2 = string.IsNullOrWhiteSpace(CongViec.ImageHoanThanh2) ? "" : string.Format("/Common/CongViecs/{0}/{1}", item.CongViec.TimeId, CongViec.ImageHoanThanh2);
CongViec.ImageHoanThanh3 = string.IsNullOrWhiteSpace(CongViec.ImageHoanThanh3) ? "" : string.Format("/Common/CongViecs/{0}/{1}", item.CongViec.TimeId, CongViec.ImageHoanThanh3);
CongViec.ImageKhachHang1 = string.IsNullOrWhiteSpace(CongViec.ImageKhachHang1) ? "" : string.Format("/Common/CongViecs/{0}/{1}", item.CongViec.TimeId, CongViec.ImageKhachHang1);
CongViec.ImageKhachHang2 = string.IsNullOrWhiteSpace(CongViec.ImageKhachHang2) ? "" : string.Format("/Common/CongViecs/{0}/{1}", item.CongViec.TimeId, CongViec.ImageKhachHang2);
CongViec.ImageKhachHang3 = string.IsNullOrWhiteSpace(CongViec.ImageKhachHang3) ? "" : string.Format("/Common/CongViecs/{0}/{1}", item.CongViec.TimeId, CongViec.ImageKhachHang3);
CongViecDtos.Add(CongViec);
}
return(CongViecDtos);
}
// Use this for initialization
void Start()
{
PlayerIcon.GetComponent <SpriteRenderer>().enabled = true;
A1.GetComponent <SpriteRenderer>().enabled = false;
A2.GetComponent <SpriteRenderer>().enabled = false;
A3.GetComponent <SpriteRenderer>().enabled = false;
A4.GetComponent <SpriteRenderer>().enabled = false;
A5.GetComponent <SpriteRenderer>().enabled = false;
A6.GetComponent <SpriteRenderer>().enabled = false;
A7.GetComponent <SpriteRenderer>().enabled = false;
A8.GetComponent <SpriteRenderer>().enabled = false;
A9.GetComponent <SpriteRenderer>().enabled = false;
A10.GetComponent <SpriteRenderer>().enabled = false;
A11.GetComponent <SpriteRenderer>().enabled = false;
B1.GetComponent <SpriteRenderer>().enabled = false;
B2.GetComponent <SpriteRenderer>().enabled = false;
B3.GetComponent <SpriteRenderer>().enabled = false;
B4.GetComponent <SpriteRenderer>().enabled = false;
B5.GetComponent <SpriteRenderer>().enabled = false;
B6.GetComponent <SpriteRenderer>().enabled = false;
B7.GetComponent <SpriteRenderer>().enabled = false;
B8.GetComponent <SpriteRenderer>().enabled = false;
B9.GetComponent <SpriteRenderer>().enabled = false;
B10.GetComponent <SpriteRenderer>().enabled = false;
B11.GetComponent <SpriteRenderer>().enabled = false;
C1.GetComponent <SpriteRenderer>().enabled = false;
C2.GetComponent <SpriteRenderer>().enabled = false;
C3.GetComponent <SpriteRenderer>().enabled = false;
C4.GetComponent <SpriteRenderer>().enabled = false;
C5.GetComponent <SpriteRenderer>().enabled = false;
C6.GetComponent <SpriteRenderer>().enabled = false;
C7.GetComponent <SpriteRenderer>().enabled = false;
C8.GetComponent <SpriteRenderer>().enabled = false;
C9.GetComponent <SpriteRenderer>().enabled = false;
C10.GetComponent <SpriteRenderer>().enabled = false;
C11.GetComponent <SpriteRenderer>().enabled = false;
D1.GetComponent <SpriteRenderer>().enabled = false;
D2.GetComponent <SpriteRenderer>().enabled = false;
D3.GetComponent <SpriteRenderer>().enabled = false;
D4.GetComponent <SpriteRenderer>().enabled = false;
D5.GetComponent <SpriteRenderer>().enabled = false;
D6.GetComponent <SpriteRenderer>().enabled = false;
D7.GetComponent <SpriteRenderer>().enabled = false;
D8.GetComponent <SpriteRenderer>().enabled = false;
D9.GetComponent <SpriteRenderer>().enabled = false;
D10.GetComponent <SpriteRenderer>().enabled = false;
D11.GetComponent <SpriteRenderer>().enabled = false;
E1.GetComponent <SpriteRenderer>().enabled = false;
E2.GetComponent <SpriteRenderer>().enabled = false;
E3.GetComponent <SpriteRenderer>().enabled = false;
E4.GetComponent <SpriteRenderer>().enabled = false;
E5.GetComponent <SpriteRenderer>().enabled = false;
E6.GetComponent <SpriteRenderer>().enabled = false;
E7.GetComponent <SpriteRenderer>().enabled = false;
E8.GetComponent <SpriteRenderer>().enabled = false;
E9.GetComponent <SpriteRenderer>().enabled = false;
E10.GetComponent <SpriteRenderer>().enabled = false;
E11.GetComponent <SpriteRenderer>().enabled = false;
F1.GetComponent <SpriteRenderer>().enabled = false;
F2.GetComponent <SpriteRenderer>().enabled = false;
F3.GetComponent <SpriteRenderer>().enabled = false;
F4.GetComponent <SpriteRenderer>().enabled = false;
F5.GetComponent <SpriteRenderer>().enabled = false;
F6.GetComponent <SpriteRenderer>().enabled = false;
F7.GetComponent <SpriteRenderer>().enabled = false;
F8.GetComponent <SpriteRenderer>().enabled = false;
F9.GetComponent <SpriteRenderer>().enabled = false;
F10.GetComponent <SpriteRenderer>().enabled = false;
F11.GetComponent <SpriteRenderer>().enabled = false;
G1.GetComponent <SpriteRenderer>().enabled = false;
G2.GetComponent <SpriteRenderer>().enabled = false;
G3.GetComponent <SpriteRenderer>().enabled = false;
G4.GetComponent <SpriteRenderer>().enabled = false;
G5.GetComponent <SpriteRenderer>().enabled = false;
G6.GetComponent <SpriteRenderer>().enabled = false;
G7.GetComponent <SpriteRenderer>().enabled = false;
G8.GetComponent <SpriteRenderer>().enabled = false;
G9.GetComponent <SpriteRenderer>().enabled = false;
G10.GetComponent <SpriteRenderer>().enabled = false;
G11.GetComponent <SpriteRenderer>().enabled = false;
H1.GetComponent <SpriteRenderer>().enabled = false;
H2.GetComponent <SpriteRenderer>().enabled = false;
H3.GetComponent <SpriteRenderer>().enabled = false;
H4.GetComponent <SpriteRenderer>().enabled = false;
H5.GetComponent <SpriteRenderer>().enabled = false;
H6.GetComponent <SpriteRenderer>().enabled = false;
H7.GetComponent <SpriteRenderer>().enabled = false;
H8.GetComponent <SpriteRenderer>().enabled = false;
H9.GetComponent <SpriteRenderer>().enabled = false;
H10.GetComponent <SpriteRenderer>().enabled = false;
H11.GetComponent <SpriteRenderer>().enabled = false;
I1.GetComponent <SpriteRenderer>().enabled = false;
I2.GetComponent <SpriteRenderer>().enabled = false;
I3.GetComponent <SpriteRenderer>().enabled = false;
I4.GetComponent <SpriteRenderer>().enabled = false;
I5.GetComponent <SpriteRenderer>().enabled = false;
I6.GetComponent <SpriteRenderer>().enabled = false;
I7.GetComponent <SpriteRenderer>().enabled = false;
I8.GetComponent <SpriteRenderer>().enabled = false;
I9.GetComponent <SpriteRenderer>().enabled = false;
I10.GetComponent <SpriteRenderer>().enabled = false;
I11.GetComponent <SpriteRenderer>().enabled = false;
J1.GetComponent <SpriteRenderer>().enabled = false;
J2.GetComponent <SpriteRenderer>().enabled = false;
J3.GetComponent <SpriteRenderer>().enabled = false;
J4.GetComponent <SpriteRenderer>().enabled = false;
J5.GetComponent <SpriteRenderer>().enabled = false;
J6.GetComponent <SpriteRenderer>().enabled = false;
J7.GetComponent <SpriteRenderer>().enabled = false;
J8.GetComponent <SpriteRenderer>().enabled = false;
J9.GetComponent <SpriteRenderer>().enabled = false;
J10.GetComponent <SpriteRenderer>().enabled = false;
J11.GetComponent <SpriteRenderer>().enabled = false;
K1.GetComponent <SpriteRenderer>().enabled = false;
K2.GetComponent <SpriteRenderer>().enabled = false;
K3.GetComponent <SpriteRenderer>().enabled = false;
K4.GetComponent <SpriteRenderer>().enabled = false;
K5.GetComponent <SpriteRenderer>().enabled = false;
K6.GetComponent <SpriteRenderer>().enabled = false;
K7.GetComponent <SpriteRenderer>().enabled = false;
K8.GetComponent <SpriteRenderer>().enabled = false;
K9.GetComponent <SpriteRenderer>().enabled = false;
K10.GetComponent <SpriteRenderer>().enabled = false;
K11.GetComponent <SpriteRenderer>().enabled = false;
float ratio = Screen.width / Screen.height;
if (ratio < 2)
{
int screenx = 543;
int screeny = 653;
}
else
{
int screenx = 743;
int screeny = 853;
}
}
public async Task <CongViecDto> Get(long Id)
{
var UserCache = await _globalCache.GetUserCache((long)AbpSession.UserId);
if (UserCache.Id == 0)
{
throw new UserFriendlyException(L("UserIsNotLogin"));
}
var query = await(from CongViec in _congViecRepository.GetAll().Where(w => w.Id == Id)
.WhereIf(UserCache.IsCustomer, w => w.KhachHangId == UserCache.CustomerId)
.WhereIf(!UserCache.IsCustomer, w => w.NhanVienId == AbpSession.UserId)
join DichVu in _dichVuRepository.GetAll() on CongViec.DichVuId equals DichVu.Id into J1
from DichVu in J1.DefaultIfEmpty()
join NhomDichVu in _nhomDichVuRepository.GetAll() on DichVu.NhomDichVuId equals NhomDichVu.Id into J6
from NhomDichVu in J6.DefaultIfEmpty()
join TramDichVu in _tramDichVuRepository.GetAll() on CongViec.TramDichVuId equals TramDichVu.Id into J2
from TramDichVu in J2.DefaultIfEmpty()
join NhanVien in _nhanVienRepository.GetAll() on CongViec.NhanVienId equals NhanVien.Id into J3
from NhanVien in J3.DefaultIfEmpty()
join TinhThanh in _tinhThanhRepository.GetAll() on CongViec.DiaChiTinhThanhId equals TinhThanh.Id into J4
from TinhThanh in J4.DefaultIfEmpty()
join QuanHuyen in _quanHuyenRepository.GetAll() on CongViec.DiaChiQuanHuyenId equals QuanHuyen.Id into J5
from QuanHuyen in J5.DefaultIfEmpty()
select new
{
CongViec,
NhomDichVuId = NhomDichVu != null ? NhomDichVu.Id : 0,
NhomDichVuName = NhomDichVu.Name,
DichVuName = DichVu.Name,
TramDichVuName = TramDichVu.Name,
NhanVienName = NhanVien.Name,
NhanVienPhone = NhanVien.PhoneNumber,
TinhThanhName = TinhThanh.Name,
QuanHuyenName = QuanHuyen.Name
}).FirstOrDefaultAsync();
if (query == null)
{
throw new UserFriendlyException(L("CongViecIsNotFound"));
}
var result = ObjectMapper.Map <CongViecDto>(query.CongViec);
if (query.NhomDichVuId > 0)
{
result.NhomDichVuId = query.NhomDichVuId;
}
result.NhomDichVuName = query.NhomDichVuName;
result.DichVuName = query.DichVuName;
result.TramDichVuName = query.TramDichVuName;
result.NhanVienName = query.NhanVienName;
result.NhanVienPhone = query.NhanVienPhone;
result.DiaChi += string.IsNullOrWhiteSpace(query.QuanHuyenName) ? "" : ", " + query.QuanHuyenName;
result.DiaChi += string.IsNullOrWhiteSpace(query.TinhThanhName) ? "" : ", " + query.TinhThanhName;
result.TrangThaiName = query.CongViec.TrangThaiId >= 0 && GlobalModel.TrangThaiCongViec.ContainsKey((int)query.CongViec.TrangThaiId) ? GlobalModel.TrangThaiCongViec[(int)query.CongViec.TrangThaiId] : "";
result.Image1 = string.IsNullOrWhiteSpace(result.Image1) ? "" : string.Format("/Common/CongViecs/{0}/{1}", query.CongViec.TimeId, result.Image1);
result.Image2 = string.IsNullOrWhiteSpace(result.Image2) ? "" : string.Format("/Common/CongViecs/{0}/{1}", query.CongViec.TimeId, result.Image2);
result.Image3 = string.IsNullOrWhiteSpace(result.Image3) ? "" : string.Format("/Common/CongViecs/{0}/{1}", query.CongViec.TimeId, result.Image3);
result.ImageHoanThanh1 = string.IsNullOrWhiteSpace(result.ImageHoanThanh1) ? "" : string.Format("/Common/CongViecs/{0}/{1}", query.CongViec.TimeId, result.ImageHoanThanh1);
result.ImageHoanThanh2 = string.IsNullOrWhiteSpace(result.ImageHoanThanh2) ? "" : string.Format("/Common/CongViecs/{0}/{1}", query.CongViec.TimeId, result.ImageHoanThanh2);
result.ImageHoanThanh3 = string.IsNullOrWhiteSpace(result.ImageHoanThanh3) ? "" : string.Format("/Common/CongViecs/{0}/{1}", query.CongViec.TimeId, result.ImageHoanThanh3);
result.ImageKhachHang1 = string.IsNullOrWhiteSpace(result.ImageKhachHang1) ? "" : string.Format("/Common/CongViecs/{0}/{1}", query.CongViec.TimeId, result.ImageKhachHang1);
result.ImageKhachHang2 = string.IsNullOrWhiteSpace(result.ImageKhachHang2) ? "" : string.Format("/Common/CongViecs/{0}/{1}", query.CongViec.TimeId, result.ImageKhachHang2);
result.ImageKhachHang3 = string.IsNullOrWhiteSpace(result.ImageKhachHang3) ? "" : string.Format("/Common/CongViecs/{0}/{1}", query.CongViec.TimeId, result.ImageKhachHang3);
// Lấy danh sách hạng mục công việc
result.DanhSachHangMuc = await(from CongViecHangMuc in _congViecHangMucRepository.GetAll().Where(w => w.CongViecId == query.CongViec.Id)
join DanhMucHangMuc in _hangMucRepository.GetAll() on CongViecHangMuc.HangMucId equals DanhMucHangMuc.Id
select new CongViecHangMucDto
{
HangMucId = DanhMucHangMuc.Id,
Name = DanhMucHangMuc.Name,
DonViTinh = DanhMucHangMuc.DonViTinh,
SoLuong = CongViecHangMuc.SoLuong,
DonGia = CongViecHangMuc.DonGia,
ThanhTien = CongViecHangMuc.ThanhTien
}).ToListAsync();
// Tạm tính thành tiền của công việc bằng cách lấy tổng
result.ThanhTien = result.PhuPhi ?? 0 + result.DanhSachHangMuc.Sum(s => s.ThanhTien);
return(result);
}
