//historia połączeń public static string ShowHistory(string login) { string calls_string = ""; using (var db = new BlaBla_dbContext()) { var id_user = db.Users.Where(x => x.Login == login).Select(x => x.Id_User).FirstOrDefault(); List <VoiceHistory> calls; calls = db.VoiceHistories.Where(x => x.Id_Caller == id_user || x.Id_Receiver == id_user).ToList(); if (calls != null) { foreach (var item in calls) { string caller = db.Users.Where(x => x.Id_User == item.Id_Caller).Select(x => x.Login).FirstOrDefault(); string receiver = db.Users.Where(x => x.Id_User == item.Id_Receiver).Select(x => x.Login).FirstOrDefault(); calls_string += "|" + caller; calls_string += "|" + receiver; calls_string += "|" + item.Duration; calls_string += "|" + String.Format("{0:dd/MM/yy}", item.CallDate); } } } return(calls_string); }
//lista znajomych public static string ShowFriends(List <string> param) { string login1 = param[0]; //login1 string friends = ""; using (var db = new BlaBla_dbContext()) { var id_user1 = db.Users.Where(x => x.Login == login1).Select(x => x.Id_User).FirstOrDefault(); List <Friendship> acquainstance; //sprawdzenie pierwszej połówki acquainstance = db.Friendships.Where(x => x.Id_User1 == id_user1).ToList(); if (acquainstance != null) { foreach (var item in acquainstance) { var login2 = db.Users.Where(x => x.Id_User == item.Id_User2).Select(x => x.Login).FirstOrDefault(); friends += "|" + login2.ToString(); } } //sprawdzenie drugiej połówki acquainstance = db.Friendships.Where(x => x.Id_User2 == id_user1).ToList(); if (acquainstance != null) { foreach (var item in acquainstance) { var login2 = db.Users.Where(x => x.Id_User == item.Id_User1).Select(x => x.Login).FirstOrDefault(); friends += "|" + login2.ToString(); } } } return(friends); }
//logowanie public static Boolean LogIn(List <string> param) { string login = param[0]; string password = param[1]; using (var db = new BlaBla_dbContext()) { var userToEdit = db.Users.Where(x => x.Login == login && x.Password == password).FirstOrDefault(); if (userToEdit != null) { userToEdit.Status = true; try { db.Entry(userToEdit).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(true); } catch (DbUpdateConcurrencyException) { //Console.WriteLine("FAIL1"); //FAIL return(false); } } else { //Console.WriteLine("FAIL2"); //FAIL return(false); } } //OK //Console.WriteLine("OK"); }
//rejestracja public static Boolean Register(List <string> param) { using (var db = new BlaBla_dbContext()) { var newUser = new User(); string login = param[0]; int loginUnique = db.Users.Where(x => x.Login == login).Count(); if (loginUnique == 0) { newUser.Login = login; newUser.Password = param[1]; newUser.Status = false; db.Users.Add(newUser); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { //FAIL return(false); } } else { //FAIL return(false); } } //OK return(true); }
//dodawanie znajomego public static Boolean AddFriend(List <string> param) { string login1 = param[0]; //login1 string login2 = param[1]; //login2 using (var db = new BlaBla_dbContext()) { var acquaintance = new Friendship(); //find users IDs var userID1 = db.Users.Where(x => x.Login == login1).Select(x => x.Id_User).FirstOrDefault(); if (userID1 != 0) { var userID2 = db.Users.Where(x => x.Login == login2).Select(x => x.Id_User).FirstOrDefault(); if (userID2 != 0) { var acq = db.Friendships.Where(x => x.Id_User1 == userID1 && x.Id_User2 == userID2).FirstOrDefault(); if (acq == null) { acquaintance.Id_User1 = userID1; acquaintance.Id_User2 = userID2; try { db.Friendships.Add(acquaintance); db.SaveChanges(); } catch (DbUpdateConcurrencyException) { Console.WriteLine("FAIL1"); //FAIL return(false); } } else { Console.WriteLine("FAIL2"); //FAIL return(false); } } else { Console.WriteLine("FAIL3"); //FAIL return(false); } } else { Console.WriteLine("FAIL4"); //FAIL return(false); } } //OK return(true); }
public static void display_users() { using (var db = new BlaBla_dbContext()) { // Display all Blogs from the database var query = from b in db.Users orderby b.Login select b; Console.WriteLine("______________________USERS______________________"); Console.WriteLine("Id \tLogin \tStatus \tHaslo "); foreach (var item in query) { Console.WriteLine(item.Id_User + "\t" + item.Login + "\t" + item.Status + "\t" + item.Password); } } }
//search public static string Search(string search) { string wynik = ""; using (var db = new BlaBla_dbContext()) { var list_user = db.Users.ToList(); foreach (var item in list_user) { if (item.Login.Contains(search)) { wynik += "|" + item.Login; } } } return(wynik); }
//dodanie info o połączeniu public static Boolean addVoiceHistory(List <string> param) { string caller = param[0]; string receiver = param[1]; TimeSpan duration = TimeSpan.Parse(param[2]); DateTime date = DateTime.Now; using (var db = new BlaBla_dbContext()) { VoiceHistory vh = new VoiceHistory(); vh.Id_Caller = db.Users.Where(x => x.Login == caller).Select(x => x.Id_User).FirstOrDefault(); vh.Id_Receiver = db.Users.Where(x => x.Login == receiver).Select(x => x.Id_User).FirstOrDefault(); vh.Duration = duration; vh.CallDate = date; db.VoiceHistories.Add(vh); db.SaveChanges(); } return(true); }
//zmiana hasła public static Boolean ChangePass(List <string> param) { string login = param[0]; string oldpass = param[1]; string newpass = param[2]; //sprawdzenie czy haslo stare poprawne using (var db = new BlaBla_dbContext()) { var user = db.Users.Where(x => x.Login == login && x.Password == oldpass).FirstOrDefault(); if (user != null) { user.Password = newpass; db.SaveChanges(); return(true); } else { return(false); } } return(false); }
//usuwanie znajomego public static Boolean RemoveFriend(List <string> param) { string login1 = param[0]; //login1 string login2 = param[1]; //login2 using (var db = new BlaBla_dbContext()) { var id_user1 = db.Users.Where(x => x.Login == login1).Select(x => x.Id_User).FirstOrDefault(); var id_user2 = db.Users.Where(x => x.Login == login2).Select(x => x.Id_User).FirstOrDefault(); Friendship friendship; Friendship friendship2; int tmp = 0; friendship = db.Friendships.Where(x => x.Id_User1 == id_user1 && x.Id_User2 == id_user2).FirstOrDefault(); if (friendship != null) { db.Friendships.Remove(friendship); db.SaveChanges(); tmp++; } friendship2 = db.Friendships.Where(x => x.Id_User1 == id_user2 && x.Id_User2 == id_user1).FirstOrDefault(); if (friendship2 != null) { db.Friendships.Remove(friendship2); db.SaveChanges(); tmp++; } if (tmp > 0) { return(true); } } return(false); }