public IActionResult GetOfferList()
{
try
{
var res = _repository.Offer.FindByCondition(c => c.Ddate == null)
.Include(c => c.OfferType)
.Include(c => c.ProductOffer).ThenInclude(c => c.Product)
.Select(c => new
{
c.Id,
c.Name,
FromDate = DateTimeFunc.TimeTickToMiladi(c.FromDate.Value),
ToDate = DateTimeFunc.TimeTickToMiladi(c.ToDate.Value),
c.MaximumPrice,
c.Value,
c.Description,
Type = c.OfferType.Name,
Status = c.DaDate == null ? "فعال" : "غیرفعال",
ProductList = c.ProductOffer.Select(x => string.Join('-', x.Product.Name)).FirstOrDefault()
}).OrderByDescending(c => c.Id).ToList();
_logger.LogData(MethodBase.GetCurrentMethod(), res, null);
return(Ok(res));
}
catch (Exception e)
{
_logger.LogError(e, MethodBase.GetCurrentMethod());
return(BadRequest(e.Message));
}
}
public IActionResult GetProductOfferHistoryList(long productId)
{
try
{
var offerlist = _repository.ProductOffer
.FindByCondition(c => c.Ddate == null && c.ProductId == productId)
.Select(c => c.OfferId);
var res = _repository.Offer
.FindByCondition(c => c.Ddate == null && offerlist.Contains(c.Id)).Include(c => c.OfferType)
.Select(c => new
{
c.Id,
c.Name,
FromDate = DateTimeFunc.TimeTickToMiladi(c.FromDate.Value),
ToDate = DateTimeFunc.TimeTickToMiladi(c.ToDate.Value),
c.MaximumPrice,
c.Value,
c.Description,
Type = c.OfferType.Name,
Status = c.DaDate == null ? "فعال" : "غیرفعال"
}).OrderByDescending(c => c.Id).ToList();
_logger.LogData(MethodBase.GetCurrentMethod(), res, null);
return(Ok(res));
}
catch (Exception e)
{
_logger.LogError(e, MethodBase.GetCurrentMethod());
return(BadRequest(e.Message));
}
}
public IActionResult GetCustomerRateList()
{
try
{
var res = _repository.ProductCustomerRate
.FindByCondition(c => c.Ddate == null && c.DaDate == null && c.Pid == null)
.Include(c => c.Product)
.Include(c => c.Customer)
.Include(c => c.FinalStatus)
.Select(c => new
{
c.Id,
c.Rate,
c.CommentDesc,
CommentDate = DateTimeFunc.TimeTickToMiladi(c.CommentDate.Value),
ProductName = c.Product.Name,
ProductCoding = c.Product.Coding,
CustomerName = c.Customer.Name + " " + c.Customer.Fname,
c.FinalStatusId,
Status = c.FinalStatus.Name
}).ToList();
_logger.LogData(MethodBase.GetCurrentMethod(), res, null);
return(Ok(res));
}
catch (Exception e)
{
_logger.LogError(e, MethodBase.GetCurrentMethod());
return(BadRequest(e.Message));
}
}
public IActionResult GetOfferFullInfoById(long offerId)
{
try
{
var offer = _repository.Offer.FindByCondition(c => c.Id == offerId).Include(c => c.OfferType).Select(c => new
{
c.Id,
c.Name,
FromDate = DateTimeFunc.TimeTickToMiladi(c.FromDate.Value),
ToDate = DateTimeFunc.TimeTickToMiladi(c.ToDate.Value),
c.MaximumPrice,
c.Value,
c.Description,
c.OfferCode,
c.UsedCount,
c.UsageCount,
c.UsageValue,
Type = c.OfferType.Name,
Status = c.DaDate == null ? "فعال" : "غیرفعال"
}).FirstOrDefault();
if (offer == null)
{
throw new BusinessException(XError.GetDataErrors.NotFound());
}
var productIdList = _repository.ProductOffer.FindByCondition(c => c.OfferId == offerId)
.Include(c => c.Product).Select(c => c.ProductId);
var productList = _repository.Product
.FindByCondition(c => productIdList.Contains(c.Id) && c.DaDate == null && c.Ddate == null)
.Include(c => c.CatProduct)
.Include(c => c.Seller)
.Select(c => new
{
c.Id,
c.Name,
c.Price,
c.Coding,
CatProduct = c.CatProduct.Name,
SellerName = c.Seller.Name + " " + c.Seller.Fname,
c.Count
}).ToList();
var res = new { Offer = offer, ProductList = productList };
_logger.LogData(MethodBase.GetCurrentMethod(), res, null, offerId);
return(Ok(res));
}
catch (Exception e)
{
_logger.LogError(e, MethodBase.GetCurrentMethod(), offerId);
return(BadRequest(e.Message));
}
}
public IActionResult GetCustomerOrderHistory(long customerId)
{
try
{
var res = _repository.CustomerOrder.FindByCondition(c => c.CustomerId == customerId)
.Include(c => c.FinalStatus)
.Select(c => new { c.OrderNo, OrderDate = DateTimeFunc.TimeTickToMiladi(c.OrderDate.Value), c.FinalPrice, Status = c.FinalStatus.Name }).ToList();
_logger.LogData(MethodBase.GetCurrentMethod(), res, null, customerId);
return(Ok(res));
}
catch (Exception e)
{
_logger.LogError(e, MethodBase.GetCurrentMethod(), customerId);
return(BadRequest(e.Message));
}
}
public IActionResult GetProductPackingTypeHistory(long productId)
{
try
{
var res = _repository.ProductPackingType.FindByCondition(c => c.Ddate == null && c.DaDate == null && c.ProductId == productId)
.Include(c => c.PackinggType)
.Select(c => new
{
c.PackinggType.Name,
CreationDate = DateTimeFunc.TimeTickToMiladi(c.Cdate.Value)
}).ToList();
_logger.LogData(MethodBase.GetCurrentMethod(), res, null, productId);
return(Ok(res));
}
catch (Exception e)
{
_logger.LogError(e, MethodBase.GetCurrentMethod(), productId);
return(BadRequest(e.Message));
}
}
public IActionResult GetCurrentSellerInfo()
{
try
{
var userId = ClaimPrincipalFactory.GetUserId(User);
var res = _repository.Seller.FindByCondition(c => c.UserId == userId).Select(c =>
new
{
c.Id, c.Name, c.Fname, c.MelliCode, c.Mobile, c.Email, Password = c.User.Hpassword,
BirthDate = DateTimeFunc.TimeTickToMiladi(c.Bdate.Value), c.ShabaNo
}).FirstOrDefault();
_logger.LogData(MethodBase.GetCurrentMethod(), res, null);
return(Ok(res));
}
catch (Exception e)
{
_logger.LogError(e, MethodBase.GetCurrentMethod());
return(BadRequest(e.Message));
}
}
public IActionResult BuyCardBoughtHistory(long productId)
{
try
{
var res = _repository.CustomerOrderProduct.FindByCondition(c => c.ProductId == productId && c.CustomerOrder.CustomerOrderPayment.Any(x => x.FinalStatusId == 25))
.Include(c => c.CustomerOrder).ThenInclude(c => c.Customer)
.Select(c => new
{
CustomerName = c.CustomerOrder.Customer.Name + c.CustomerOrder.Customer.Name,
OrderDate = DateTimeFunc.TimeTickToMiladi(c.CustomerOrder.OrderDate.Value),
c.CustomerOrder.OrderNo
}).ToList();
_logger.LogData(MethodBase.GetCurrentMethod(), res, null, productId);
return(Ok(res));
}
catch (Exception e)
{
_logger.LogError(e, MethodBase.GetCurrentMethod(), productId);
return(BadRequest(e.Message));
}
}
public MappingProfile()
{
var now = DateTime.Now.Ticks;
#region Color
CreateMap <ColorDto, Color>();
CreateMap <Color, ColorDto>();
#endregion
#region CatProduct
CreateMap <CatProduct, CatProductDto>();
CreateMap <CatProductDto, CatProduct>();
CreateMap <CatProduct, CatProductWithCountDto>()
.ForMember(u => u.ProductCount, opt => opt.MapFrom(x => x.Product.Where(y => y.DaDate == null && y.Ddate == null && y.FinalStatusId == 8).Count() + (x.InverseP.Sum(w => w.Product.Where(y => y.DaDate == null && y.Ddate == null && y.FinalStatusId == 8).Count()))));
#endregion
#region Slider
CreateMap <Slider, SliderDto>();
CreateMap <SliderDto, Slider>();
#endregion
#region SliderPlace
CreateMap <SliderPlace, SliderPlaceDto>();
CreateMap <SliderPlaceDto, SliderPlace>();
#endregion
#region PackingType
CreateMap <PackingTypeDto, PackingType>();
CreateMap <PackingType, PackingTypeDto>()
.ForMember(u => u.PackingTypeImage, opt => opt.MapFrom(x => x.PackingTypeImage));
#endregion
#region PackingTypeImage
CreateMap <PackingTypeImageDto, PackingTypeImage>();
CreateMap <PackingTypeImage, PackingTypeImageDto>();
#endregion
#region PostType
CreateMap <PostTypeDto, PostType>();
CreateMap <PostType, PostTypeDto>();
#endregion
#region FamousComments
CreateMap <FamousCommentsDto, FamousComments>();
CreateMap <FamousComments, FamousCommentsDto>();
#endregion
#region Parameters
CreateMap <ParametersDto, Parameters>();
CreateMap <Parameters, ParametersDto>();
#endregion
#region CatProductParameters
CreateMap <CatProductParameters, CatProductParametersDto>();
CreateMap <CatProductParametersDto, CatProductParameters>();
#endregion
#region ProductCatProductParameters
CreateMap <ProductCatProductParameters, ProductParamDto>()
.ForMember(u => u.ParameterName, opt => opt.MapFrom(x => x.CatProductParameters.Parameters.Name));
CreateMap <ProductParamDto, ProductCatProductParameters>();
#endregion
#region ProductImage
CreateMap <ProductImageDto, ProductImage>();
CreateMap <ProductImage, ProductImageDto>();
#endregion
#region Product
CreateMap <Product, ProductDto>()
.ForMember(u => u.CatProductName, opt => opt.MapFrom(x => x.CatProduct.Name))
.ForMember(u => u.SellerName, opt => opt.MapFrom(x => x.Seller.Name + " " + x.Seller.Fname))
.ForMember(u => u.FinalStatus, opt => opt.MapFrom(x => x.FinalStatus.Name))
.ForMember(u => u.LastSeenDate,
opt => opt.MapFrom(x => DateTimeFunc.TimeTickToShamsi(x.LastSeenDate.Value)))
.ForMember(u => u.Rating, opt => opt.MapFrom(x => x.ProductCustomerRate.Average(c => c.Rate)))
.ForMember(u => u.OfferId,
opt => opt.MapFrom(x =>
x.ProductOffer
.Where(c => c.FromDate < now && now < c.ToDate && c.DaDate == null &&
c.Ddate == null).Select(c => c.OfferId).FirstOrDefault()))
.ForMember(u => u.OfferPercent, opt => opt.MapFrom(x =>
x.ProductOffer
.Where(c => c.FromDate < now && now < c.ToDate && c.DaDate == null &&
c.Ddate == null).Select(c => c.Value).DefaultIfEmpty(0).FirstOrDefault()))
.ForMember(u => u.OfferAmount, opt => opt.MapFrom(x =>
(x.ProductOffer
.Where(c => c.FromDate < now && now < c.ToDate && c.DaDate == null &&
c.Ddate == null).Select(c => c.Value).DefaultIfEmpty(0).FirstOrDefault()) *
x.Price / 100))
.ForMember(u => u.PriceAftterOffer, opt => opt.MapFrom(x =>
x.Price - ((x.ProductOffer
.Where(c => c.FromDate < now && now < c.ToDate && c.DaDate == null &&
c.Ddate == null).Select(c => c.Value).DefaultIfEmpty(0)
.FirstOrDefault()) * x.Price /
100)))
.ForMember(u => u.OfferDeadLine, opt => opt.MapFrom(x =>
x.ProductOffer
.Where(c => c.FromDate < now && now < c.ToDate && c.DaDate == null &&
c.Ddate == null).Select(c => c.ToDate != null ? new DateTime(c.ToDate.Value) : new DateTime(1988, 12, 13)).FirstOrDefault()));
CreateMap <Product, ProductGeneralSearchResultDto>()
.ForMember(u => u.ProductId, opt => opt.MapFrom(x => x.Id))
.ForMember(u => u.ProductName, opt => opt.MapFrom(x => x.Name))
.ForMember(u => u.CatProductId, opt => opt.MapFrom(x => x.CatProduct.Id))
.ForMember(u => u.CatProductName, opt => opt.MapFrom(x => x.CatProduct.Name))
.ForMember(u => u.CatProductCode, opt => opt.MapFrom(x => x.CatProduct.Coding));
#endregion
#region ProductCustomerRate
CreateMap <ProductCustomerRate, ProductCustomerRateDto>()
.ForMember(u => u.CustomerName, opt => opt.MapFrom(x => x.Customer.Name + " " + x.Customer.Fname))
.ForMember(u => u.ProductCustomerRateImages, opt => opt.MapFrom(x => x.ProductCustomerRateImage));
#endregion
#region ProductCustomerRateImage
CreateMap <ProductCustomerRateImage, ProductCustomerRateImageDto>();
#endregion
#region ProductColor
CreateMap <ProductColor, ProductColorDto>()
.ForMember(u => u.ColorName, opt => opt.MapFrom(x => x.Color.Name))
.ForMember(u => u.ColorCode, opt => opt.MapFrom(x => x.Color.ColorCode));
CreateMap <ProductColorDto, ProductColor>();
#endregion
#region ProductPackingType
CreateMap <ProductPackingType, ProductPackingTypeDto>()
.ForMember(u => u.PackingTypeName, opt => opt.MapFrom(x => x.PackinggType.Name));
#endregion
#region CustomerAddress
CreateMap <CustomerAddress, CustomerAddressDto>()
.ForMember(u => u.CityName, opt => opt.MapFrom(x => x.City.Name))
.ForMember(u => u.ProvinceName, opt => opt.MapFrom(x => x.Province.Name));
CreateMap <CustomerAddressDto, CustomerAddress>();
#endregion
#region PaymentType
CreateMap <PaymentType, PaymentTypeDto>();
#endregion
#region Package
CreateMap <Package, PackageDto>()
.ForMember(u => u.StartDate,
opt => opt.MapFrom(x => DateTimeFunc.TimeTickToShamsi(x.StartDateTime.Value)))
.ForMember(u => u.EndDate, opt => opt.MapFrom(x => DateTimeFunc.TimeTickToShamsi(x.EndDateTime.Value)));
#endregion
#region PackageImage
CreateMap <PackageImage, PackageImageDto>();
#endregion
#region Offer
CreateMap <Offer, OfferDto>()
.ForMember(u => u.OfferId, opt => opt.MapFrom(x => x.Id))
.ForMember(u => u.CustomerOfferId, opt => opt.MapFrom(x => x.Id));
CreateMap <OfferDto, Offer>();
#endregion
#region CustomerOffer
CreateMap <CustomerOffer, OfferDto>()
.ForMember(u => u.OfferId, opt => opt.MapFrom(x => x.OfferId))
.ForMember(u => u.CustomerOfferId, opt => opt.MapFrom(x => x.Id));
#endregion
#region Location
CreateMap <Location, LocationDto>();
#endregion
#region CustomerOrderProduct
CreateMap <CustomerOrderProduct, CustomerOrderProductDto>()
.ForMember(u => u.SellerName, opt => opt.MapFrom(x => x.Seller.Name + " " + x.Seller.Fname))
.ForMember(u => u.StatusName, opt => opt.MapFrom(x => x.FinalStatus.Name))
.ForMember(u => u.PackingTypeName, opt => opt.MapFrom(x => x.PackingType.Name))
.ForMember(u => u.ProductImage, opt => opt.MapFrom(x => x.Product.CoverImageUrl));
CreateMap <CustomerOrderProduct, CustomerOrderProductSampleDto>()
.ForMember(u => u.CoverImage, opt => opt.MapFrom(x => x.Product.CoverImageUrl));
#endregion
#region CustomerOrder
CreateMap <CustomerOrder, CustomerOrderFullDto>()
.ForMember(u => u.DeliveryDate,
opt => opt.MapFrom(x =>
x.DeliveryDate == null ? "" : DateTimeFunc.TimeTickToShamsi(x.DeliveryDate.Value)))
.ForMember(u => u.OrderDate,
opt => opt.MapFrom(x =>
x.OrderDate == null ? "" : DateTimeFunc.TimeTickToShamsi(x.OrderDate.Value)))
.ForMember(u => u.SendDate,
opt => opt.MapFrom(x =>
x.SendDate == null ? "" : DateTimeFunc.TimeTickToShamsi(x.SendDate.Value)))
.ForMember(u => u.PaymentTypeName, opt => opt.MapFrom(x => x.PaymentType.Title))
.ForMember(u => u.PostTypeName, opt => opt.MapFrom(x => x.PostType.Title))
.ForMember(u => u.FinalStatus, opt => opt.MapFrom(x => x.FinalStatus.Name))
.ForMember(u => u.CustomerAddress,
opt => opt.MapFrom(x =>
x.CustomerAddress.Province.Name + " - " + x.CustomerAddress.City.Name + " - " +
x.CustomerAddress.Address))
.ForMember(u => u.CustomerMobile, opt => opt.MapFrom(x => x.Customer.Mobile))
.ForMember(u => u.CustomerName, opt => opt.MapFrom(x => x.Customer.Name + " " + x.Customer.Fname))
.ForMember(u => u.PaymentStatus,
opt => opt.MapFrom(x =>
x.CustomerOrderPayment.Where(c => c.Ddate == null && c.DaDate == null)
.OrderByDescending(c => c.TransactionDate).Select(c => c.FinalStatus.Name)
.FirstOrDefault()))
.ForMember(u => u.CustomerOrderProductsList, opt => opt.MapFrom(x => x.CustomerOrderProduct))
.ForMember(u => u.CustomerOrderPaymentList, opt => opt.MapFrom(x => x.CustomerOrderPayment));
CreateMap <CustomerOrder, CustomerOrderDto>()
.ForMember(u => u.DeliveryDate,
opt => opt.MapFrom(x =>
x.DeliveryDate == null ? "" : DateTimeFunc.TimeTickToShamsi(x.DeliveryDate.Value)))
.ForMember(u => u.OrderDate,
opt => opt.MapFrom(x =>
x.OrderDate == null ? "" : DateTimeFunc.TimeTickToShamsi(x.OrderDate.Value)))
.ForMember(u => u.SendDate,
opt => opt.MapFrom(x =>
x.SendDate == null ? "" : DateTimeFunc.TimeTickToShamsi(x.SendDate.Value)))
.ForMember(u => u.PaymentTypeName, opt => opt.MapFrom(x => x.PaymentType.Title))
.ForMember(u => u.PostTypeName, opt => opt.MapFrom(x => x.PostType.Title))
.ForMember(u => u.FinalStatus, opt => opt.MapFrom(x => x.FinalStatus.Name))
.ForMember(u => u.PaymentStatus,
opt => opt.MapFrom(x =>
x.CustomerOrderPayment.Where(c => c.Ddate == null && c.DaDate == null)
.OrderByDescending(c => c.TransactionDate).Select(c => c.FinalStatus.Name)
.FirstOrDefault()))
.ForMember(u => u.ProductList, opt => opt.MapFrom(x => x.CustomerOrderProduct));
#endregion
#region CustomerOrderPayment
CreateMap <CustomerOrderPayment, CustomerOrderPaymentDto>()
.ForMember(u => u.FinalStatus, opt => opt.MapFrom(x => x.FinalStatus.Name))
.ForMember(u => u.TransactionDate,
opt => opt.MapFrom(x =>
x.TransactionDate == null ? "---" : DateTimeFunc.TimeTickToShamsi(x.TransactionDate.Value)));
#endregion
#region Document
CreateMap <Document, DocumentDto>()
.ForMember(u => u.CatDocumentName,
opt => opt.MapFrom(x => x.CatDocument.Title));
CreateMap <DocumentDto, Document>();
#endregion
#region Work
CreateMap <Work, WorkDto>();
CreateMap <WorkDto, Work>();
#endregion
#region Customer
CreateMap <CustomerProfileDto, Customer>();
CreateMap <Customer, CustomerProfileDto>().ForMember(u => u.Bdate,
opt => opt.MapFrom(x => x.Bdate == null ? DateTime.Now.ToString() : DateTimeFunc.TimeTickToMiladi(x.Bdate.Value)));
#endregion
#region SellerDocument
CreateMap <SellerDocument, SellerDocumentDto>()
.ForMember(u => u.DocumentName,
opt => opt.MapFrom(x => x.Document.Title))
.ForMember(u => u.FianlStatus,
opt => opt.MapFrom(x => x.FianlStatus.Name));
#endregion
#region Seller
CreateMap <Seller, SellerFullInfoDto>()
.ForMember(u => u.Bdate,
opt => opt.MapFrom(x => x.Bdate == null ? DateTime.Now.ToString() : DateTimeFunc.TimeTickToMiladi(x.Bdate.Value)))
.ForMember(u => u.RegisterDate,
opt => opt.MapFrom(x => x.Cdate == null ? DateTime.Now.ToString() : DateTimeFunc.TimeTickToMiladi(x.Cdate.Value)))
.ForMember(u => u.AddressList,
opt => opt.MapFrom(x => x.SellerAddress))
.ForMember(u => u.DocumentList,
opt => opt.MapFrom(x => x.SellerDocument))
.ForMember(u => u.SellerId,
opt => opt.MapFrom(x => x.Id));
#endregion
#region SellerAddress
CreateMap <SellerAddress, SellerAddressDto>();
#endregion
#region DynamicForms
CreateMap <DynamiFormImage, DynamiFormImageDto>();
CreateMap <DynamiFormDto, DynamicForms>();
CreateMap <DynamicForms, DynamiFormDto>()
.ForMember(u => u.ImageList,
opt => opt.MapFrom(x => x.DynamiFormImage.Where(c => c.Ddate == null && c.DaDate == null)));
#endregion
#region SellerComment
CreateMap <SellerComment, SellerCommentDto>()
.ForMember(u => u.SellerName,
opt => opt.MapFrom(x => x.Seller.Name + " " + x.Seller.Fname))
.ForMember(u => u.CommentType,
opt => opt.MapFrom(x => x.CommentType == 1 ? "بیوگرافی" : "نظر"))
.ForMember(u => u.Status,
opt => opt.MapFrom(x => x.FinalStatus.Name))
.ForMember(u => u.ProfileImage,
opt => opt.MapFrom(x => x.Seller.ProfileImageUrl));
CreateMap <SellerCommentDto, SellerComment>();
#endregion
}