public HttpResponseMessage Create(HttpRequestMessage request, MonAnViewModel MonAnCategoryVm)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage response = null;
if (!ModelState.IsValid)
{
response = request.CreateResponse(HttpStatusCode.BadRequest, ModelState);
}
else
{
var newMonAn = new MonAn();
newMonAn.UpdateMonAn(MonAnCategoryVm);
newMonAn.NGAYTAOMOI = DateTime.Now;
//newMonAn.CreatedBy = User.Identity.Name;
_monAnService.Add(newMonAn);
_monAnService.Save();
var responseData = Mapper.Map <MonAn, MonAnViewModel>(newMonAn);
response = request.CreateResponse(HttpStatusCode.Created, responseData);
}
return response;
}));
}
public static void UpdateMonAn(this MonAn product, MonAnViewModel productVm)
{
product.MAMON = productVm.MAMON;
product.MADVTINH = productVm.MADVTINH;
product.MALOAI = productVm.MALOAI;
product.MAHINHANH = productVm.MAHINHANH;
product.TENGOI = productVm.TENGOI;
product.DONGIA = productVm.DONGIA;
product.MOTA = productVm.MOTA;
product.CACHLAM = productVm.CACHLAM;
product.NGAYTAOMOI = productVm.NGAYTAOMOI;
}
private List <MonAn> ReadMonAnFromExcel(string fullPath, int categoryId)
{
using (var package = new ExcelPackage(new FileInfo(fullPath)))
{
ExcelWorksheet workSheet = package.Workbook.Worksheets[1];
List <MonAn> listMonAn = new List <MonAn>();
MonAnViewModel MonAnViewModel;
MonAn MonAn;
decimal originalPrice = 0;
decimal price = 0;
decimal promotionPrice;
bool status = false;
bool showHome = false;
bool isHot = false;
int warranty;
for (int i = workSheet.Dimension.Start.Row + 1; i <= workSheet.Dimension.End.Row; i++)
{
MonAnViewModel = new MonAnViewModel();
MonAn = new MonAn();
MonAnViewModel.Name = workSheet.Cells[i, 1].Value.ToString();
MonAnViewModel.Alias = StringHelper.ToUnsignString(MonAnViewModel.Name);
MonAnViewModel.Description = workSheet.Cells[i, 2].Value.ToString();
if (int.TryParse(workSheet.Cells[i, 3].Value.ToString(), out warranty))
{
MonAnViewModel.Warranty = warranty;
}
decimal.TryParse(workSheet.Cells[i, 4].Value.ToString().Replace(",", ""), out originalPrice);
MonAnViewModel.OriginalPrice = originalPrice;
decimal.TryParse(workSheet.Cells[i, 5].Value.ToString().Replace(",", ""), out price);
MonAnViewModel.Price = price;
if (decimal.TryParse(workSheet.Cells[i, 6].Value.ToString(), out promotionPrice))
{
MonAnViewModel.PromotionPrice = promotionPrice;
}
MonAnViewModel.Content = workSheet.Cells[i, 7].Value.ToString();
MonAnViewModel.MetaKeyword = workSheet.Cells[i, 8].Value.ToString();
MonAnViewModel.MetaDescription = workSheet.Cells[i, 9].Value.ToString();
MonAnViewModel.CategoryID = categoryId;
bool.TryParse(workSheet.Cells[i, 10].Value.ToString(), out status);
MonAnViewModel.Status = status;
bool.TryParse(workSheet.Cells[i, 11].Value.ToString(), out showHome);
MonAnViewModel.HomeFlag = showHome;
bool.TryParse(workSheet.Cells[i, 12].Value.ToString(), out isHot);
MonAnViewModel.HotFlag = isHot;
MonAn.UpdateMonAn(MonAnViewModel);
listMonAn.Add(MonAn);
}
return(listMonAn);
}
}
private List <MonAn> ReadMonAnFromExcel(string fullPath, int categoryId)
{
using (var package = new ExcelPackage(new FileInfo(fullPath)))
{
ExcelWorksheet workSheet = package.Workbook.Worksheets[1];
List <MonAn> listMonAn = new List <MonAn>();
MonAnViewModel MonAnViewModel;
MonAn MonAn;
//decimal originaldonGia = 0;
float donGia = 0;
//decimal promotiondonGia;
//bool status = false;
//bool showHome = false;
//bool isHot = false;
//int warranty;
for (int i = workSheet.Dimension.Start.Row + 1; i <= workSheet.Dimension.End.Row; i++)
{
MonAnViewModel = new MonAnViewModel();
MonAn = new MonAn();
MonAnViewModel.TENGOI = workSheet.Cells[i, 1].Value.ToString();
//MonAnViewModel.Alias = StringHelper.ToUnsignString(MonAnViewModel.Name);
MonAnViewModel.MOTA = workSheet.Cells[i, 2].Value.ToString();
//if (int.TryParse(workSheet.Cells[i, 3].Value.ToString(), out warranty))
//{
// MonAnViewModel.Warranty = warranty;
//}
//decimal.TryParse(workSheet.Cells[i, 4].Value.ToString().Replace(",", ""), out originaldonGia);
//MonAnViewModel.OriginaldonGia = originaldonGia;
float.TryParse(workSheet.Cells[i, 3].Value.ToString().Replace(",", ""), out donGia);
MonAnViewModel.DONGIA = donGia;
//if (decimal.TryParse(workSheet.Cells[i, 6].Value.ToString(), out promotiondonGia))
//{
// MonAnViewModel.PromotiondonGia = promotiondonGia;
//}
MonAnViewModel.MOTA = workSheet.Cells[i, 4].Value.ToString();
MonAnViewModel.CACHLAM = workSheet.Cells[i, 5].Value.ToString();
//MonAnViewModel.MetaDescription = workSheet.Cells[i, 9].Value.ToString();
MonAnViewModel.MALOAI = categoryId;
//bool.TryParse(workSheet.Cells[i, 10].Value.ToString(), out status);
//MonAnViewModel.Status = status;
//bool.TryParse(workSheet.Cells[i, 11].Value.ToString(), out showHome);
//MonAnViewModel.HomeFlag = showHome;
//bool.TryParse(workSheet.Cells[i, 12].Value.ToString(), out isHot);
//MonAnViewModel.HotFlag = isHot;
MonAn.UpdateMonAn(MonAnViewModel);
listMonAn.Add(MonAn);
}
return(listMonAn);
}
}
