public PreviewProfileModel logInUserCheck(string basic) { var db = new MyDBModels.DB(); try { var dataAccess = new ProfileDataAccess(); var userId = db.signUp.Where(s => s.BaseCode == basic).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(); var dateUtils = new DateUtils(); return(dataAccess.previewProfile(userId, 1)); /* * profileModel.Name = profileDbModel.Name; * profileModel.LastName = profileDbModel.LastName; * profileModel.City = profileDbModel.City; * profileModel.PhotoUrl = profileDbModel.PhotoUrl; * profileModel.Phone = profileDbModel.Phone; * profileModel.Email = profileDbModel.Email; * profileModel.TimeLastActive = profileDbModel.TimeLastActive;// dateUtils.calculateStateLastActivity(profileDbModel.TimeLastActive); * * return profileModel;*/ } catch (Exception exc) { return(null); } }
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)); }