public string InsertNewAdditionsDeletions(List <ResAddition> ra, List <ResDeletion> rd, string country)
{
using (var dataAccess = new AdditionDeletionDataAccess())
{
try
{
dataAccess.ClearAdditionsAndDeletionsForCountry(country);
dataAccess.InsertAdditions(ra);
dataAccess.InsertDeletions(rd);
}
catch (Exception e)
{
return(e.Message);
}
dataAccess.Submit();
}
return("Additions and Deletions Successfully Uploaded");
}
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 UpdateAdditionDeletions(List <AdditionDeletionGridViewHolder> adData)
{
var additions = new List <ResAddition>();
var deletions = new List <ResDeletion>();
foreach (var d in adData)
{
if (d.Addition)
{
additions.Add(new ResAddition
{
Id = d.Identifier,
CarGrpId = d.CarGroupId,
LocId = d.LocationWwdId,
RepDate = d.RepDate,
Value = d.Value
});
}
else
{
deletions.Add(new ResDeletion
{
Id = d.Identifier,
CarGrpId = d.CarGroupId,
LocId = d.LocationWwdId,
RepDate = d.RepDate,
Value = d.Value
});
}
}
using (var dataAccess = new AdditionDeletionDataAccess())
{
dataAccess.AttachAdditions(additions);
dataAccess.AttachDeletions(deletions);
dataAccess.Submit();
}
}
public void DeleteAdditionDeletions(List <AdditionDeletionGridViewHolder> entitiesToDelete)
{
var ra = new List <ResAddition>();
var rd = new List <ResDeletion>();
foreach (var e in entitiesToDelete)
{
if (e.Addition)
{
ra.Add(new ResAddition
{
Id = e.Identifier,
CarGrpId = e.CarGroupId,
LocId = e.LocationWwdId,
RepDate = e.RepDate,
Value = e.Value
});
}
else
{
rd.Add(new ResDeletion
{
Id = e.Identifier,
CarGrpId = e.CarGroupId,
LocId = e.LocationWwdId,
RepDate = e.RepDate,
Value = e.Value
});
}
}
using (var dataAccess = new AdditionDeletionDataAccess())
{
dataAccess.DeleteAdditionsAndDeletions(ra, rd);
dataAccess.Submit();
}
}
