public IEnumerable <UserDetails> GetUserDetails() { using (var dbContext = new MultiplesEntities()) { //List<UserDetail> userDetails = dbContext.UserDetails.Where(x=> x.IsActive== true).ToList(); List <UserDetail> userDetails = dbContext.UserDetails.ToList(); List <CarDetail> carDetails = dbContext.CarDetails.ToList(); List <UserDetails> userViewModels = new List <UserDetails>(); foreach (var user in userDetails) { var data = new UserDetails { UserId = user.UserId, FullName = user.FullName, UserEmail = user.UserEmail, CivilIdNumber = user.CivilIdNumber, }; var cardetails = string.Join(",", carDetails.Where(x => x.UserId == user.UserId).Select(y => y.CarLicense).ToList()); data.CarLicense = cardetails; userViewModels.Add(data); } var c = userViewModels.Where(X => X.CarLicense != "").ToList(); return(c); } }
public EditViewModel GetEditDetails(int Id) { using (var us = new MultiplesEntities()) { var viewModel = us.UserDetails.Where(x => x.UserId == Id).FirstOrDefault(); var cardetails = us.CarDetails.Where(x => x.UserId == Id).Select(y => new CarDetailsInfo { Id = y.Id, CarLicense = y.CarLicense, }).ToList(); var userDetails = new EditViewModel { UserId = viewModel.UserId, UserEmail = viewModel.UserEmail, FullName = viewModel.FullName, CivilIdNumber = viewModel.CivilIdNumber }; userDetails.CarDetails.AddRange(cardetails); return(userDetails); } }
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(); } }
public void GetInsertDetail(UserDetails insert) { using (var dbContext = new MultiplesEntities()) { //string FileName = Path.GetFileNameWithoutExtension(insert.ImageFile.FileName); //string extension = Path.GetExtension(insert.ImageFile.FileName); //FileName = DateTime.Now.ToString("yyyyMMdd") + "-" + FileName.Trim() + extension; //string UploadPath = ConfigurationManager.AppSettings["UserImagePath"].ToString(); //insert.ProfilePic = UploadPath + FileName; //insert.ImageFile.SaveAs(insert.ProfilePic); //string fileName = Path.GetFileNameWithoutExtension(insert.ImageFile.FileName); //string extension = Path.GetExtension(insert.ImageFile.FileName); //fileName = fileName + DateTime.Now.ToString("yymmssfff") + "-" + fileName.Trim() + extension; //string UploadPath = ConfigurationManager.AppSettings["UserImagePath"].ToString(); //insert.ProfilePic = UploadPath + fileName; //insert.ImageFile.SaveAs(insert.ProfilePic); var user = new UserDetail() { FullName = insert.FullName, UserEmail = insert.UserEmail, PasswordHash = insert.PasswordHash, CivilIdNumber = insert.CivilIdNumber, DOB = insert.DOB, MobileNo = insert.MobileNo, Address = insert.Address, //RoleId = insert.RoleId, ProfilePic = insert.ProfilePic, CreatedDate = insert.CreatedDate, ModifiedDate = insert.ModifiedDate, IsNotificationActive = insert.IsNotificationActive, IsActive = insert.IsActive, DeviceId = insert.DeviceId, DeviceType = insert.DeviceType, FcmToken = insert.FcmToken, verify = insert.verify, VerifiedBy = insert.VerifiedBy, Area = insert.Area, Block = insert.Block, Street = insert.Street, Housing = insert.Housing, Floor = insert.Floor, NewPass = insert.NewPass, ConPass = insert.ConPass, Jadda = insert.Jadda, Reason = insert.Reason, ActivatedBy = insert.ActivatedBy, ActivatedDate = insert.ActivatedDate }; var car = new CarDetail() { CarLicense = insert.CarLicense, UserId = insert.UserId }; dbContext.UserDetails.Add(user); dbContext.CarDetails.Add(car); dbContext.SaveChanges(); } }