public NISIS_Ward CreateWard(NISIS_Ward NewEntry, string loginName)
{
var WardObj = (from p in dbContext.NISIS_Wards
where p.Description.Contains(NewEntry.Description)
select p).FirstOrDefault();
if (WardObj == null)
{
var newWard = new NISIS_Ward();
string NewWardNumber = (Convert.ToString(NewEntry.Description).Replace("Ward ", ""));
string NewWardCode = NewEntry.Description.Replace("Ward ", "00");
newWard.Description = NewEntry.Description;
newWard.Local_Municipality_Id = (from a in dbContext.Local_Municipalities
where a.Local_Municipality_Id == NewEntry.Local_Municipality.Local_Municipality_Id
select a.Local_Municipality_Id).FirstOrDefault();
newWard.Ward_Code = NewWardCode;
newWard.Ward_Number = NewWardNumber;
newWard.Date_Created = DateTime.Now;
newWard.Created_By = loginName;
newWard.Is_Active = true;
newWard.Is_Deleted = false;
dbContext.NISIS_Wards.Add(newWard);
dbContext.SaveChanges();
return(newWard);
}
else
{
return(null);
}
}
public NISIS_Ward EditWard(NISIS_Ward UpdatedObj, string loginName)
{
var WardObj = (from p in dbContext.NISIS_Wards
where p.NISIS_Ward_Id == UpdatedObj.NISIS_Ward_Id
select p).FirstOrDefault();
string NewWardNumber = (Convert.ToString(UpdatedObj.Description).Replace("Ward ", ""));
string NewWardCode = UpdatedObj.Description.Replace("Ward ", "00");
WardObj.Description = UpdatedObj.Description;
WardObj.Local_Municipality_Id = (from a in dbContext.Local_Municipalities
where a.Local_Municipality_Id == UpdatedObj.Local_Municipality.Local_Municipality_Id
select a.Local_Municipality_Id).FirstOrDefault();
WardObj.Ward_Code = NewWardCode;
WardObj.Ward_Number = NewWardNumber;
WardObj.Date_Last_Modified = DateTime.Now;
WardObj.Last_Modified_By = loginName;
dbContext.SaveChanges();
return(WardObj);
}