public List <IQueryFilter> GetFilters()
{
var result = new List <IQueryFilter>();
var refObj = new MdMerchandisePrice();
if (!string.IsNullOrEmpty(this.MaVatTu))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refObj.MaVatTu),
Value = this.MaVatTu,
Method = FilterMethod.Like
});
}
if (!string.IsNullOrEmpty(this.MaDonVi))
{
result.Add(new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => refObj.UnitCode),
Value = this.MaDonVi,
Method = FilterMethod.Like
});
}
return(result);
}
public TransferObj <MdBoHangVm.Dto> GetDetails(string id)
{
var unitCode = _service.GetCurrentUnitCode();
var result = new TransferObj <MdBoHangVm.Dto>();
var temp = new MdBoHangVm.Dto();
var boHang = _service.FindById(id);
var chitietBoHang = _service.UnitOfWork.Repository <MdBoHangChiTiet>().DbSet;
if (boHang != null)
{
temp = Mapper.Map <MdBoHang, MdBoHangVm.Dto>(boHang);
var chiTietBoHang = chitietBoHang.Where(x => x.MaBoHang == boHang.MaBoHang).ToList();
temp.DataDetails = Mapper.Map <List <MdBoHangChiTiet>, List <MdBoHangVm.DtoDetail> >(chiTietBoHang);
if (temp.DataDetails.Count > 0)
{
var merchandisePriceService = _service.UnitOfWork.Repository <MdMerchandisePrice>();
foreach (var a in temp.DataDetails)
{
MdMerchandisePrice merchandisePrice = merchandisePriceService.DbSet.FirstOrDefault(x => x.MaVatTu.Equals(a.MaHang) && x.MaDonVi.Equals(unitCode));
if (merchandisePrice != null)
{
a.GiaMua = merchandisePrice.GiaMua;
a.GiaMuaVat = merchandisePrice.GiaMuaVat;
a.GiaBanLe = merchandisePrice.GiaBanLe;
a.GiaBanBuon = merchandisePrice.GiaBanBuon;
a.GiaBanLeVat = merchandisePrice.GiaBanLeVat;
a.GiaBanBuonVat = merchandisePrice.GiaBanBuonVat;
a.DonGia = merchandisePrice.GiaBanLeVat;
}
}
}
result.Data = temp;
result.Status = true;
}
return(result);
}
public MdMerchandise InsertDto(MdMerchandiseVm.MasterDto instance)
{
if (instance.UseGenCode)
{
instance.MaVatTu = SaveCode(instance.MaLoaiVatTu);
}
var strBarcode = isExistBarCode(instance.Barcode);
if (!string.IsNullOrEmpty(strBarcode))
{
throw new Exception("Barcode trùng:" + strBarcode);
}
var mer = UnitOfWork.Repository <MdMerchandise>().DbSet.FirstOrDefault(x => x.MaVatTu == instance.MaCha);
if (mer != null)
{
mer.TrangThaiCon = 10;
mer.ObjectState = ObjectState.Modified;
}
if (!string.IsNullOrEmpty(instance.ItemCode))
{
instance.ItemCode = SaveCodeCanDienTu();
}
instance.MaNCC = instance.MaKhachHang;
instance.TenHang = instance.TenVatTu;
instance.MaKhac = instance.MaVatTu;
var masterData = Mapper.Map <MdMerchandiseVm.MasterDto, MdMerchandise>(instance);
MdMerchandisePrice detailData = new MdMerchandisePrice();
detailData.MaVatTu = instance.MaVatTu;
detailData.MaDonVi = GetCurrentUnitCode();
detailData.GiaBanBuon = instance.GiaBanBuon;
detailData.GiaBanBuonVat = instance.GiaBanBuonVat;
detailData.GiaBanLe = instance.GiaBanLe;
detailData.GiaBanLeVat = instance.GiaBanLeVat;
detailData.GiaMua = instance.GiaMua;
detailData.GiaMuaVat = instance.GiaMuaVat;
detailData.GiaVon = instance.GiaVon;
detailData.TyLeLaiBuon = instance.TyLeLaiBuon;
detailData.TyLeVatRa = instance.TyLeVatRa;
detailData.TyLeVatVao = instance.TyLeVatVao;
detailData.TyLeLaiLe = instance.TyLeLaiLe;
detailData.SoTonMax = 0;
detailData.SoTonMin = 0;
detailData.UnitCode = GetCurrentUnitCode();
detailData.MaVatRa = instance.MaVatRa;
detailData.MaVatVao = instance.MaVatVao;
detailData.IState = "50";
detailData.Id = Guid.NewGuid().ToString();
detailData.ICreateBy = GetClaimsPrincipal().Identity.Name;
detailData.ICreateDate = DateTime.Now;
detailData.IUpdateBy = GetClaimsPrincipal().Identity.Name;
detailData.IUpdateDate = DateTime.Now;
string path = GetPhysicalPathImage() + masterData.MaVatTu + "\\";
masterData.PathImage = "/Upload/MerchandiseImage/" + masterData.MaVatTu + "/";
if (!string.IsNullOrEmpty(instance.AvatarName))
{
FileStream fs = new FileStream(path + instance.AvatarName, FileMode.Open, FileAccess.Read);
byte[] ImageData = new byte[fs.Length];
fs.Read(ImageData, 0, System.Convert.ToInt32(fs.Length));
fs.Close();
masterData.Avatar = ImageData;
}
masterData.IState = string.Format("{0}", (int)SyncEntityState.IsWaitingForSync);
masterData.ICreateBy = GetClaimsPrincipal().Identity.Name;
masterData.ICreateDate = DateTime.Now;
var result = Insert(masterData);
UnitOfWork.Repository <MdMerchandisePrice>().Insert(detailData);
return(result);
}
