public Local_Municipality CreateMunicipality(Local_Municipality NewEntry) { var MunicipalityObj = (from p in dbContext.Local_Municipalities where p.Description.Contains(NewEntry.Description) select p).FirstOrDefault(); if (MunicipalityObj == null) { //var newMunicipality = new Local_Municipalities(); //newMunicipality.Description = NewEntry.Description; //newMunicipality.Area_Id = (from a in dbContext.Areas // where a.District_Id== NewEntry.Area.District.District_Id // select a.Area_Id).FirstOrDefault(); //dbContext.Local_Municipalities.Add(newMunicipality); //dbContext.SaveChanges(); int MunicipalityId = (from s in dbContext.Local_Municipalities where s.Description == NewEntry.Description select s.Local_Municipality_Id).FirstOrDefault(); var NewLocalMunicipality = new Local_Municipality(); NewLocalMunicipality.Description = NewEntry.Description; NewLocalMunicipality.Local_Municipality_Id = MunicipalityId; dbContext.Local_Municipalities.Add(NewLocalMunicipality); dbContext.SaveChanges(); return(NewLocalMunicipality); } else { return(null); } }
public Local_Municipality EditMunicipality(Local_Municipality UpdatedObj) { var MunicipalityObj = (from p in dbContext.Local_Municipalities where p.Local_Municipality_Id == UpdatedObj.Local_Municipality_Id select p).FirstOrDefault(); MunicipalityObj.Description = UpdatedObj.Description; //MunicipalityObj.Area_Id = UpdatedObj.Area_Id; dbContext.SaveChanges(); var MunicipalityObj2 = (from p in dbContext.Local_Municipalities where p.Local_Municipality_Id == UpdatedObj.Local_Municipality_Id select p).FirstOrDefault(); MunicipalityObj2.Description = UpdatedObj.Description; dbContext.SaveChanges(); return(MunicipalityObj); }