public ActionResult ImportWholeSalerInventory(HttpPostedFileBase chooseFile)
{
if (chooseFile == null)
{
TempData["message"] = "Vui lòng chọn file";
return(RedirectToAction("ImportWholeSalerInventory", "Home", ViewBag.message));
}
if (Path.GetExtension(chooseFile.FileName) != ".xlsx" && Path.GetExtension(chooseFile.FileName) != ".xls")
{
TempData["message"] = "Định dạng file excel không hợp lệ";
return(RedirectToAction("ImportWholeSalerInventory", "Home", ViewBag.message));
}
ExcelPackage package = new ExcelPackage(chooseFile.InputStream);
DataTable Dt = ExcelPackageExtensions.ConvertToDataTable(package);
List <WholeSaler_Inventory> lstImport = Dt.DataTableToListBaseHeader <WholeSaler_Inventory>();
foreach (var imp in lstImport)
{
var entity = wholeSalerRepository.List.Where(x => x.InvtID == imp.InvtID &&
x.Period == imp.Period &&
x.WholeSalerID == imp.WholeSalerID).FirstOrDefault();
if (entity == null)
{
imp.LastUpdatedDateTime = DateTime.Now;
imp.CreatedDateTime = DateTime.Now;
wholeSalerRepository.InsertOrUpdate(imp);
}
}
return(View());
}
public ActionResult ImportTarget(HttpPostedFileBase chooseFile)
{
//string message = ValidationSellOut(chooseFile);
//if (!string.IsNullOrEmpty(message))
//{
// return RedirectToAction("ImportSellOut", "Home", message);
//}
if (chooseFile == null)
{
TempData["message"] = "Vui lòng chọn file";
return(RedirectToAction("ImportSellOut", "Home", ViewBag.message));
}
if (Path.GetExtension(chooseFile.FileName) != ".xlsx" && Path.GetExtension(chooseFile.FileName) != ".xls")
{
TempData["message"] = "Định dạng file excel không hợp lệ";
return(RedirectToAction("ImportSellOut", "Home", ViewBag.message));
}
ExcelPackage package = new ExcelPackage(chooseFile.InputStream);
DataTable Dt = ExcelPackageExtensions.ConvertToDataTable(package);
List <MT_SellOut> lstTarget = Dt.DataTableToListBaseHeader <MT_SellOut>();
if (Dt.Columns.Count > 8)
{
TempData["message"] = "Vui lòng chọn templete sell out để có thể import!";
return(RedirectToAction("ImportSellOut", "Home", ViewBag.message));
}
String salesOrg = lstTarget.ElementAt(0).SalesOrg;
if (salesOrg != "1100" && salesOrg != "1500")
{
TempData["message"] = "Vui lòng chọn templete out in để có thể import!";
return(RedirectToAction("ImportSellOut", "Home", ViewBag.message));
}
//lstTarget.RemoveAt(0);
int lineID = 0;
foreach (var item in lstTarget)
{
item.LineID = lineID;
item.CompanyCode = DMSEnum.CompanyCode;
sellOutRepository.InsertOrUpdate(item);
lineID++;
}
TempData["success"] = DMSEnum.Success;
return(RedirectToAction("ImportSellOut", "Home", ViewBag.message));
}
public ActionResult ImportPerform(HttpPostedFileBase chooseFile)
{
if (chooseFile == null)
{
TempData["message"] = "Vui lòng chọn file";
return(RedirectToAction("ImportSellOut", "Home", ViewBag.message));
}
if (Path.GetExtension(chooseFile.FileName) != ".xlsx" && Path.GetExtension(chooseFile.FileName) != ".xls")
{
TempData["message"] = "Định dạng file excel không hợp lệ";
return(RedirectToAction("ImportSellOut", "Home", ViewBag.message));
}
ExcelPackage package = new ExcelPackage(chooseFile.InputStream);
DataTable Dt = ExcelPackageExtensions.ConvertToDataTable(package);
//if (Dt.Columns.Count > 8)
//{
// TempData["message"] = "Vui lòng chọn templete sell out để có thể import!";
// return RedirectToAction("ImportSellOut", "Home", ViewBag.message);
//}
List <MT_SellOut> lstTarget = Dt.DataTableToListBaseHeader <MT_SellOut>();
String salesOrg = lstTarget.ElementAt(0).SalesOrg;
if (salesOrg != "1100" && salesOrg != "1500")
{
TempData["message"] = "Vui lòng chọn templete out in để có thể import!";
return(RedirectToAction("ImportSellOut", "Home", ViewBag.message));
}
//var db = new DemoEntities1();
//var lstEmp = db.sp_Employee_GetAll();
//List<SellOutViewModel> empViewModel = lstEmp.Select(c => new SellOutViewModel
//{
// EmployeeCode = c.EmployeeCode,
// EmployeeName = c.EmployeeName,
// SalesForceCode = c.SalesForceCode,
// Parentcode = c.Parentcode,
// SalesForceName = c.SalesForceName,
// SalesForceLevel = c.SalesForceLevel
//}).ToList();
//DataTable Dt11 = ExcelPackageExtensions.ToDataTable(empViewModel);
//--------------------------------------------------------
foreach (var item in lstTarget)
{
sellOutRepository.Update(item, x => x.Perform);
}
lstTarget = sellOutRepository.List.ToList();
foreach (var item in lstTarget)
{
item.Rate = Math.Round((Double.Parse(item.Perform) / Double.Parse(item.Target) * 100)).ToString();
sellOutRepository.Update(item, x => x.Rate);
}
var lstSalesForce = salesForceRepository.List.ToList();
string day = DateTime.Now.ToString("dd/MM/yyyy");
var result = lstSalesForce.Join(lstTarget,
dep => dep.EmployeeCode,
e => e.ID,
(e, dep) => new { e, dep })
.Select(i => new MT_SellOut
{
Day = day,
SalesOrg = i.dep.SalesOrg,
CustomerCode = i.dep.CustomerCode,
SalesRouteCode = i.dep.SalesRouteCode,
ID = i.dep.ID,
Name = i.dep.Name,
Store = i.dep.Store,
Target = i.dep.Target,
Perform = i.dep.Perform,
Rate = i.dep.Rate,
LineID = i.dep.LineID,
CompanyCode = DMSEnum.CompanyCode,
SalesForceLevel = i.e.SalesForceLevel,
ParentCode = i.e.ParentCode,
SalesForceCode = i.e.SalesForceCode
}
).OrderBy(x => x.LineID)
.ToList();
foreach (var item in result)
{
sellOutRepository.InsertOrUpdate(item);
}
DataTable Dt1 = ExcelPackageExtensions.ToDataTable(result);
return(View(Dt1));
}