public ActionResult ProcessManymoreXlsCsv(ImportO2SModel model) { model.Source = ImportO2SModel.FileSource.CSV; // char delimiter = CSV.SEMI_COLON_DELIMITER; ImportHelper pImportHelper = new ImportHelper(); try { if (ModelState.IsValid && !string.IsNullOrEmpty(model.FullFilePath)) { int total = 0, vita = 0; IList<ImportErrorModel> errorsList = new List<ImportErrorModel>(); vita = pImportHelper.ImportProcessing(model, out total, out errorsList, null, true, /*delimiter*/model.Separator); //if (model.IsUpdateMode) //{ // // ImportHelper pImportHelper = new ImportHelper(); // vita = pImportHelper.ImportManyMore(model.FullFilePath.ToString(), model, true, out total, delimiter); //} //else //{ // //TODO:delete test // if (!CustomerProspectBL.DeleteAllProspectForCGP(SessionManager.GetUserSession().idUser)) // throw new Exception("DeleteAllProspectForCGP"); // // pImportHelper = new ImportHelper(); // vita = pImportHelper.ImportManyMore(model.FullFilePath.ToString(), model, false, out total, delimiter); //} ViewBag.Message = string.Format("{0} {1} / {2}", LanguageData.GetContent("nb_ligne_importées"), vita, total); if (errorsList.Count > 0) { ViewBag.Errors = errorsList; } model.CanImportNewFile = true; return View("XlsCsv", model); } else ViewBag.Error = LanguageData.GetContent("verifier_champs_obligatoires"); } catch (Exception ex) { Log.AppendException(ex); ; ViewBag.Error = LanguageData.GetContent("erreur_import"); } if (model.Delimiter == "DEFAULT_DELIMITER") model.ColumnNames = new ImportHelper().GetCSVUsableColumnNames(model.FullFilePath, CSV.DEFAULT_DELIMITER); else model.ColumnNames = new ImportHelper().GetCSVUsableColumnNames(model.FullFilePath, CSV.SEMI_COLON_DELIMITER); return View("XlsCsv", model); }
public ActionResult ProcessImportExcel(ImportO2SModel model) { try { if (ModelState.IsValid && !string.IsNullOrEmpty(model.FullFilePath)) { int total = 0, vita = 0; int mode = Convert.ToInt32(Request["ImportMode"]); model.ImportMode = mode; IList<ImportErrorModel> errorsList = new List<ImportErrorModel>(); ImportHelper pImportHelper = new ImportHelper(); vita = pImportHelper.ImportProcessing(model, out total, out errorsList, model.SelectedSheetName); ViewBag.Message = string.Format("{0} {1} / {2}", LanguageData.GetContent("nb_ligne_importées"), vita, total); if (errorsList.Count > 0) { ViewBag.Errors = errorsList; } model.CanImportNewFile = true; return View("XlsCsv", model); } else ViewBag.Error = LanguageData.GetContent("verifier_champs_obligatoires"); } catch (Exception ex) { Log.AppendException(ex); ; ViewBag.Error = string.Format("{0} : {1}", LanguageData.GetContent("erreur_import"), ex.Message); } model.ColumnNames = new ImportHelper().GetUsableColumnNames(model.FullFilePath, model.SelectedSheetName); model.SheetNames = new ImportHelper().GetSheetNames(model.FullFilePath); model.IsSheetNameSelection = true; return View("XlsCsv", model); }
public ActionResult ProcessManymore(ImportO2SModel model) { //char delimiter = CSV.SEMI_COLON_DELIMITER; try { int mode = Convert.ToInt32(Request["ImportMode"]); model.ImportMode = mode; ImportHelper helper = new ImportHelper(); //TODO:REMOVE //correspondance des advisers //Dictionary<string, Guid> dicAdvisers = new Dictionary<string, Guid>(); //if (SessionManager.GetUserSession().IsAdmin()) //{ // //prendre et charger la liste de tous ces **** de client // List<FirmInstitutionAdviser> lstAdvisers = FirmInstitutionAdviserBL.GetAdvisers(SessionManager.GetFirmInstitutionSession(), false); // model.ListAdvisersFromDatabase = new List<SelectListItem>(); // foreach (var adviser in lstAdvisers) // { // model.ListAdvisersFromDatabase.Add(new SelectListItem() { Text = string.Format("{0}, {1}, {2}", adviser.User.UserName, adviser.User.UserFirstName, adviser.User.UserEmail), Value = adviser.User.idUser.ToString() }); // } // model.ListAdvisers = helper.GetListConseillerPrincicpal(model.FullFilePath,null,true, model.Separator); // //TODO : Otran ts mety ilay samy dropdown a // //prendre la correspondance des advisers selon l'admin // foreach (var importAdvisers in model.ListAdvisers) // { // string adviserKey = "Advisers_" + importAdvisers.Value.Replace(" ", "_"); // string adviserFromDatabaseKey = "AdvisersFromDatabase_" + importAdvisers.Value.Replace(" ", "_"); // if (!string.IsNullOrEmpty(Request.Params[adviserKey].ToString()) && !string.IsNullOrEmpty(Request.Params[adviserFromDatabaseKey].ToString())) // { // dicAdvisers.Add(/*importAdvisers.Value*/Request.Params[adviserKey], new Guid(Request.Params[adviserFromDatabaseKey])); // } // } //} if (ModelState.IsValid && !string.IsNullOrEmpty(model.FullFilePath)) { int total = 0, vita = 0; IList<ImportErrorModel> errorsList = new List<ImportErrorModel>(); //TODO:REMOVE DIC vita = helper.ImportProcessing(model, out total, out errorsList, null, true, /*delimiter*/model.Separator/*, dicAdvisers*/); ViewBag.Message = string.Format("{0} {1} / {2}", LanguageData.GetContent("nb_ligne_importées"), vita, total); if (errorsList.Count > 0) { ViewBag.Errors = errorsList; } model.CanImportNewFile = true; return View("ImportManyMore", model); } else { var errors = ModelState.Values.SelectMany(v => v.Errors); ViewBag.Error = LanguageData.GetContent("verifier_champs_obligatoires"); } } catch (Exception ex) { Log.AppendException(ex); ; ViewBag.Error = string.Format("{0} : {1}", LanguageData.GetContent("erreur_import"), ex.Message); } if (model.Delimiter == "DEFAULT_DELIMITER") model.ColumnNames = new ImportHelper().GetCSVUsableColumnNames(model.FullFilePath, CSV.DEFAULT_DELIMITER); else model.ColumnNames = new ImportHelper().GetCSVUsableColumnNames(model.FullFilePath, CSV.SEMI_COLON_DELIMITER); return View("ImportManyMore", model); }
public ActionResult ProcessImportO2Harvest(ImportO2SModel model) { try { ImportHelper pImportHelper = new ImportHelper(); //correspondance des advisers Dictionary<string, Guid> dicAdvisers = new Dictionary<string, Guid>(); if (SessionManager.GetUserSession().IsAdmin()) { //prendre et charger la liste de tous ces **** de client List<FirmInstitutionAdviser> lstAdvisers = FirmInstitutionAdviserBL.GetAdvisers(!model.idFirmInstitution.HasValue ? SessionManager.GetFirmInstitutionSession() : FirmInstitutionBL.GetFirmInstitutionByIdFirmInstitution(model.idFirmInstitution.Value), false); model.ListAdvisersFromDatabase = new List<SelectListItem>(); foreach (var adviser in lstAdvisers) { model.ListAdvisersFromDatabase.Add(new SelectListItem() { Text = string.Format("{0}, {1}, {2}", adviser.User.UserName, adviser.User.UserFirstName, adviser.User.UserEmail), Value = adviser.User.idUser.ToString() }); } model.ListAdvisers = pImportHelper.GetListConseillerPrincicpal(model.FullFilePath, model.SelectedSheetName); //TODO : Otran ts mety ilay samy dropdown a //prendre la correspondance des advisers selon l'admin foreach (var importAdvisers in model.ListAdvisers) { string adviserKey = "Advisers_" + importAdvisers.Value.Replace(" ", "_"); string adviserFromDatabaseKey = "AdvisersFromDatabase_" + importAdvisers.Value.Replace(" ", "_"); if (!string.IsNullOrEmpty(Request.Params[adviserKey].ToString()) && !string.IsNullOrEmpty(Request.Params[adviserFromDatabaseKey].ToString())) { dicAdvisers.Add(/*importAdvisers.Value*/Request.Params[adviserKey], new Guid(Request.Params[adviserFromDatabaseKey])); } } } if (ModelState.IsValid && !string.IsNullOrEmpty(model.FullFilePath)) { int mode = Convert.ToInt32(Request["ImportMode"]); model.ImportMode = mode; int total = 0, vita = 0; IList<ImportErrorModel> errorsList = new List<ImportErrorModel>(); //TODO:add DIC vita = pImportHelper.ImportProcessing(model, out total, out errorsList, model.SelectedSheetName, false, CSV.DEFAULT_DELIMITER, dicAdvisers); ViewBag.Message = string.Format("{0} {1} / {2}", LanguageData.GetContent("nb_ligne_importées"), vita, total); if (errorsList.Count > 0) { ViewBag.Errors = errorsList; } model.CanImportNewFile = true; return View("ImportO2Harvest", model); } else ViewBag.Error = LanguageData.GetContent("verifier_champs_obligatoires"); } catch (Exception ex) { Log.AppendException(ex); ; ViewBag.Error = string.Format("{0} : {1}", LanguageData.GetContent("erreur_import"), ex.Message); } model.ColumnNames = new ImportHelper().GetUsableColumnNames(model.FullFilePath, model.SelectedSheetName); model.SheetNames = new ImportHelper().GetSheetNames(model.FullFilePath); model.IsSheetNameSelection = true; return View("ImportO2Harvest", model); }