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)); } }