//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);
}
