public IHttpActionResult AddParish(ServiceParishAdd serviceParishAdd)
{
string retVal = "";
var sp = new ServiceParish
{
ParishId = serviceParishAdd.ParishId.ToGuid(),
ParishStartYear = serviceParishAdd.ParishStartYear.ToInt32(),
ParishDeposited = serviceParishAdd.ParishDeposited ?? "",
ParishEndYear = serviceParishAdd.ParishEndYear.ToInt32(),
ParishLat = serviceParishAdd.ParishLat.ToDouble(),
ParishLong = serviceParishAdd.ParishLong.ToDouble(),
ParishName = serviceParishAdd.ParishName ?? "",
ParishNote = serviceParishAdd.ParishNote ??"",
ParishParent = serviceParishAdd.ParishParent??"",
ParishCounty = serviceParishAdd.ParishCounty ??""
};
try
{
_parishSearch.AddParish(sp, new ParishValidator { ServiceParish = sp });
}
catch (Exception ex1)
{
retVal = ex1.Message;
}
if (retVal != "")
{
return Content(HttpStatusCode.BadRequest, retVal);
}
return Ok(sp.ParishId);
}
public void AddParish(ServiceParish serviceParish, IValidator iValidator = null)
{
if (iValidator != null)
_validator = iValidator;
if (!_validator.ValidEntry()) throw new InvalidDataException(_validator.GetErrors()); ;
if (serviceParish.ParishId != Guid.Empty)
{
Edit(serviceParish);
}
else
{
Insert(serviceParish);
}
}
public string AddParish(string ParishId, string ParishStartYear, string ParishEndYear,
string ParishLat, string ParishLong,
string ParishName, string ParishParent,
string ParishNote, string ParishCounty, string ParishDeposited)
{
WebHelper.WriteParams(ParishId, ParishStartYear, ParishEndYear,
ParishLat, ParishLong,
ParishName, ParishParent,
ParishNote, ParishCounty, ParishDeposited);
string retVal = "";
var sp = new ServiceParish
{
ParishId = ParishId.ToGuid(),
ParishStartYear = ParishStartYear.ToInt32(),
ParishDeposited = ParishDeposited,
ParishEndYear = ParishEndYear.ToInt32(),
ParishLat = ParishLat.ToDouble(),
ParishLong = ParishLong.ToDouble(),
ParishName = ParishName,
ParishNote = ParishNote,
ParishParent = ParishParent,
ParishCounty = ParishCounty
};
try
{
_parishSearch.AddParish(sp, new ParishValidator { ServiceParish = sp });
}
catch (Exception ex1)
{
retVal = ex1.Message;
}
return WebHelper.MakeReturn(sp.ParishId.ToString(), retVal);
}
public void Insert(ServiceParish serviceParish)
{
if (!_iSecurity.IsValidInsert()) return;
_parishsDal.InsertParish(serviceParish);
}
public void Edit(ServiceParish serviceParish)
{
if (!_iSecurity.IsValidEdit()) return;
_parishsDal.UpdateParish(serviceParish);
}
public void UpdateParish(ServiceParish serviceParish)
{
using (var context = new GeneralModelContainer())
{
var parish = context.Parishs.First(o => o.ParishId == serviceParish.ParishId);
if (parish != null)
{
parish.ParishName = serviceParish.ParishName;
parish.ParentParish = serviceParish.ParishParent;
parish.ParishCounty = serviceParish.ParishCounty;
parish.ParishEndYear = serviceParish.ParishEndYear;
parish.ParishStartYear = serviceParish.ParishStartYear;
parish.ParishNotes = serviceParish.ParishNote;
parish.ParishX = (decimal) serviceParish.ParishLat;
parish.ParishY = (decimal) serviceParish.ParishLong;
parish.ParishRegistersDeposited = serviceParish.ParishDeposited;
}
context.SaveChanges();
}
}
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;
}
}
public ServiceParish GetParishById(Guid parishId)
{
using (var context = new GeneralModelContainer())
{
var pe = context.Parishs.FirstOrDefault(o => o.ParishId == parishId);
if (pe == null) return new ServiceParish();
var ret = new ServiceParish
{
ParishCounty = pe.ParishCounty,
ParishDeposited = pe.ParishRegistersDeposited,
ParishId = pe.ParishId,
ParishLat = (double) pe.ParishX.GetValueOrDefault(),
ParishLong = (double) pe.ParishY.GetValueOrDefault(),
ParishEndYear = pe.ParishEndYear,
ParishStartYear = pe.ParishStartYear,
ParishName = pe.ParishName,
ParishNote = pe.ParishNotes,
ParishParent = pe.ParentParish
};
return ret;
}
}
public IHttpActionResult GetParish(string id)
{
var parish = new ServiceParish();
string retVal = "";
try
{
parish = _parishSearch.GetParish(id.ToGuid());
}
catch (Exception ex1)
{
retVal = "Exception: " + ex1.Message;
}
if (retVal != "")
{
return Content(HttpStatusCode.BadRequest, retVal);
}
return Ok(parish.ParishId);
}
public ServiceParish GetParish(string parishId)
{
var parish = new ServiceParish();
string retVal = "";
try
{
parish = _parishSearch.GetParish(parishId.ToGuid());
}
catch (Exception ex1)
{
retVal = "Exception: " + ex1.Message;
}
finally
{
if (retVal != "") retVal += Environment.NewLine;
parish.ErrorStatus = retVal;
}
return parish;
}
