public JsonResult GetProductbyId(int productId)
{
var note = string.Empty;
var Messaging = new RenderMessaging();
var product = _context.shop_sanpham.Find(productId);
if (product == null)
{
Messaging.Data = new { result = "Sản phẩm không tồn tại." };
Messaging.isError = true;
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
var orderProduct = _context.soft_Order_Child.Where(o => o.ProductId == productId).ToList();
var orderedSup = orderProduct.FirstOrDefault(o =>
o.soft_Order.TypeOrder == (int)TypeOrder.OrderProduct &&
o.Status == (int)StatusOrder_Suppliers.Process);
if (orderedSup != null)
{
var productcheck = _context.shop_sanpham.Find(orderedSup.ProductId);
if (productcheck != null)
{
note += " Đơn hàng số " + orderedSup.OrderId + " đã đặt sản phẩm " + productcheck.tensp + " ngày " + orderedSup.soft_Order.DateCreate + ".";
}
}
var price = Mapper.Map <Product_PriceModel>(_context.soft_Channel_Product_Price.FirstOrDefault(o => o.ProductId == product.id && o.ChannelId == User.ChannelId));
var stocks = Mapper.Map <List <Product_StockModel> >(_context.soft_Branches_Product_Stock.Where(o => o.ProductId == product.id).ToList());
var stock = stocks.FirstOrDefault(o => o.BranchesId == User.BranchesId);
var productInfo = new Prodcut_Branches_PriceChannel
{
product_price = price ?? price,
product_stock = stock ?? stock,
product = Mapper.Map <ProductSampleModel>(product),
product_stocks = stocks
};
if (product.soft_Suppliers != null)
{
productInfo.product.SuppliersName = product.soft_Suppliers.Name;
}
if (product.soft_Branches_Product_Stock != null)
{
var stockbyBranches = product.soft_Branches_Product_Stock.FirstOrDefault(o => o.BranchesId == User.BranchesId);
if (stockbyBranches != null)
{
productInfo.product.Stock_Total = stockbyBranches.Stock_Total;
}
}
Messaging.Data = new { result = productInfo, note = note };
Messaging.isError = false;
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
public ActionResult RenderViewCreate(long orderId = 0)
{
if (orderId > 0)
{
var order = _context.soft_Order.FirstOrDefault(o => o.Id == orderId);
if (order != null)
{
var rs = new List <Prodcut_Branches_PriceChannel>();
foreach (var item in order.soft_Order_Child)
{
if (item.shop_sanpham.id > 0)
{
var product = _context.shop_sanpham.Find(item.shop_sanpham.id);
if (product != null)
{
var stocks = Mapper.Map <List <Product_StockModel> >(_context.soft_Branches_Product_Stock.Where(o => o.ProductId == product.id).ToList());
var stock = stocks.FirstOrDefault(o => o.BranchesId == User.BranchesId);
var productInfo = new Prodcut_Branches_PriceChannel
{
product_stock = stock ?? stock,
product = Mapper.Map <ProductSampleModel>(product),
product_stocks = stocks,
Total = item.Total.HasValue ? item.Total.Value : 1,
OrderFromId = orderId
};
if (product.soft_Suppliers != null)
{
productInfo.product.SuppliersName = product.soft_Suppliers.Name;
}
rs.Add(productInfo);
}
}
}
ViewBag.Products = Newtonsoft.Json.JsonConvert.SerializeObject(rs);
}
}
return(PartialView("~/Views/Shared/Partial/module/Order/OrderOutput/_Channel_Order_Output_Create.cshtml"));
}
public JsonResult GetProductbyIdForOrder(int productId)
{
var note = string.Empty;
var Messaging = new RenderMessaging();
var product = _context.shop_sanpham.Select(o => new ProductSampleModel
{
Barcode = o.Barcode,
tensp = o.tensp,
masp = o.masp,
id = o.id,
}).FirstOrDefault(o => o.id == productId);
if (product == null)
{
Messaging.Data = new { result = "Sản phẩm không tồn tại." };
Messaging.isError = true;
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
var price = _context.soft_Channel_Product_Price.FirstOrDefault(o =>
o.ProductId == product.id &&
o.ChannelId == User.ChannelId);
product.PriceChannel = 0;
if (price != null)
{
if (price.StartDate_Discount.HasValue &&
price.Enddate_Discount.HasValue &&
price.Price_Discount > 0)
{
var dateNow = DateTime.Now;
if (dateNow >= price.StartDate_Discount && dateNow < price.Enddate_Discount)
{
product.PriceChannel = price.Price_Discount.Value;
product.Price = price.Price;
}
else
{
if (price.Price > 0)
{
product.PriceChannel = price.Price;
}
}
}
else
{
if (price.Price > 0)
{
product.PriceChannel = price.Price;
}
}
}
//if (price != null && price.Price > 0)
// product.PriceChannel = price.Price;
//else
// product.PriceChannel = 0;
var productInfo = new Prodcut_Branches_PriceChannel
{
product = product
};
Messaging.Data = new { result = productInfo };
Messaging.isError = false;
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
public JsonResult GetProductby(PagingInfo pageinfo)
{
var Messaging = new RenderMessaging();
try
{
if (User == null || User.ChannelId <= 0)
{
Messaging.isError = true;
}
// var lstTmp = from product in _context.shop_sanpham select product;
var lstTmp = _context.shop_sanpham.Select(o => new ProductSampleModel
{
Barcode = o.Barcode,
tensp = o.tensp,
masp = o.masp,
CatalogId = o.CatalogId.HasValue ? o.CatalogId.Value : 0,
SuppliersId = o.SuppliersId.HasValue ? o.SuppliersId.Value : 0,
id = o.id,
Img = o.shop_image.FirstOrDefault().url,
PriceBase = o.PriceBase.HasValue ? o.PriceBase.Value : 0,
PriceCompare = o.PriceCompare.HasValue ? o.PriceCompare.Value : 0,
PriceInput = o.PriceInput.HasValue ? o.PriceInput.Value : 0,
PriceBase_Old = o.PriceBase_Old.HasValue ? o.PriceBase_Old.Value : 0,
Status = o.Status.HasValue ? o.Status.Value : 0,
StatusVAT = o.StatusVAT.HasValue ? o.StatusVAT.Value : 0,
DateCreate = o.DateCreate,
//PriceWholesale = o.PriceWholesale.HasValue ? o.PriceWholesale.Value : 0,
Stock_Sum = o.soft_Branches_Product_Stock.Any() ? o.soft_Branches_Product_Stock.Sum(p => p.Stock_Total) : 0
});
// IQueryable<shop_sanpham> lstTmp = _context.shop_sanpham;
#region Fillter
if (pageinfo.filterby != null && pageinfo.filterby.Count > 0)
{
foreach (var item in pageinfo.filterby)
{
var key = 0;
if (item.Fiter.Equals("Price") || item.Fiter.Equals("Stock"))
{
key = int.Parse(item.Name);
}
else
{
key = int.Parse(item.Value);
}
switch (item.Fiter)
{
case "Catalog":
lstTmp = lstTmp.Where(o => o.CatalogId > 0 && o.CatalogId.Equals(key));
break;
case "Suppliers":
lstTmp = lstTmp.Where(o => o.SuppliersId > 0 && o.SuppliersId.Equals(key));
break;
case "Status":
lstTmp = lstTmp.Where(o => o.Status > 0 && o.Status.Equals(key));
break;
case "VAT":
lstTmp = lstTmp.Where(o => o.StatusVAT > 0 && o.StatusVAT.Equals(key));
break;
case "Price":
if (item.Value == "Equals")
{
var soft_Prices = _context.soft_Channel_Product_Price.Where(o => o.Price == key &&
o.ChannelId == User.ChannelId).Select(o => o.ProductId);
lstTmp = lstTmp.Where(o => soft_Prices.Contains(o.id));
}
if (item.Value == "LessThan")
{
var soft_Prices = _context.soft_Channel_Product_Price.Where(o => o.Price < key &&
o.ChannelId == User.ChannelId).Select(o => o.ProductId);
lstTmp = lstTmp.Where(o => soft_Prices.Contains(o.id));
}
if (item.Value == "MoreThan")
{
var soft_Prices = _context.soft_Channel_Product_Price.Where(o => o.Price > key &&
o.ChannelId == User.ChannelId).Select(o => o.ProductId);
lstTmp = lstTmp.Where(o => soft_Prices.Contains(o.id));
}
break;
case "Stock":
var branchesId = int.Parse(item.Value2.ToString());
if (branchesId > 0)
{
if (item.Value == "Equals")
{
var soft_Stock = _context.soft_Branches_Product_Stock.Where(o => o.Stock_Total == key &&
o.BranchesId == branchesId).Select(o => o.ProductId);
if (key == 0)
{
var soft_StockNull = _context.soft_Branches_Product_Stock.Where(o => o.BranchesId == User.BranchesId).Select(o => o.ProductId);
lstTmp = lstTmp.Where(o => soft_Stock.Contains(o.id) || !soft_StockNull.Contains(o.id));
}
else
{
lstTmp = lstTmp.Where(o => soft_Stock.Contains(o.id));
}
}
if (item.Value == "LessThan")
{
var soft_Stock = _context.soft_Branches_Product_Stock.Where(o => o.Stock_Total < key &&
o.BranchesId == branchesId).Select(o => o.ProductId);
lstTmp = lstTmp.Where(o => soft_Stock.Contains(o.id));
}
if (item.Value == "MoreThan")
{
var soft_Stock = _context.soft_Branches_Product_Stock.Where(o => o.Stock_Total > key &&
o.BranchesId == branchesId).Select(o => o.ProductId);
lstTmp = lstTmp.Where(o => soft_Stock.Contains(o.id));
}
}
else
{
var sum_Stock = _context.soft_Branches_Product_Stock.GroupBy(o => o.ProductId).Select(o => new
{
productid = o.Key,
total = o.Sum(i => i.Stock_Total)
});
if (item.Value == "MoreThan")
{
var MoreThan = sum_Stock.Where(o => o.total > key).Select(o => o.productid);
lstTmp = lstTmp.Where(o => MoreThan.Contains(o.id));
}
if (item.Value == "LessThan")
{
var LessThan = sum_Stock.Where(o => o.total < key).Select(o => o.productid);
lstTmp = lstTmp.Where(o => LessThan.Contains(o.id));
}
if (item.Value == "Equals")
{
var Equals = sum_Stock.Where(o => o.total == key).Select(o => o.productid);
lstTmp = lstTmp.Where(o => Equals.Contains(o.id));
}
}
break;
}
}
}
#endregion
#region Sort
if (!string.IsNullOrEmpty(pageinfo.sortby))
{
switch (pageinfo.sortby)
{
case "DateCreate":
if (pageinfo.sortbydesc)
{
lstTmp = lstTmp.OrderByDescending(o => o.DateCreate);
}
else
{
lstTmp = lstTmp.OrderBy(o => o.DateCreate);
}
break;
case "Id":
if (pageinfo.sortbydesc)
{
lstTmp = lstTmp.OrderByDescending(o => o.id);
}
else
{
lstTmp = lstTmp.OrderBy(o => o.id);
}
break;
case "Barcode":
if (pageinfo.sortbydesc)
{
lstTmp = lstTmp.OrderByDescending(o => o.Barcode);
}
else
{
lstTmp = lstTmp.OrderBy(o => o.Barcode);
}
break;
case "PriceBase":
if (pageinfo.sortbydesc)
{
lstTmp = lstTmp.OrderByDescending(o => o.PriceBase);
}
else
{
lstTmp = lstTmp.OrderBy(o => o.PriceBase);
}
break;
case "PriceBase_Old":
if (pageinfo.sortbydesc)
{
lstTmp = lstTmp.OrderByDescending(o => o.PriceBase_Old);
}
else
{
lstTmp = lstTmp.OrderBy(o => o.PriceBase_Old);
}
break;
case "PriceCompare":
if (pageinfo.sortbydesc)
{
lstTmp = lstTmp.OrderByDescending(o => o.PriceCompare);
}
else
{
lstTmp = lstTmp.OrderBy(o => o.PriceCompare);
}
break;
case "PriceInput":
if (pageinfo.sortbydesc)
{
lstTmp = lstTmp.OrderByDescending(o => o.PriceInput);
}
else
{
lstTmp = lstTmp.OrderBy(o => o.PriceInput);
}
break;
case "ProductName":
if (pageinfo.sortbydesc)
{
lstTmp = lstTmp.OrderByDescending(o => o.tensp);
}
else
{
lstTmp = lstTmp.OrderBy(o => o.tensp);
}
break;
case "Code":
if (pageinfo.sortbydesc)
{
lstTmp = lstTmp.OrderByDescending(o => o.CatalogId);
}
else
{
lstTmp = lstTmp.OrderBy(o => o.CatalogId);
}
break;
case "StatusVAT":
if (pageinfo.sortbydesc)
{
lstTmp = lstTmp.OrderByDescending(o => o.StatusVAT);
}
else
{
lstTmp = lstTmp.OrderBy(o => o.StatusVAT);
}
break;
case "Stock_Sum":
if (pageinfo.sortbydesc)
{
lstTmp = lstTmp.OrderByDescending(o => o.Stock_Sum);
}
else
{
lstTmp = lstTmp.OrderBy(o => o.Stock_Sum);
}
break;
}
}
#endregion
var products = new List <ProductSampleModel>();
#region Search
if (!string.IsNullOrEmpty(pageinfo.keyword))
{
pageinfo.keyword = pageinfo.keyword.ToLower();
lstTmp = lstTmp.Where(o =>
(!string.IsNullOrEmpty(o.tensp) && o.tensp.Contains(pageinfo.keyword)) ||
(!string.IsNullOrEmpty(o.Barcode) && o.Barcode.Contains(pageinfo.keyword)) ||
(!string.IsNullOrEmpty(o.masp) && o.masp.Contains(pageinfo.keyword))
);
//lstTmp = lstTmp.Where(o =>
// (!string.IsNullOrEmpty(o.tensp) && Helpers.convertToUnSign3(o.tensp.ToLower()).Contains(pageinfo.keyword))
// || (!string.IsNullOrEmpty(o.Barcode) && Helpers.convertToUnSign3(o.Barcode.ToLower()).Contains(pageinfo.keyword))
// || (!string.IsNullOrEmpty(o.masp) && Helpers.convertToUnSign3(o.masp.ToLower()).Contains(pageinfo.keyword))
// );
}
#endregion
Channel_Paging <Prodcut_Branches_PriceChannel> lstInfo = new Channel_Paging <Prodcut_Branches_PriceChannel>();
int min = Helpers.FindMin(pageinfo.pageindex, pageinfo.pagesize);
lstInfo.totalItems = lstTmp.Count();
int quantity = Helpers.GetQuantity(lstInfo.totalItems, pageinfo.pageindex, pageinfo.pagesize);
// if (pageinfo.pagesize <= lstTmp.Count())
if (quantity > 0)
{
if (string.IsNullOrEmpty(pageinfo.sortby))
{
products = Mapper.Map <List <ProductSampleModel> >(lstTmp.OrderBy(o => o.tensp).ThenBy(o => o.masp).Skip(min).Take(quantity));
}
else
{
products = Mapper.Map <List <ProductSampleModel> >(lstTmp.Skip(min).Take(quantity));
}
}
// products = products.GetRange(min, quantity);
lstInfo.listTable = new List <Prodcut_Branches_PriceChannel>();
lstInfo.startItem = min;
foreach (var item in products)
{
var stocks = Mapper.Map <List <Product_StockModel> >(_context.soft_Branches_Product_Stock.Where(o => o.ProductId == item.id).ToList());
var stock = stocks.FirstOrDefault(o => o.BranchesId == User.BranchesId);
if (stock != null)
{
item.Stock_Total = stock.Stock_Total;
}
item.Stock_Sum = stocks.Sum(o => o.Stock_Total);
var productInfo = new Prodcut_Branches_PriceChannel
{
//product_price = price ?? price,
product_stock = stock ?? stock,
product = item,
product_stocks = stocks
};
var prices = _context.soft_Channel_Product_Price.Where(o => o.ProductId == item.id).ToList();
if (prices != null && prices.Count > 0)
{
var PriceMainStore = prices.FirstOrDefault(o => o.soft_Channel.Type == (int)TypeChannel.IsMainStore);
if (PriceMainStore != null)
{
item.PriceMainStore = PriceMainStore.Price;
}
var PriceSi = prices.FirstOrDefault(o => o.soft_Channel.Type == (int)TypeChannel.IsChannelWholesale);
if (PriceSi != null)
{
item.PriceWholesale = PriceSi.Price;
}
var price = Mapper.Map <Product_PriceModel>(prices.FirstOrDefault(o => o.ChannelId == User.ChannelId));
productInfo.product_price = price;
}
lstInfo.listTable.Add(productInfo);
}
Messaging.Data = lstInfo;
}
catch (Exception ex)
{
Messaging.isError = true;
Messaging.messaging = "Hiển thị danh sách sản phẩm không thành công!";
}
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
