public string InsertManualAdditionDeletion(AdditionDeletionGridViewHolder data) { using (var dataAccess = new AdditionDeletionDataAccess()) { var selectedLocation = dataAccess.GetLocationId(data.LocationWwd); if (selectedLocation == null) { return("Invalid Locaiton Code Entered"); } var carGroupId = dataAccess.GetCarGroupId(selectedLocation.country, data.CarGroup); if (carGroupId == 0) { return("Invalid Car Group Entered"); } if (data.Addition) { var resAddition = new ResAddition { LocId = selectedLocation.dim_Location_id, CarGrpId = carGroupId, RepDate = data.RepDate, Value = data.Value }; dataAccess.InsertAddition(resAddition); } else { var resDeletion = new ResDeletion { LocId = selectedLocation.dim_Location_id, CarGrpId = carGroupId, RepDate = data.RepDate, Value = data.Value }; dataAccess.InsertDeletion(resDeletion); } dataAccess.Submit(); } return("Entry Added"); }
public void InsertAddition(ResAddition ra) { _dataContext.ResAdditions.InsertOnSubmit(ra); }
private void ParseRawData(IEnumerable <RawAdditionDeletionDataHolder> rawData, AdditionDeletionFileSummary adfs, string country) { adfs.Additions = new List <ResAddition>(); adfs.Deletions = new List <ResDeletion>(); Dictionary <string, int> validLocations; Dictionary <string, int> validCarGroups; using (var dataAccess = new AdditionDeletionDataAccess()) { validLocations = dataAccess.GetValidLocationsForCountry(country); validCarGroups = dataAccess.GetValidCarGroups(country); } foreach (var rd in rawData) { if (!validLocations.ContainsKey(rd.Location)) { adfs.RowsSkipped++; continue; } //var groupId = dataAccess.GetCarGroupId(location.country, rd.CarGroup); if (!validCarGroups.ContainsKey(rd.CarGroup)) { adfs.RowsSkipped++; continue; } DateTime repDate; var parseSucceeded = DateTime.TryParse(string.Format("{0} {1}", rd.Day, rd.Time), out repDate); if (!parseSucceeded) { adfs.RowsSkipped++; continue; } int number; parseSucceeded = int.TryParse(rd.Number, out number); if (!parseSucceeded) { adfs.RowsSkipped++; continue; } if (rd.AddDel == AdditionIdentifier) { var rAdd = new ResAddition { LocId = validLocations[rd.Location], CarGrpId = validCarGroups[rd.CarGroup], RepDate = repDate, Value = number }; adfs.Additions.Add(rAdd); adfs.ValidRows++; } else if (rd.AddDel == DeletionIdentifier) { var rDel = new ResDeletion { LocId = validLocations[rd.Location], CarGrpId = validCarGroups[rd.CarGroup], RepDate = repDate, Value = number }; adfs.Deletions.Add(rDel); adfs.ValidRows++; } else { adfs.RowsSkipped++; } } }