protected void ButtonImport_Click(object sender, EventArgs e) { var uploader = new AddressUploadBatch(GetFileName(), CheckIgnoreErrorsInDataFile.Checked); uploader.DoBulkUpload(this.CheckBoxDeleteExisting.Checked); PanelImportSuccessful.Visible = true; PanelPreview.Visible = false; }
public void DisplayCantProceedBecauseOfGeocode(AddressUploadBatch latestBatch) { GeocodingProxy geoProxy = new GeocodingProxy(); LabelNumberAvailableGeocodes.Text = geoProxy.AvailableToday.ToString(); LabelNumberOfDesiredGeocodes.Text = latestBatch.GetDistinctAddressesInBatch().Count().ToString(); Panel1CantContinue.Visible = true; }
private void ViewData() { uploader = new AddressUploadBatch(GetFileName(), CheckIgnoreErrorsInDataFile.Checked); try { PanelUpload.Visible = false; PanelPreview.Visible = true; ButtonImport.Visible = true; var importValid = uploader.IsUploadValid(); if (!importValid) { DisplayFileImportError(); } GridViewExcel.DataSource = uploader.GetUploadedData(); GridViewExcel.DataBind(); foreach (GridViewRow thisRow in GridViewExcel.Rows) { var cell = thisRow.Cells[thisRow.Cells.Count - 1]; if (cell.Text.StartsWith("OK")) { cell.BackColor = Color.LightGreen; // cell.ForeColor = Color.White; } else if (cell.Text.StartsWith("ERROR")) { cell.BackColor = Color.DarkRed; cell.ForeColor = Color.White; } else { cell.BackColor = Color.LightGray; } } if (uploader._errorList.Count > 0) { throw new Exception(); ; } } catch (Exception ex) { DisplayFileImportError(); } }
private AddressUploadBatch CreateNewBatch() { var db = new TerritoryDBDataContext(); FileInfo thisFileInfo = new FileInfo(_fileName); // before uploading a new batch let's delete // any other batch that might be related to the same session (file name = session) var listToDelete = (from au in db.AddressUploadBatches where au.FileName == thisFileInfo.Name select au); db.AddressUploadBatches.DeleteAllOnSubmit(listToDelete); db.SubmitChanges(); // delete all uploads older than 1 day (to clean up the database) var cutoffDate = DateTime.Now.AddDays(-1); listToDelete = (from au in db.AddressUploadBatches where au.DateStarted < cutoffDate select au); db.AddressUploadBatches.DeleteAllOnSubmit(listToDelete); db.SubmitChanges(); var newBatch = new AddressUploadBatch(); newBatch.DateStarted = DateTime.Now; newBatch.Status = "STARTED"; newBatch.TerritoryId = CurrentUser.TerritoryId; newBatch.FileName = thisFileInfo.Name; db.AddressUploadBatches.InsertOnSubmit(newBatch); db.SubmitChanges(); return newBatch; }
private void BatchFinished(AddressUploadBatch batch) { var db = new TerritoryDBDataContext(); db.AddressUploadBatches.Attach(batch); batch.Status = "COMPLETED"; batch.DateCompleted = DateTime.Now; db.SubmitChanges(); }