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