public ActionResult UpdateFromExcelPopup()
{
var model = new UpdateFromExcelModel();
SelectListItem resource = new SelectListItem();
resource.Text = this._localizationService.GetResource("Admin.Common.Select");
resource.Value = "0";
model.AvailableManufacturers.Add(resource);
foreach (Manufacturer allManufacturer in this._manufacturerService.GetAllManufacturers(true))
{
//IList<SelectListItem> availableManufacturers1 = model.AvailableManufacturers;
SelectListItem name = new SelectListItem();
name.Text = allManufacturer.Name;
name.Value = allManufacturer.Id.ToString();
model.AvailableManufacturers.Add(name);
}
return(View("Nop.Plugin.Misc.UpdateFromExcel.Views.UpdateFromExcel.UpdateFromExcelPopup", model));
}
public ActionResult UpdateFromExcelPopup(UpdateFromExcelModel model)
{
if (!ModelState.IsValid)
{
return(View("Nop.Plugin.Misc.UpdateFromExcel.Views.UpdateFromExcel.UpdateFromExcelPopup", model));
}
model.Message = "";
if (model.ManufacturerId == 0)
{
SelectListItem resource = new SelectListItem();
resource.Text = this._localizationService.GetResource("Admin.Common.Select");
resource.Value = "0";
model.AvailableManufacturers.Add(resource);
foreach (Manufacturer allManufacturer in this._manufacturerService.GetAllManufacturers(true))
{
//IList<SelectListItem> availableManufacturers1 = model.AvailableManufacturers;
SelectListItem name = new SelectListItem();
name.Text = allManufacturer.Name;
name.Value = allManufacturer.Id.ToString();
model.AvailableManufacturers.Add(name);
}
model.Message = "Manufacturer seçilmedi!";
return(View("Nop.Plugin.Misc.UpdateFromExcel.Views.UpdateFromExcel.UpdateFromExcelPopup", model));
}
try
{
var file = Request.Files["importexcelfile"];
if (file != null && file.ContentLength > 0)
{
var mStream = new MemoryStream();
mStream = ImportProductsFromXlsx(file.InputStream, model.ManufacturerId);
try
{
byte[] bytes = null;
bytes = mStream.ToArray();
//_localizationService.GetResource("AF.Plugin.Misc.UpdateFromExcel.Updated");
return(File(bytes, "text/xls", "updatedProducts.xlsx"));
}
catch (Exception exc)
{
SelectListItem resource = new SelectListItem();
resource.Text = this._localizationService.GetResource("Admin.Common.Select");
resource.Value = "0";
model.AvailableManufacturers.Add(resource);
foreach (Manufacturer allManufacturer in this._manufacturerService.GetAllManufacturers(true))
{
//IList<SelectListItem> availableManufacturers1 = model.AvailableManufacturers;
SelectListItem name = new SelectListItem();
name.Text = allManufacturer.Name;
name.Value = allManufacturer.Id.ToString();
model.AvailableManufacturers.Add(name);
}
model.Message = exc.Message;
return(View("Nop.Plugin.Misc.UpdateFromExcel.Views.UpdateFromExcel.UpdateFromExcelPopup", model));
}
}
else
{
SelectListItem resource = new SelectListItem();
resource.Text = this._localizationService.GetResource("Admin.Common.Select");
resource.Value = "0";
model.AvailableManufacturers.Add(resource);
foreach (Manufacturer allManufacturer in this._manufacturerService.GetAllManufacturers(true))
{
//IList<SelectListItem> availableManufacturers1 = model.AvailableManufacturers;
SelectListItem name = new SelectListItem();
name.Text = allManufacturer.Name;
name.Value = allManufacturer.Id.ToString();
model.AvailableManufacturers.Add(name);
}
model.Message = _localizationService.GetResource("AF.Plugin.Misc.UpdateFromExcel.NotUpdated");
return(View("Nop.Plugin.Misc.UpdateFromExcel.Views.UpdateFromExcel.UpdateFromExcelPopup", model));
}
}
catch (Exception exc)
{
SelectListItem resource = new SelectListItem();
resource.Text = this._localizationService.GetResource("Admin.Common.Select");
resource.Value = "0";
model.AvailableManufacturers.Add(resource);
foreach (Manufacturer allManufacturer in this._manufacturerService.GetAllManufacturers(true))
{
//IList<SelectListItem> availableManufacturers1 = model.AvailableManufacturers;
SelectListItem name = new SelectListItem();
name.Text = allManufacturer.Name;
name.Value = allManufacturer.Id.ToString();
model.AvailableManufacturers.Add(name);
}
model.Message = exc.Message;
return(View("Nop.Plugin.Misc.UpdateFromExcel.Views.UpdateFromExcel.UpdateFromExcelPopup", model));
}
}
