public NvTonDauKyVm.ReportModel CreateReport(string id)
{
var result = new NvTonDauKyVm.ReportModel();
var exsit = FindById(id);
if (exsit != null)
{
result = Mapper.Map <NvVatTuChungTu, NvTonDauKyVm.ReportModel>(exsit);
var nhanvien = UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == exsit.ICreateBy).FirstOrDefault();
if (nhanvien != null)
{
result.Username = nhanvien.TenNhanVien != null ? nhanvien.TenNhanVien : "";
result.NameNhanVienCreate = nhanvien.TenNhanVien != null ? nhanvien.TenNhanVien : "";
}
var detailData = UnitOfWork.Repository <NvVatTuChungTuChiTiet>().DbSet.Where(x => x.MaChungTuPk == exsit.MaChungTuPk).ToList();
result.DataReportDetails = Mapper.Map <List <NvVatTuChungTuChiTiet>, List <NvTonDauKyVm.ReportDetailModel> >(detailData);
var customer = UnitOfWork.Repository <MdCustomer>().DbSet.FirstOrDefault(x => x.MaKH == result.MaKhachHang);
if (customer != null)
{
result.TenKhachHang = customer.TenKH;
result.DiaChiKhachHang = customer.DiaChi;
}
}
var unitCode = GetCurrentUnitCode();
var createDate = DateTime.Now;
result.CreateDay = createDate.Day;
result.CreateMonth = createDate.Month;
result.CreateYear = createDate.Year;
result.TenDonVi = CurrentSetting.GetUnitName(unitCode);
result.DiaChiDonVi = CurrentSetting.GetUnitAddress(unitCode);
return(result);
}
public NvNhapHangBanTraLaiVm.ReportModel CreateReport(string id)
{
var result = new NvNhapHangBanTraLaiVm.ReportModel();
var exsit = FindById(id);
if (exsit != null)
{
result = Mapper.Map <NvVatTuChungTu, NvNhapHangBanTraLaiVm.ReportModel>(exsit);
var detailData = UnitOfWork.Repository <NvVatTuChungTuChiTiet>().DbSet.Where(x => x.MaChungTuPk == exsit.MaChungTuPk).ToList();
result.DataReportDetails = Mapper.Map <List <NvVatTuChungTuChiTiet>, List <NvNhapHangBanTraLaiVm.ReportDetailModel> >(detailData);
var customer = UnitOfWork.Repository <MdCustomer>().DbSet.FirstOrDefault(x => x.MaKH == result.MaKhachHang);
if (customer != null)
{
result.TenKhachHang = customer.TenKH;
result.DienThoai = customer.DienThoai;
result.DiaChiKhachHang = customer.DiaChi;
}
var kho = UnitOfWork.Repository <MdWareHouse>().DbSet.FirstOrDefault(x => x.MaKho == result.MaKhoNhap);
if (kho != null)
{
result.TenKho = kho.TenKho;
}
}
var unitCode = GetCurrentUnitCode();
var createDate = DateTime.Now;
result.CreateDay = createDate.Day;
result.CreateMonth = createDate.Month;
result.CreateYear = createDate.Year;
result.TenDonVi = CurrentSetting.GetUnitName(unitCode);
result.DiaChiDonVi = CurrentSetting.GetUnitAddress(unitCode);
//GetNhanVien
if (HttpContext.Current != null && HttpContext.Current.User is ClaimsPrincipal)
{
var currentUser = (HttpContext.Current.User as ClaimsPrincipal);
var name = currentUser.Identity.Name;
var userName = UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == name).FirstOrDefault();
if (userName != null)
{
result.Username = userName.TenNhanVien;
}
else
{
result.Username = "******";
}
}
return(result);
}
public NvXuatKhacVm.ReportModel CreateReport(string id)
{
var _ParentUnitCode = GetParentUnitCode();
var result = new NvXuatKhacVm.ReportModel();
decimal sum = 0;
var exsit = FindById(id);
if (exsit != null)
{
result = Mapper.Map <NvVatTuChungTu, NvXuatKhacVm.ReportModel>(exsit);
var nhanvien = UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == exsit.ICreateBy).FirstOrDefault();
if (nhanvien != null)
{
result.NameNhanVienCreate = nhanvien.TenNhanVien != null ? nhanvien.TenNhanVien : "";
}
var detailData = UnitOfWork.Repository <NvVatTuChungTuChiTiet>().DbSet.Where(x => x.MaChungTuPk == exsit.MaChungTuPk).ToList();
result.DataReportDetails = Mapper.Map <List <NvVatTuChungTuChiTiet>, List <NvXuatKhacVm.ReportDetailModel> >(detailData);
var sup = UnitOfWork.Repository <MdSupplier>().DbSet.FirstOrDefault(x => x.MaNCC == result.MaKhachHang);
var cus = UnitOfWork.Repository <MdCustomer>().DbSet.FirstOrDefault(x => x.MaKH == result.MaKhachHang);
if (sup != null)
{
result.TenKhachHang = sup.TenNCC;
result.DiaChiKhachHang = sup.DiaChi;
}
else if (cus != null)
{
result.TenKhachHang = cus.TenKH;
result.DiaChiKhachHang = cus.DiaChi;
}
var typeR = UnitOfWork.Repository <MdTypeReason>().DbSet.FirstOrDefault(x => x.MaLyDo == result.MaLyDo);
if (typeR != null)
{
result.TenLyDo = typeR.TenLyDo;
}
if (exsit.TrangThai != 10)
{
List <NvXuatKhacVm.DtoDetail> listDetails = new List <NvXuatKhacVm.DtoDetail>();
var ky = CurrentSetting.GetKhoaSo(exsit.UnitCode);
var tableName = ProcedureCollection.GetTableName(ky.Year, ky.Period);
var MaKho = exsit.MaKhoXuat;
//string kyKeToan = _servicePeriod.GetKyKeToan((DateTime)phieu.NgayCT);
foreach (var value in result.DataReportDetails)
{
List <MdMerchandiseVm.DataXNT> data = ProcedureCollection.GetDataInventoryByCondition(exsit.UnitCode, MaKho, value.MaHang, tableName, _ParentUnitCode);
value.GiaVon = value.GiaVon;
value.DonGia = value.GiaVon;
value.ThanhTien = value.DonGia * value.SoLuong;
sum += (decimal)value.ThanhTien;
}
var tyLe = UnitOfWork.Repository <MdTax>().DbSet.Where(x => x.MaLoaiThue == exsit.VAT).Select(x => x.TaxRate).FirstOrDefault();
if (tyLe != null)
{
result.TienVat = sum * (tyLe / 100);
}
else
{
result.TienVat = 0;
}
result.ThanhTienTruocVat = sum;
result.ThanhTienSauVat = result.ThanhTienTruocVat + result.TienVat;
}
var warehouses = UnitOfWork.Repository <MdWareHouse>().DbSet;
var exportWareHouse = warehouses.FirstOrDefault(x => x.MaKho == result.MaKhoXuat);
result.TenKhoXuat = exportWareHouse != null ? exportWareHouse.TenKho : "";
}
var unitCode = GetCurrentUnitCode();
var createDate = DateTime.Now;
result.CreateDay = createDate.Day;
result.CreateMonth = createDate.Month;
result.CreateYear = createDate.Year;
result.TenDonVi = CurrentSetting.GetUnitName(unitCode);
result.DiaChiDonVi = CurrentSetting.GetUnitAddress(unitCode);
//GetNhanVien
if (HttpContext.Current != null && HttpContext.Current.User is ClaimsPrincipal)
{
var currentUser = (HttpContext.Current.User as ClaimsPrincipal);
var name = currentUser.Identity.Name;
var nhanVien = UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == name).FirstOrDefault();
if (nhanVien != null)
{
result.Username = nhanVien.TenNhanVien;
}
else
{
result.Username = "******";
}
}
return(result);
}