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