Ejemplo n.º 1
0
        public virtual ActionResult IndexImport(FormCollection collection)
        {
            char CSV_SEPARATOR = ';';
            string featureTrueIndicator = Worki.Resources.Views.Shared.SharedString.Yes; // by default, it's false. It's true only for the string
            int nbCol = 5;
            bool isHeaderLine = false;
            if (collection.Get("importCsvHeader") != null && collection.Get("importCsvHeader") == "on")
                isHeaderLine = true;
            int nbLocalisationsAdded = 0;
            string listLocalisationsAlreadyInDB = "";
            var context = ModelFactory.GetUnitOfWork();
            var mRepo = ModelFactory.GetRepository<IMemberRepository>(context);
            var lRepo = ModelFactory.GetRepository<ILocalisationRepository>(context);
            foreach (string name in Request.Files)
            {
                try
                {
                    var postedFile = Request.Files[name];
                    if (postedFile == null || string.IsNullOrEmpty(postedFile.FileName))
                        continue;

                    int fileLen;
                    fileLen = postedFile.ContentLength;
                    byte[] input = new byte[fileLen];

                    StreamReader sr = new StreamReader(postedFile.InputStream, System.Text.Encoding.Default); // Using of encoding to don't loose french accents

                    // Because we can have a csv line in multiple line in files (because in a value, we can have line-return), we have to check it
                    string fullCSVLine = "";
                    while (sr.Peek() >= 0) // Read of each line of CSV file
                    {
                        fullCSVLine += sr.ReadLine();
                        string[] infosLocalisation = fullCSVLine.Split(CSV_SEPARATOR);

                        // We have not the full CSV line
                        if (infosLocalisation.Length < nbCol)
                            continue;

                        if (!isHeaderLine)
                        {
                            var locName = infosLocalisation[1];
                            var enDesc = infosLocalisation[3];

                            var loc = lRepo.Get(l => string.Compare(l.Name, locName, StringComparison.InvariantCultureIgnoreCase) == 0);

                            if (loc ==null)
                            {
                                listLocalisationsAlreadyInDB += "&bull; " + locName + "<br />";
                            }
                            else
                            {
                                loc.DescriptionEn = enDesc;
                                nbLocalisationsAdded++;
                            }
                        }
                        else
                            isHeaderLine = false; // because we have skipped the first line

                        fullCSVLine = ""; // Reinitialization because we have found the full CVS line

                    }
                    context.Commit();
                }
                catch (Exception ex)
                {
                    _Logger.Error("Edit", ex);
                    ModelState.AddModelError("", string.Format(Worki.Resources.Views.Shared.SharedString.AddLocError, nbLocalisationsAdded, ex.Message));
                    context.Complete();
                }
            }

            AdminImportViewModel viewModel = new AdminImportViewModel();
            viewModel.resultMessage = string.Format(Worki.Resources.Views.Shared.SharedString.LocAdded, nbLocalisationsAdded);
            viewModel.localisationsAlreadyInDB = listLocalisationsAlreadyInDB;
            return View(viewModel);
        }
Ejemplo n.º 2
0
 public virtual ActionResult IndexImportValidate(string result)
 {
     AdminImportViewModel viewModel = new AdminImportViewModel();
     viewModel.resultMessage = result;
     return View(viewModel);
 }
Ejemplo n.º 3
0
 public virtual ActionResult IndexImport()
 {
     AdminImportViewModel viewModel = new AdminImportViewModel();
     viewModel.resultMessage = "";
     return View(viewModel);
 }