private void deleteFriendFromDb(MyDBModels.DB db, MyDBModels.User fromDeleteUserModel, int deleteProfileId) { var friendArrayIdUpdate = fromDeleteUserModel.FriendIdArray.ToList(); friendArrayIdUpdate.Remove(deleteProfileId); fromDeleteUserModel.FriendIdArray = friendArrayIdUpdate.ToArray(); var dataAccess = new CommunicationDataAccess(); int communicationId = dataAccess.searchCommunication(fromDeleteUserModel.ProfileId, deleteProfileId); var communicationIdArray = fromDeleteUserModel.CommunicationIdArray; var communicationIdList = communicationIdArray.ToList(); communicationIdList.Remove(communicationId); fromDeleteUserModel.CommunicationIdArray = communicationIdList.ToArray(); if (fromDeleteUserModel.CommunicationPinIdArray.Contains(communicationId)) { var communicationPinIdArray = fromDeleteUserModel.CommunicationPinIdArray; var communicationPinIdList = communicationPinIdArray.ToList(); communicationPinIdList.Remove(communicationId); fromDeleteUserModel.CommunicationPinIdArray = communicationPinIdList.ToArray(); } db.SaveChanges(); }
public PreviewProfileModel signUpUserToDataBase(SignUpModel model, string baseData) { var db = new MyDBModels.DB(); if (db.signUp.Where(s => s.BaseCode == baseData).Count() > 0) { return(null); } MyDBModels.EveryDayProfileStatistics everyDayProfileStatistics = new MyDBModels.EveryDayProfileStatistics(); everyDayProfileStatistics.CountDistance = 0; everyDayProfileStatistics.MiddleSpeed = 0; everyDayProfileStatistics.TimeInTrip = TimeSpan.Zero; everyDayProfileStatistics.Calories = 0; everyDayProfileStatistics.TimeCreate = DateTime.Now; db.everyDayProfileStatistics.Add(everyDayProfileStatistics); db.SaveChanges(); MyDBModels.ProfileStatistics profileStatistics = new MyDBModels.ProfileStatistics(); profileStatistics.CountDistanceTotal = 0; profileStatistics.MiddleSpeedTotal = 0; profileStatistics.TimeInTripTotal = TimeSpan.Zero; profileStatistics.CaloriesTotal = 0; profileStatistics.CountDangerousSituation = 0; profileStatistics.CountAttemptedTheft = 0; profileStatistics.EveryDayProfileStatisticsIdArray = new int[] { db.everyDayProfileStatistics.OrderByDescending(i => i.EveryDayProfileStatisticsId).FirstOrDefault().EveryDayProfileStatisticsId }; db.profileStatistics.Add(profileStatistics); db.SaveChanges(); MyDBModels.Profile profile = new MyDBModels.Profile(); profile.Name = model.Name; profile.LastName = model.LastName; profile.PhotoUrl = new PhotoUtils().generateRundomUrlPhoto(); profile.Phone = model.Phone; profile.Email = model.Email; profile.City = model.City; profile.TimeLastActive = DateTime.Now; profile.ProfileStatisticsId = db.profileStatistics.OrderByDescending(i => i.ProfileStatisticsId).FirstOrDefault().ProfileStatisticsId; db.profile.Add(profile); db.SaveChanges(); MyDBModels.User user = new MyDBModels.User(); user.ProfileId = db.profile.OrderByDescending(i => i.ProfileId).FirstOrDefault().ProfileId; user.FriendIdArray = new int[] {}; user.CommunicationIdArray = new int[] {}; user.GroupIdArray = new int[] {}; user.ArduinoIdArray = new int[] {}; user.FirebaseToken = ""; user.FriendPossibleIdArray = new int[] {}; user.CommunicationPinIdArray = new int[] {}; db.user.Add(user); db.SaveChanges(); MyDBModels.SignUp signUp = new MyDBModels.SignUp(); signUp.BaseCode = baseData; signUp.LoginEncode = model.Login; signUp.PasswordEncode = model.Password; signUp.UserId = db.user.OrderByDescending(i => i.UserId).FirstOrDefault().UserId; db.signUp.Add(signUp); db.SaveChanges(); var dataAccess = new ProfileDataAccess(); var userId = db.signUp.Where(s => s.BaseCode == baseData).First().UserId; var profileId = db.user.Where(u => u.UserId == userId).First().ProfileId; var profileDbModel = db.profile.Where(p => p.ProfileId == profileId).First(); var profileModel = new ProfileModel(); return(dataAccess.previewProfile(userId, 1)); }