public void LoadMissingHoldingCosts() { List <string> missingCarGroups; using (var dataAccess = new LifecycleHoldingCostDataAccess(null)) { missingCarGroups = dataAccess.GetMissingHoldingCostCarGroups(22); } lblMissingList.Text = string.Join(", ", missingCarGroups); }
protected void btnLoad_Click(object sender, EventArgs e) { var parameters = ucParameters.GetParameters(); using (var dataAccess = new LifecycleHoldingCostDataAccess(parameters)) { var data = dataAccess.GetLifecycleHoldingCosts(); 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 LifecycleHoldingCostDataAccess(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 <LifecycleHoldingCostRow>(); 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 year = int.Parse(splitDataRow[0].Trim()); var month = DateTime.ParseExact(splitDataRow[1].Trim(), "MMM", CultureInfo.CurrentCulture).Month; var carGroup = splitDataRow[2].Trim(); var holdingCost = double.Parse(splitDataRow[3].Trim()); var monthDate = new DateTime(year, month, 1); var rawData = new LifecycleHoldingCostRow(monthDate) { CarGroup = carGroup, Cost = holdingCost, }; parsedData.Add(rawData); } } List <DataContext.LifecycleHoldingCost> dbEntities; using (var dataAccess = new LifecycleHoldingCostDataAccess(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 Holding Costs 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(); } }