private void PopulateMissingRevenueEntries() { List <string> missingCarGroups; using (var dataAccess = new RevenueDataAccess(null)) { missingCarGroups = dataAccess.GetMissingRevenueCarGroups(22); } lblMissingList.Text = string.Join(", ", missingCarGroups); }
protected void btnLoad_Click(object sender, EventArgs e) { var parameters = ucParameters.GetParameters(); using (var dataAccess = new RevenueDataAccess(parameters)) { var data = dataAccess.GetRevenueData(); hfRecordCount.Value = data.Count.ToString(CultureInfo.InvariantCulture); ucMaxFactors.GridData = data; } upGrid.Update(); }
protected void btnUpload_Click(object sender, EventArgs e) { try { using (var dataAccess = new RevenueDataAccess(null)) { dataAccess.UploadDatabaseEntities(EntitiesToUpload); } lblFileUploadSummary1.Text = "File Successfully Uploaded"; lblFileUploadSummary2.Text = string.Empty; } catch (Exception ex) { lblFileUploadSummary1.Text = ex.ToString(); } }
private void ParseUploadedFile(HttpPostedFile file) { try { var fileData = new byte[file.ContentLength]; file.InputStream.Read(fileData, 0, file.ContentLength); var parsedData = new List <RevenueDatabaseRow>(); using (var ms = new MemoryStream(fileData)) { var sr = new StreamReader(ms); string dataRow; if (!sr.EndOfStream) { dataRow = sr.ReadLine(); //Skip Header Row } while (!sr.EndOfStream) { dataRow = sr.ReadLine(); if (dataRow == null) { continue; } var splitDataRow = dataRow.Split(','); var reportingDate = DateTime.Parse(splitDataRow[0]); var dwCountry = splitDataRow[1].Trim(); var locationCode = splitDataRow[2].Trim(); var carGroupCode = splitDataRow[3].Trim(); var commercialCarSegmentCode = splitDataRow[4].Trim(); var rentalCount = int.Parse(splitDataRow[5]); var daysDriven = double.Parse(splitDataRow[6]); var rtDays = int.Parse(splitDataRow[7]); var tranDays = int.Parse(splitDataRow[8]); var grossRev = double.Parse(splitDataRow[9]); var performanceRev = double.Parse(splitDataRow[10]); var rawData = new RevenueDatabaseRow { CarGroupCode = carGroupCode, CommercialCarSegmentCode = commercialCarSegmentCode, DaysDriven = daysDriven, DwCountry = dwCountry, LocationCode = locationCode, GrossRev = grossRev, PerformanceRevenue = performanceRev, RentalCount = rentalCount, ReportingDate = reportingDate, RtDays = rtDays, TranDays = tranDays }; parsedData.Add(rawData); } } List <DataContext.RevenueByCommercialCarSegment> dbEntities; using (var dataAccess = new RevenueDataAccess(null)) { dbEntities = dataAccess.MatchUploadToDatabaseEntities(parsedData); } var minDate = dbEntities.Min(d => d.MonthDate); var maxDate = dbEntities.Max(d => d.MonthDate); cbeUploadWarning.ConfirmText = string.Format("Confirming will wipe all Revenue entries from {0:MMM yyyy} onwards and replace them with Data from the selected file.", minDate); lblFileUploadSummary1.Text = string.Format("Date Range: {0:MMM-yyyy} - {1:MMM-yyyy}", minDate, maxDate); lblFileUploadSummary2.Text = string.Format("Rows Parsed: {0} Rows Matched: {1}", parsedData.Count, dbEntities.Count); EntitiesToUpload = dbEntities; } catch (Exception ex) { lblFileUploadSummary1.Text = ex.ToString(); } }