public Guid AddParish(string parishName, string parishNotes,
string deposited, string parentParish, int startYear, string parishCounty, int endYear, decimal parishX, decimal parishY)
{
Guid parishId = Guid.NewGuid();
parishName = parishName.Trim();
parentParish = parentParish.Trim();
using (var context = new GeneralModelContainer())
{
var parishs =
context.Parishs.Where(
o =>
o.ParishName.ToLower().Contains(parishName) &&
o.ParishRegistersDeposited.ToLower().Contains(deposited.ToLower()));
if (!parishs.Any())
{
var parish = new Parish
{
ParishId = parishId,
ParentParish = parentParish,
ParishCounty = parishCounty,
ParishEndYear = endYear,
ParishName = parishName,
ParishNotes = parishNotes,
ParishRegistersDeposited = deposited,
ParishStartYear = startYear,
ParishX = parishX,
ParishY = parishY
};
context.Parishs.Add(parish);
}
else
{
parishId = parishs.First().ParishId;
}
context.SaveChanges();
return parishId;
}
}
public Guid InsertParish(ServiceParish serviceParish)
{
using (var context = new GeneralModelContainer())
{
var parishId = Guid.NewGuid();
serviceParish.ParishId = parishId;
serviceParish.ParishName = serviceParish.ParishName.Trim();
serviceParish.ParishParent = serviceParish.ParishParent.Trim();
var parishs =
context.Parishs.Where(
o =>
o.ParishName.ToLower().Contains(serviceParish.ParishName) &&
o.ParishRegistersDeposited.ToLower().Contains(serviceParish.ParishDeposited.ToLower()));
if (!parishs.Any())
{
var parish = new Parish
{
ParishId = serviceParish.ParishId,
ParentParish = serviceParish.ParishParent,
ParishCounty = serviceParish.ParishCounty,
ParishEndYear = serviceParish.ParishEndYear,
ParishName = serviceParish.ParishName,
ParishNotes = serviceParish.ParishNote,
ParishRegistersDeposited = serviceParish.ParishDeposited,
ParishStartYear = serviceParish.ParishStartYear,
ParishX = (decimal) serviceParish.ParishLat,
ParishY = (decimal) serviceParish.ParishLong
};
context.Parishs.Add(parish);
}
else
{
parishId = parishs.First().ParishId;
serviceParish.ParishId = parishId;
}
context.SaveChanges();
return parishId;
}
}
