protected void btnImportFromCsv_Click(object sender, EventArgs e) { if ( !csvFile.HasFile ) { Utils.AppendScript( "openPopUp( 'importCsv' );" ); Utils.AppendScript( "location.href='#dataproviders'" ); Utils.AppendScript( string.Format( "alert( '{0}' );", Resources.Messages.err_no_file_uploaded ) ); return; } IDataProviderSchemeMutableObject dataProviderScheme = GetDataProviderSchemeFromSession(); if (dataProviderScheme == null) return; List<csvDataProvider> dataProviders = new List<csvDataProvider>(); bool errorInUploading = false; try { string filenameWithoutExtension = string.Format("{0}_{1}_{2}", Path.GetFileName(csvFile.FileName).Substring(0, csvFile.FileName.Length - 4), Session.SessionID, DateTime.Now.ToString().Replace('/', '_').Replace(':', '_').Replace(' ', '_')); string filename = string.Format("{0}.csv", filenameWithoutExtension); string logFilename = string.Format("{0}.log", filenameWithoutExtension); csvFile.SaveAs(Server.MapPath("~/csv_dataproviderschemes_files/") + filename); StreamReader reader = new StreamReader(Server.MapPath("~/csv_dataproviderschemes_files/") + filename); StreamWriter logWriter = new StreamWriter(Server.MapPath("~/csv_dataproviderschemes_import_logs/") + logFilename, true); logWriter.WriteLine(string.Format("LOG RELATIVO A CARICAMENTO DEL DATA PROVIDER SCHEME [ ID => \"{0}\" AGENCY_ID => \"{1}\" VERSION => \"{2}\" ] | LINGUA SELEZIONATA: {3}\n", dataProviderScheme.Id.ToString(), dataProviderScheme.AgencyId.ToString(), dataProviderScheme.Version.ToString(), cmbLanguageForCsv.SelectedValue.ToString())); logWriter.WriteLine("-----------------------------------------------------------------------------------------------------------------------------\n"); reader.ReadLine(); string wrongRowsMessage = string.Empty; string wrongRowsMessageForUser = string.Empty; string wrongFileLines = string.Empty; int currentRow = 1; char separator = txtSeparator.Text.Trim().Equals( string.Empty ) ? ';' : txtSeparator.Text.Trim().ElementAt( 0 ); while (!reader.EndOfStream) { string currentFileLine = reader.ReadLine(); string[] fields = currentFileLine.Split( separator ); if (fields.Length != 3) { errorInUploading = true; wrongRowsMessage += string.Format(Resources.Messages.err_csv_import_line_bad_format, currentRow + 1); wrongRowsMessageForUser += string.Format(Resources.Messages.err_csv_import_line_bad_format_gui, currentRow + 1); wrongFileLines += string.Format( "{0}\n", currentFileLine ); logWriter.WriteLine(string.Format(Resources.Messages.err_csv_import_line_bad_format, currentRow + 1)); logWriter.Flush(); currentRow++; continue; } if (fields[0].Trim().Equals( "\"\"" ) || fields[0].Trim().Equals(string.Empty)) { errorInUploading = true; wrongRowsMessage += string.Format(Resources.Messages.err_csv_import_id_missing, currentRow + 1); wrongRowsMessageForUser += string.Format(Resources.Messages.err_csv_import_id_missing_gui, currentRow + 1); wrongFileLines += string.Format( "{0}\n", currentFileLine ); logWriter.WriteLine(string.Format(Resources.Messages.err_csv_import_id_missing, currentRow + 1)); logWriter.Flush(); currentRow++; continue; } if (fields[1].Trim().Equals( "\"\"" ) || fields[1].Trim().Equals(string.Empty)) { errorInUploading = true; wrongRowsMessage += string.Format(Resources.Messages.err_csv_import_name_missing, currentRow + 1); wrongRowsMessageForUser += string.Format(Resources.Messages.err_csv_import_name_missing_gui, currentRow + 1); wrongFileLines += string.Format( "{0}\n", currentFileLine ); logWriter.WriteLine(string.Format(Resources.Messages.err_csv_import_name_missing, currentRow + 1)); logWriter.Flush(); currentRow++; continue; } dataProviders.Add(new csvDataProvider(fields[0].ToString().Replace( "\"", string.Empty ), fields[1].ToString().Replace( "\"", string.Empty ), fields[2].ToString().Replace( "\"", string.Empty ))); currentRow++; } if ( !errorInUploading ) { logWriter.WriteLine("Andato tutto a buon fine con questo file!"); } else { lblImportCsvErrors.Text = wrongRowsMessageForUser; lblImportCsvWrongLines.Text = wrongFileLines; Utils.AppendScript("openP('importCsvErrors',500);"); } logWriter.Close(); reader.Close(); } catch (Exception ex) { Utils.AppendScript(string.Format("Upload status: The file could not be uploaded. The following error occured: {0}", ex.Message)); } foreach (csvDataProvider dataProvider in dataProviders) { IEnumerable<IDataProviderMutableObject> tmpDataProviders = (from dataProv in dataProviderScheme.Items where dataProvider.dataProvider == dataProv.Id select dataProv).OfType<IDataProviderMutableObject>(); IDataProviderMutableObject tmpDataProvider; if (!(tmpDataProviders.Count() > 0)) { tmpDataProvider = new DataProviderMutableCore(); tmpDataProvider.Id = dataProvider.dataProvider; tmpDataProvider.AddName(cmbLanguageForCsv.SelectedValue.ToString(), dataProvider.name); tmpDataProvider.AddDescription(cmbLanguageForCsv.SelectedValue.ToString(), dataProvider.description); dataProviderScheme.AddItem(tmpDataProvider); } else { tmpDataProvider = tmpDataProviders.First(); tmpDataProvider.Id = dataProvider.dataProvider; tmpDataProvider.AddName(cmbLanguageForCsv.SelectedValue.ToString(), dataProvider.name); tmpDataProvider.AddDescription(cmbLanguageForCsv.SelectedValue.ToString(), dataProvider.description); } } if (!SaveInMemory(dataProviderScheme)) return; BindData(); if ( !errorInUploading ) { Utils.ShowDialog( Resources.Messages.succ_operation ); } Utils.AppendScript("location.href='#dataproviders';"); }
protected void btnUpdateDataProvider_Click(object sender, EventArgs e) { // Get Input field string data_provider_id = txt_id_update.Text.Trim(); IList<ITextTypeWrapperMutableObject> data_provider_names = AddTextName_Update.TextObjectList; IList<ITextTypeWrapperMutableObject> data_provider_descs = AddTextDescription_Update.TextObjectList; // string code_order_str = txtUpdateCodeOrder.Text.Trim(); // Get Current Object Session IDataProviderSchemeMutableObject dataProviderScheme = GetDataProviderSchemeFromSession(); IEnumerable<IDataProviderMutableObject> _rc = (from x in dataProviderScheme.Items where x.Id == data_provider_id select x).OfType<IDataProviderMutableObject>(); if (_rc.Count() == 0) return; IDataProviderMutableObject dataProvider = _rc.First(); IDataProviderMutableObject _bDataProvider = new DataProviderMutableCore(); int indexDataProvider = dataProviderScheme.Items.IndexOf(dataProvider); int indexOrder = 0; try { #region DATAPROVIDER ID if (!data_provider_id.Equals(string.Empty) && ValidationUtils.CheckIdFormat(data_provider_id)) { _bDataProvider.Id = data_provider_id; } else { lblErrorOnUpdate.Text = Resources.Messages.err_id_format; Utils.AppendScript( "openPopUp('df-Dimension-update', 600 );" ); Utils.AppendScript("location.href= '#dataproviders';"); return; } #endregion #region DATAPROVIDER NAMES if (data_provider_names != null) { foreach (var tmpName in data_provider_names) { _bDataProvider.AddName(tmpName.Locale, tmpName.Value); } } else { lblErrorOnUpdate.Text = Resources.Messages.err_list_name_format; Utils.AppendScript( "openPopUp('df-Dimension-update', 600 );" ); Utils.AppendScript("location.href= '#dataproviders';"); return; } #endregion #region DATAPROVIDER DESCRIPTIONS if (data_provider_descs != null) { foreach (var tmpDescription in data_provider_descs) { _bDataProvider.AddDescription(tmpDescription.Locale, tmpDescription.Value); } } #endregion dataProviderScheme.Items.Remove(dataProvider); dataProviderScheme.Items.Insert(indexDataProvider, _bDataProvider); var canRead = dataProviderScheme.ImmutableInstance; } catch (Exception ex) // ERRORE GENERICO! { dataProviderScheme.Items.Remove(_bDataProvider); dataProviderScheme.Items.Insert(indexDataProvider, dataProvider); Utils.ShowDialog(Resources.Messages.err_agency_update, 300, Resources.Messages.err_title); Utils.AppendScript("location.href='#dataproviders';"); } if (!SaveInMemory(dataProviderScheme)) return; BindData(); lblErrorOnUpdate.Text = string.Empty; Utils.AppendScript("location.href='#dataproviders';"); }
private IDataProviderSchemeMutableObject InsertDataProviderInDataProviderscheme(IDataProviderSchemeMutableObject dataProviderScheme) { if (dataProviderScheme == null) return null; IDataProviderMutableObject dataProvider = new DataProviderMutableCore(); string data_provider_id = txt_id_new.Text.Trim(); IList<ITextTypeWrapperMutableObject> data_provider_names = AddTextName_new.TextObjectList; IList<ITextTypeWrapperMutableObject> data_provider_descs = AddTextDescription_new.TextObjectList; // string code_order_str = txtOrderNewCode.Text.Trim(); ----- ORDINE #region DATAPROVIDER ID if (ValidationUtils.CheckIdFormat(data_provider_id)) { dataProvider.Id = data_provider_id; } else { lblErrorOnNewInsert.Text = Resources.Messages.err_id_format; Utils.AppendScript( "openPopUp('df-Dimension', 600);" ); Utils.AppendScript("location.href= '#dataproviders';"); return null; } IEnumerable<IDataProviderMutableObject> dataProviders = (from c in dataProviderScheme.Items where c.Id == data_provider_id select c).OfType<IDataProviderMutableObject>(); if (dataProviders.Count() > 0) { lblErrorOnNewInsert.Text = Resources.Messages.err_id_exist; Utils.AppendScript( "openPopUp('df-Dimension', 600);" ); Utils.AppendScript("location.href= '#dataproviders';"); return null; } #endregion #region DATAPROVIDER NAMES if (data_provider_names != null) { foreach (var tmpName in data_provider_names) { dataProvider.AddName(tmpName.Locale, tmpName.Value); } } else { lblErrorOnNewInsert.Text = Resources.Messages.err_list_name_format; Utils.AppendScript( "openPopUp('df-Dimension', 600);" ); Utils.AppendScript("location.href= '#dataproviders';"); return null; } #endregion #region DATAPROVIDER DESCRIPTIONS if (data_provider_descs != null) { foreach (var tmpDescription in data_provider_descs) { dataProvider.AddDescription(tmpDescription.Locale, tmpDescription.Value); } } #endregion dataProviderScheme.Items.Add(dataProvider); try { // Ultimo controllo se ottengo Immutable istanze validazione completa var canRead = dataProviderScheme.ImmutableInstance; } catch (Exception ex) { dataProviderScheme.Items.Remove(dataProvider); return null; } return dataProviderScheme; }