public void EditUserDetails(UserDetails insert) { using (var dbContext = new MultiplesEntities()) { var dtls = dbContext.UserDetails.Where(x => x.UserId == insert.UserId).FirstOrDefault(); //var newcardetail = dbContext.CarDetails.Where(x => x.Id == insert.UserId); dtls.UserId = insert.UserId; dtls.FullName = insert.FullName; dtls.UserEmail = insert.UserEmail; dtls.Address = insert.Address; dtls.PasswordHash = insert.PasswordHash; dtls.CivilIdNumber = insert.CivilIdNumber; var cars = dbContext.CarDetails.Where(x => x.UserId == insert.UserId).SingleOrDefault(); cars.CarLicense = insert.CarLicense; dbContext.Entry(dtls).State = EntityState.Modified; //if (cars.Count() > 0) //{ dbContext.Entry(cars).State = EntityState.Modified; //} dbContext.SaveChanges(); } }
public void GetDeleteDetail(int?id) { using (var dbContext = new MultiplesEntities()) { var user = dbContext.UserDetails.Where(x => x.UserId == id).FirstOrDefault(); var car = dbContext.CarDetails.Where(x => x.UserId == id).ToList(); user.IsActive = false; dbContext.Entry(user).State = EntityState.Modified; if (car.Count() > 0) { dbContext.CarDetails.RemoveRange(car) ; } dbContext.SaveChanges(); } }