public ActionResult UploadRetail()
{
if (!this.permissionService.Authorize(StandardPermissionProvider.UpdateCustomerOrder))
{
return(AccessDeniedView());
}
HttpPostedFileBase file = Request.Files["retialfile"];
if (file != null)
{
Stream fileStream = file.InputStream;
XDocument doc = XDocument.Load(fileStream);
var nodes = doc.Descendants("sale_item");
List <PostRetail> retails = new List <PostRetail>();
foreach (var node in nodes)
{
PostRetail retail = new PostRetail();
string itemNo = node.Elements("item_number").Select(t => (string)t).FirstOrDefault();
var product = this.productService.GetProductByItemNo(itemNo);
string date = node.Elements("date").Select(t => (string)t).FirstOrDefault();
retail.ProductId = product.Id;
retail.StoreId = 0;// this need to update according the user
retail.Date = DateTime.ParseExact(date, "yyyyMMdd", new CultureInfo("zh-CN", true));
retail.Quantity = node.Elements("sale_quantity").Select(t => (double)t).FirstOrDefault();
retail.Price = node.Elements("sale_price").Select(t => (decimal)t).FirstOrDefault();
retail.Cost = node.Elements("cost_price").Select(t => (decimal)t).FirstOrDefault();
retails.Add(retail);
}
this.retailService.AddRecords(retails);
return(RedirectToAction("Retail"));
}
return(Json(null));
}
public void AddRecord(PostRetail retail)
{
this.retailRepository.Add(retail);
this.unitOfWork.Commit();
}
