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