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