public async Task <IHttpActionResult> GetAllDataTrade(string codeTrade)
{
TransferObj <NvGiaoDichQuayVm.DataDto> result = new TransferObj <NvGiaoDichQuayVm.DataDto>();
NvGiaoDichQuayVm.DataDto instance = new NvGiaoDichQuayVm.DataDto();
try
{
NvGiaoDichQuay data = _service.Repository.DbSet.FirstOrDefault(x => x.MaGiaoDich == codeTrade);
if (data != null)
{
instance = Mapper.Map <NvGiaoDichQuay, NvGiaoDichQuayVm.DataDto>(data);
instance = _serviceRetails.SetCustomer(instance);
instance.DataDetails = _serviceRetails.DataDetails(instance);
result.Data = instance;
result.Status = true;
return(Ok(result));
}
else
{
result.Data = new NvGiaoDichQuayVm.DataDto();
result.Status = false;
return(Ok(result));
}
}
catch (Exception)
{
result.Data = new NvGiaoDichQuayVm.DataDto();
result.Status = false;
return(Ok(result));
}
}
public List <IQueryFilter> GetFilters()
{
var result = new List <IQueryFilter>();
var refGiaoDich = new NvGiaoDichQuay();
if (!string.IsNullOrEmpty(this.MaQuayGiaoDich))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refGiaoDich.MaQuayBan),
Value = this.MaQuayGiaoDich,
Method = BuildQuery.Query.Types.FilterMethod.EqualTo
});
}
if (!string.IsNullOrEmpty(this.MaKhachHang))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refGiaoDich.MaKhachHang),
Value = this.MaKhachHang,
Method = BuildQuery.Query.Types.FilterMethod.EqualTo
});
}
if (!string.IsNullOrEmpty(this.MaKho))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refGiaoDich.MaQuayBan),
Value = this.MaKho,
Method = BuildQuery.Query.Types.FilterMethod.EqualTo
});
}
if (this.TuNgay.HasValue)
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refGiaoDich.NgayPhatSinh),
Value = this.TuNgay,
Method = BuildQuery.Query.Types.FilterMethod.GreaterThanOrEqualTo
});
}
if (this.DenNgay.HasValue)
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refGiaoDich.NgayPhatSinh),
Value = this.DenNgay.Value.AddDays(1),
Method = BuildQuery.Query.Types.FilterMethod.LessThan
});
}
return(result);
}
public async Task <IHttpActionResult> PostDetails(NvGiaoDichQuayVm.Dto data)
{
TransferObj <NvGiaoDichQuayVm.Dto> result = new TransferObj <NvGiaoDichQuayVm.Dto>();
NvGiaoDichQuayVm.Dto temp = new NvGiaoDichQuayVm.Dto();
NvGiaoDichQuay phieu = _service.Repository.DbSet.FirstOrDefault(x => x.MaGiaoDichQuayPK == data.MaGiaoDichQuayPK);
if (phieu != null)
{
temp = Mapper.Map <NvGiaoDichQuay, NvGiaoDichQuayVm.Dto>(phieu);
List <NvGiaoDichQuayChiTiet> chiTietPhieu = _service.UnitOfWork.Repository <NvGiaoDichQuayChiTiet>().DbSet.Where(x => x.MaGDQuayPK == phieu.MaGiaoDichQuayPK).ToList();
temp.DataDetails = Mapper.Map <List <NvGiaoDichQuayChiTiet>, List <NvGiaoDichQuayVm.DtoDetail> >(chiTietPhieu).ToList();
string unitcode = _service.GetCurrentUnitCode();
result.Data = temp;
result.Status = true;
return(Ok(result));
}
return(NotFound());
}
public async Task <IHttpActionResult> GetDataReport(string id)
{
TransferObj <NvGiaoDichQuayVm.Dto> result = new TransferObj <NvGiaoDichQuayVm.Dto>();
NvGiaoDichQuayVm.Dto temp = new NvGiaoDichQuayVm.Dto();
string _unitCode = _service.GetCurrentUnitCode();
string maGiaoDichQuay = id;
NvGiaoDichQuay phieu = _service.Repository.DbSet.FirstOrDefault(x => x.MaGiaoDich == maGiaoDichQuay && x.MaDonVi == _unitCode);
if (phieu != null)
{
temp = Mapper.Map <NvGiaoDichQuay, NvGiaoDichQuayVm.Dto>(phieu);
List <NvGiaoDichQuayChiTiet> chiTietPhieu =
_service.UnitOfWork.Repository <NvGiaoDichQuayChiTiet>()
.DbSet.Where(x => x.MaGDQuayPK == phieu.MaGiaoDichQuayPK)
.ToList();
temp.DataDetails =
Mapper.Map <List <NvGiaoDichQuayChiTiet>, List <NvGiaoDichQuayVm.DtoDetail> >(chiTietPhieu).ToList();
temp.DataDetails.ForEach(x =>
{
var obj = _service.UnitOfWork.Repository <MdMerchandise>().DbSet.FirstOrDefault(y => y.MaVatTu == x.MaVatTu && y.UnitCode == temp.MaDonVi);
if (obj != null)
{
x.TyLeVatVao = obj.TyLeVatVao.ToString();
}
});
string unitcode = _service.GetCurrentUnitCode();
result.Data = temp;
result.Status = true;
return(Ok(result));
}
else
{
result.Data = new NvGiaoDichQuayVm.Dto();
result.Message = "Không tìm thấy !";
result.Status = false;
}
return(Ok(result));
}
public List <IQueryFilter> GetFilters()
{
var result = new List <IQueryFilter>();
var refObj = new NvGiaoDichQuay();
if (!string.IsNullOrEmpty(this.MaGiaoDich))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refObj.MaGiaoDich),
Value = this.MaGiaoDich,
Method = FilterMethod.Like
});
}
if (!string.IsNullOrEmpty(this.MaNguoiTao))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refObj.MaNguoiTao),
Value = this.MaNguoiTao,
Method = FilterMethod.Like
});
}
if (!string.IsNullOrEmpty(this.NguoiTao))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refObj.NguoiTao),
Value = this.NguoiTao,
Method = FilterMethod.Like
});
}
if (!string.IsNullOrEmpty(this.MaQuayBan))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refObj.MaQuayBan),
Value = this.MaQuayBan,
Method = FilterMethod.Like
});
}
if (this.TuNgay.HasValue)
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refObj.NgayPhatSinh),
Value = this.TuNgay.Value,
Method = FilterMethod.GreaterThanOrEqualTo
});
}
if (this.DenNgay.HasValue)
{
result.Add(new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => refObj.NgayPhatSinh),
Value = this.DenNgay.Value.AddDays(1),
Method = FilterMethod.LessThan
});
}
return(result);
}
