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 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 InsertSellerBio(string input) { try { var userId = ClaimPrincipalFactory.GetUserId(User); var sellerId = _repository.Seller.GetSellerIdByUserId(userId); if (sellerId == 0) { throw new BusinessException(XError.AuthenticationErrors.NotHaveRequestedRole()); } var sellerComment = new SellerComment { FinalStatusId = 37, Cdate = DateTime.Now.Ticks, CuserId = userId, CommentType = 1, SellerId = sellerId, Comment = input }; _repository.SellerComment.Create(sellerComment); _repository.Save(); _logger.LogData(MethodBase.GetCurrentMethod(), General.Results_.SuccessMessage(), null, input); return(Ok(General.Results_.SuccessMessage())); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod(), input); return(BadRequest(e.Message)); } }
public IActionResult GetProductById(long?sellerId, string productName) { try { var result = _repository.Product.FindByCondition(c => c.Ddate == null && c.DaDate == null && (c.SellerId == sellerId || sellerId == null) && (c.Name.Contains(productName) || string.IsNullOrWhiteSpace(productName))).Select(c => new { c.Id, c.Name, }).ToList(); _logger.LogData(MethodBase.GetCurrentMethod(), result, null, sellerId, productName); return(Ok(result)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod(), sellerId, productName); return(BadRequest(e.Message)); } }
public IActionResult GetCountryList() { try { var res = _repository.Location.FindByCondition(c => c.Ddate == null && c.DaDate == null && c.Pid == null).Select(c => new { c.Id, c.Name, c.LocationCode }).ToList(); _logger.LogData(MethodBase.GetCurrentMethod(), res, null, res); return(Ok(res)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod()); return(BadRequest(e.Message)); } }
public IActionResult GetStaticFormsList() { try { var res = _repository.DynamicForms.FindByCondition(c => c.DaDate == null && c.Ddate == null) .Include(c => c.DynamiFormImage) .OrderByDescending(c => c.Id).ToList(); var result = _mapper.Map <List <DynamiFormDto> >(res); _logger.LogData(MethodBase.GetCurrentMethod(), result, null); return(Ok(res)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod()); return(BadRequest(e.Message)); } }
public IActionResult GetComissionList() { try { var res = _repository.Comission.FindByCondition(c => c.DaDate == null && c.Ddate == null) .Include(c => c.ProductComission).ThenInclude(c => c.Product) .Select(c => new { c.Id, c.Description, c.Title, c.SendEmail, c.SendSms, c.FinalStatusId, c.Value, productList = c.ProductComission.Select(x => string.Join("-", x.Product.Name)) }) .AsNoTracking().ToList(); _logger.LogData(MethodBase.GetCurrentMethod(), res, null); return(Ok(res)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod()); return(BadRequest(e.Message)); } }
public IActionResult GetEmployeeList() { try { var res = _repository.Employee.FindByCondition(c => c.User.DaDate == null) .Include(c => c.User).ThenInclude(c => c.UserRole).ThenInclude(c => c.RoleNavigation) .Select(c => new { c.Id, c.User.FullName, RoleList = string.Join(',', c.User.UserRole.Select(x => x.RoleNavigation.Name).ToList()), Status = c.User.DaDate == null ? "فعال" : "غیرفعال" }) .ToList(); _logger.LogData(MethodBase.GetCurrentMethod(), res, null); return(Ok(res)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod()); return(BadRequest(e.Message)); } }
public IActionResult GetCustomerFavorites() { try { var userId = ClaimPrincipalFactory.GetUserId(User); var customerId = _repository.Customer.FindByCondition(c => c.UserId == userId).Select(c => c.Id) .FirstOrDefault(); var res = _repository.CustomerFavoriteProducts.FindByCondition(c => c.CustomerId == customerId) .Include(c => c.Product) .GroupBy(c => new { c.ProductId, c.Product.Name, c.Product.Coding }) .Select(c => new { c.Key.Name, c.Key.Coding, c.Key.ProductId, Count = c.Count() }).ToList(); _logger.LogData(MethodBase.GetCurrentMethod(), res, null); return(Ok(res)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod()); return(BadRequest(e.Message)); } }
public IActionResult GetImageListByProductId(long productId) { try { var res = _repository.ProductImage .FindByCondition(c => c.ProductId == productId && c.Ddate == null && c.DaDate == null).ToList(); _logger.LogData(MethodBase.GetCurrentMethod(), res, null); return(Ok(res)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod()); return(BadRequest(e.Message)); } }
public IActionResult GetRoleList() { try { var res = _repository.Role.FindByCondition(c => c.Ddate == null && c.DaDate == null) .Include(c => c.CatRole) .Select(c => new { c.Id, c.Name, c.Rkey, CatRole = c.CatRole.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 GetBuyCardsList() { try { var res = _repository.Product.FindByCondition(c => c.CatProduct.Rkey == 1 && c.Ddate == null) .Select(c => new { c.Id, c.Name, c.Count, c.Price, Status = c.DaDate == null ? "فعال" : "غیرفعال" }).ToList(); _logger.LogData(MethodBase.GetCurrentMethod(), res, null); return(Ok(res)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod()); return(BadRequest(e.Message)); } }
public IActionResult GetOrderStatusList() { try { var res = _repository.Status .FindByCondition(c => c.CatStatus.Tables.Any(x => x.Name == "CustomerOrder")) .Select(c => new { c.Id, c.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 InsertPackage([FromForm] InsertPackageDto input, [FromForm] FormFileCollection fileList) { try { var validator = new ParamValidator(); validator.ValidateNull(input.Name, General.Messages_.NullInputMessages_.GeneralNullMessage("عنوان")) .ValidateNull(input.Price, General.Messages_.NullInputMessages_.GeneralNullMessage("قیمت")) .Throw(General.Results_.FieldNullErrorCode()); if (input.ProductWithPriceList.Count == 0) { throw new BusinessException("محصولی برای پکیج انتخاب نشده است.", 4001); } var counter = (_repository.Product .FindByCondition(c => c.Coding.ToString().Substring(0, 8) == "11223344") .Count() + 1).ToString(); counter = counter.PadLeft(4, '0'); var newproduct = new Product { Name = input.Name, Price = input.Price, MetaDescription = input.MetaDesc, KeyWords = input.KeyWord, MetaTitle = input.MetaTitle, Coding = long.Parse("11223344" + counter), IsPackage = true, Cdate = DateTime.Now.Ticks, CuserId = ClaimPrincipalFactory.GetUserId(User) }; input.ProductWithPriceList.ForEach(c => { var newProductPackage = new ProductPackage() { Cdate = DateTime.Now.Ticks, CuserId = ClaimPrincipalFactory.GetUserId(User), DepProductId = c.ProductId, Price = c.Price }; newproduct.ProductPackageDepProduct.Add(newProductPackage); }); fileList.ForEach(c => { short fileType = 1; if (FileManeger.IsVideo(c)) { fileType = 2; } var uploadFileStatus = FileManeger.FileUploader(c, fileType, "ProductPackage"); if (uploadFileStatus.Status == 200) { var newProductImage = new ProductImage { Cdate = DateTime.Now.Ticks, CuserId = ClaimPrincipalFactory.GetUserId(User), ImageUrl = uploadFileStatus.Path, FileType = fileType }; newproduct.ProductImage.Add(newProductImage); } else { throw new BusinessException(uploadFileStatus.Path, 4009); } }); _repository.Product.Create(newproduct); _repository.Save(); _logger.LogData(MethodBase.GetCurrentMethod(), newproduct.Id, null, input, "****"); return(Ok(newproduct.Id)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod(), input, "****"); return(BadRequest(e.Message)); } }
public IActionResult GetPackingTypeList(long?languageId) { try { var res = _repository.PackingType.FindByCondition(c => c.DaDate == null && c.Ddate == null && (!languageId.HasValue || c.LanguageId == languageId)) .Include(c => c.PackingTypeImage) .Include(c => c.ProductPackingType) .Select(c => new { c.Id, c.Name, c.Price, c.Weight, c.Material, c.Count, c.ColorId, Image = c.PackingTypeImage.Where(c => c.Ddate == null && c.FileType == 2).Select(x => x.ImageFileUrl).FirstOrDefault(), ProductName = string.Join(',', c.ProductPackingType.Select(x => x.Product.Name).ToList()), Status = c.DaDate == null ? "فعال" : "غیرفعال" }).ToList(); _logger.LogData(MethodBase.GetCurrentMethod(), res, null); return(Ok(res)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod()); return(BadRequest(e.Message)); } }
public IActionResult GetFamousCommentsList() { try { var res = _repository.Seller.FindByCondition(c => c.DaDate == null && c.Ddate == null) .ToList(); _logger.LogData(MethodBase.GetCurrentMethod(), res, null); return(Ok(res)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod()); return(BadRequest(e.Message)); } }
public IActionResult GetCustomerListByFilter(CustomerListParam input) { try { var res = _repository.Customer.GetCustomerListByFilter(input); _logger.LogData(MethodBase.GetCurrentMethod(), res, null, input); return(Ok(res)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod(), input); return(BadRequest("")); } }
public IActionResult GetCatProductList_Admin() { try { var res = _repository.CatProduct.FindByCondition(c => c.DaDate == null && c.Ddate == null) .Select(c => new { c.Id, c.Name, c.Coding, c.Icon, c.Pid }).ToList(); _logger.LogData(MethodBase.GetCurrentMethod(), res, null); return(Ok(res)); } catch (Exception e) { _logger.LogError(e, MethodBase.GetCurrentMethod()); return(BadRequest(e.Message)); } }