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();
}
}
