public string InsertManualBuffer(BufferGridViewHolder data) { using (var dataAccess = new BufferDataAccess()) { 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"); } var resBuffer = new ResBuffer { LocId = selectedLocation.dim_Location_id, CarGrpId = carGroupId, Value = data.Value }; dataAccess.InsertBuffer(resBuffer); dataAccess.Submit(); } return("Entry Added"); }
private void ParseRawData(IEnumerable <RawBufferHolder> rawData, BufferFileSummary bfs, string country) { bfs.Buffers = new List <ResBuffer>(); using (var dataAccess = new BufferDataAccess()) { foreach (var rd in rawData) { var location = dataAccess.GetLocationId(rd.Location); if (location == null || location.country != country) { bfs.RowsSkipped++; continue; } var groupId = dataAccess.GetCarGroupId(location.country, rd.CarGroup); if (groupId == 0) { bfs.RowsSkipped++; continue; } int number; var parseSucceeded = int.TryParse(rd.Number, out number); if (!parseSucceeded) { bfs.RowsSkipped++; continue; } var rAdd = new ResBuffer { LocId = location.dim_Location_id, CarGrpId = groupId, Value = number }; bfs.Buffers.Add(rAdd); bfs.ValidRows++; } } }
public void InsertBuffer(ResBuffer rb) { _dataContext.ResBuffers.InsertOnSubmit(rb); }