public bool DeleteConstituency(int constituencyId, int adminId) { try { var constituency = this.dBContext.constituencies.FirstOrDefault(linq => linq.ConstituencyId == constituencyId && linq.IsDeleted == false); if (constituency != null) { constituency.AdminId = adminId; constituency.Modified = DateTime.Now; constituency.IsDeleted = true; var constituencyData = this.dBContext.constituencies.Attach(constituency); constituencyData.State = Microsoft.EntityFrameworkCore.EntityState.Modified; this.dBContext.SaveChanges(); if (constituencyData.State != 0) { var data = new AdminConstituency { ConstituencyId = constituencyId, AdminId = adminId }; this.dBContext.adminConstituencies.Add(data); this.dBContext.SaveChanges(); } return(true); } return(false); } catch (Exception e) { throw new Exception(e.Message); } }
public Constituency UpdateConstituency(int constituencyId, ConstituencyDataRequest constituencyDataRequest, int adminId) { Constituency constituency = this.dBContext.constituencies.FirstOrDefault(linq => linq.ConstituencyId == constituencyId && linq.IsDeleted == false); if (constituency != null) { constituency.AdminId = constituency.AdminId; constituency.City = constituencyDataRequest.City; constituency.ConstituencyName = constituencyDataRequest.ConstituencyName; constituency.State = constituencyDataRequest.State; constituency.Modified = DateTime.Now; var constituencyData = this.dBContext.constituencies.Attach(constituency); constituencyData.State = Microsoft.EntityFrameworkCore.EntityState.Modified; this.dBContext.SaveChanges(); if (constituencyData.State != 0) { var data = new AdminConstituency { ConstituencyId = constituencyId, AdminId = adminId }; this.dBContext.adminConstituencies.Add(data); this.dBContext.SaveChanges(); constituency.AdminResponses = Adminresponse(constituencyId); } return(constituency); } return(null); }