public static string History(long userID)
{
string history = string.Empty;
using (var ctx = new SecConvDBEntities())
{
var histories = ctx.Histories.Where(x => x.UserSenderID == userID || x.UserReceiverID == userID).OrderBy(x => x.Start).ToList();
if (histories.Count != 0)
{
foreach (var item in histories)
{
if (item.UserSenderID == userID)//userID is sender
{
var friendLoginR = ctx.Users.Where(x => x.UserID == item.UserReceiverID).Select(x => x.Login).FirstOrDefault();
if (friendLoginR != null)
{
history += friendLoginR + " " + item.Start.ToString() + " " + item.Duration.ToString() + " ";
}
}
else //userID is receiver
{
var friendLoginS = ctx.Users.Where(x => x.UserID == item.UserSenderID).Select(x => x.Login).FirstOrDefault();
if (friendLoginS != null)
{
history += friendLoginS + " " + item.Start.ToString() + " " + item.Duration.ToString() + " ";
}
}
}
}
history = Convert.ToBase64String(Program.security.EncryptMessage(Program.onlineUsers[userID].sessionKey, history));
history = ((char)13).ToString() + ' ' + history;
return(history + " <EOF>");
}
}
//Incoming messages
public static string Register(List <string> param)
{
//Communication with DB
using (var ctx = new SecConvDBEntities())
{
var newUser = new Users();
string login = param[0]; //login
int loginUnique = ctx.Users.Where(x => x.Login == login).Count(); //check if login is unique
if (loginUnique == 0)
{
newUser.Login = login;
newUser.Password = Utilities.hashBytePassHex(param[1] + login); //256 bit hash password
newUser.LastLogoutDate = DateTime.Now;
newUser.RegistrationDate = DateTime.Now;
ctx.Users.Add(newUser);
try
{
ctx.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return(Fail());;
}
}
else
{
return(Fail());
}
}
//OK
return(OK());
}
public static string PassChng(List <string> param)
{
string login = param[0];
string password1 = Utilities.hashBytePassHex(param[1] + login);
using (var ctx = new SecConvDBEntities())
{
var userToChngPasswd = ctx.Users.Where(x => x.Login == login && x.Password == password1).FirstOrDefault();
if (userToChngPasswd != null)
{
userToChngPasswd.Password = Utilities.hashBytePassHex(param[2] + login);
try
{
ctx.Entry(userToChngPasswd).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return(Fail());
}
}
else
{
return(Fail());
}
}
return(OK());
}
public static string AddFriend(List <string> param)
{
string login1 = param[0]; //user logged in
string login2 = param[1]; //friend of logged in user
using (var ctx = new SecConvDBEntities())
{
var acquaintance = new Friends();
//find users IDs
var userID1 = ctx.Users.Where(x => x.Login == login1).Select(x => x.UserID).FirstOrDefault();
if (userID1 != 0)
{
var user2 = ctx.Users.Where(x => x.Login == login2).Select(x => new { x.UserID, x.Login }).FirstOrDefault();
if (user2 != null)
{
var acq = ctx.Friends.Where(x => x.UserID1 == userID1 && x.UserID2 == user2.UserID).FirstOrDefault();
if (acq == null)
{
acquaintance.UserID1 = userID1;
acquaintance.UserID2 = user2.UserID;
try
{
ctx.Friends.Add(acquaintance);
ctx.SaveChanges();
string acqLogin = user2.Login;
if (Program.onlineUsers.ContainsKey(user2.UserID))
{
Program.onlineUsers[userID1].friendWithChangedState.Add(acqLogin, Program.onlineUsers[user2.UserID].addressIP);
}
else
{
Program.onlineUsers[userID1].friendWithChangedState.Add(acqLogin, "0");
}
}
catch (DbUpdateConcurrencyException)
{
return(Fail());
}
}
else
{
return(Fail());
}
}
else
{
return(Fail());
}
}
else
{
return(Fail());
}
}
return(OK());
}
public static string AccDel(List <string> param)
{
string login = param[0];
string password = Utilities.hashBytePassHex(param[1] + login);
using (var ctx = new SecConvDBEntities())
{
var userToDelete = ctx.Users.Where(x => x.Login == login && x.Password == password).FirstOrDefault();
if (userToDelete != null)
{
try
{
//1. set, in history, id to null, it can be first or second
var userHistory = ctx.Histories.Where(x => x.UserReceiverID == userToDelete.UserID);//first
foreach (var item in userHistory)
{
item.UserReceiverID = null;
ctx.Entry(item).State = System.Data.Entity.EntityState.Modified;
}
userHistory = ctx.Histories.Where(x => x.UserSenderID == userToDelete.UserID);//second
foreach (var item in userHistory)
{
item.UserSenderID = null;
ctx.Entry(item).State = System.Data.Entity.EntityState.Modified;
}
//2. delete acquaintances in both directions
var userAcquaintances = ctx.Friends.Where(x => x.UserID1 == userToDelete.UserID);//first
foreach (var item in userAcquaintances)
{
ctx.Entry(item).State = System.Data.Entity.EntityState.Deleted;
}
userAcquaintances = ctx.Friends.Where(x => x.UserID2 == userToDelete.UserID);
foreach (var item in userAcquaintances)
{
ctx.Entry(item).State = System.Data.Entity.EntityState.Deleted;
}
//3. delete user
ctx.Entry(userToDelete).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return(Fail());
}
}
else
{
return(Fail());
}
}
return(OK());
}
public static string CallState(List <string> param)
{
//kto
//do kogo
//data rozpoczecia
//czas trwania //00:00:00 -> null
string login1 = param[0];
string login2 = param[1];
using (var ctx = new SecConvDBEntities())
{
var SenderID = ctx.Users.Where(x => x.Login == login1).Select(x => x.UserID).FirstOrDefault();
if (SenderID != 0)
{
var ReceiverID = ctx.Users.Where(x => x.Login == login2).Select(x => x.UserID).FirstOrDefault();
if (ReceiverID != 0)
{
var history = new Histories();
history.UserSenderID = SenderID;
history.UserReceiverID = ReceiverID;
//yyyy-MM-dd-HH:mm:ss
history.Start = DateTime.ParseExact(param[2], "yyyy-MM-dd-HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
//HH:mm:ss
//TimeSpan duration = TimeSpan.Parse(param[3]);
history.Duration = new DateTime().Add(TimeSpan.Parse(param[3]));
try
{
ctx.Histories.Add(history);
ctx.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return(Fail());
}
}
else
{
return(Fail());
}
}
else
{
return(Fail());
}
}
return(OK());
}
public static string LogIP(long userID)
{
using (var ctx = new SecConvDBEntities())
{
var user = ctx.Users.Where(x => x.UserID == userID).FirstOrDefault();
if (user != null)
{
string message = string.Empty;
//0111 login_1 status_1 IP_1 login_2 status_2 IP_2...login_n status_n IP_n)
var friends = ctx.Friends.Where(x => x.UserID1 == userID);//all friends
foreach (var item in friends)
{
var friendLogin = ctx.Users.Where(x => x.UserID == item.UserID2).Select(x => x.Login).FirstOrDefault();
if (friendLogin != null)
{
message += friendLogin + " ";
if (Program.onlineUsers.ContainsKey(item.UserID2))
{
message += "1 ";
message += Program.onlineUsers[item.UserID2].addressIP + " ";
}
else
{
message += "0 ";
message += "0 ";
}
}
else
{
return(Fail());
}
}
message = Convert.ToBase64String(Program.security.EncryptMessage(Program.onlineUsers[userID].sessionKey, message));
message = ((char)7).ToString() + ' ' + message;
message += " <EOF>";
return(message);
}
else
{
return(Fail());
}
}
}
public static string LogIn(List <string> param, byte[] sessionKey, Socket client)
{
string login = param[0];
string password = Utilities.hashBytePassHex(param[1] + login);
//users -> online
using (var ctx = new SecConvDBEntities())
{
var user = ctx.Users.Where(x => x.Login == login && x.Password == password).FirstOrDefault();
if (user != null)
{
if (Program.onlineUsers.ContainsKey(user.UserID))
{
return(Fail());
}
ConnectedClient connectedClient = new ConnectedClient();
connectedClient.login = login;
connectedClient.iAM = DateTime.Now;
connectedClient.addressIP = ((IPEndPoint)client.RemoteEndPoint).Address.ToString();
connectedClient.sessionKey = sessionKey;
connectedClient.friendWithChangedState = new Dictionary <string, string>();
//add to dictionary
Program.onlineUsers[user.UserID] = connectedClient;
//find people who have friend that is logged in
var friends = ctx.Friends.Where(x => x.UserID2 == user.UserID).Select(x => x.UserID1);
//wyszukaj znajomych w slowniku online i dodaj/zmień w słowniku adres IP
foreach (var item in friends)
{
if (Program.onlineUsers.ContainsKey(item))
{
Program.onlineUsers[item].friendWithChangedState[login] = connectedClient.addressIP;
}
}
return(OK());
}
else
{
return(Fail());
}
}
}
public static string Iam(List <string> param)
{
string login = string.Empty;
login = param[0];
//check if user exists
using (var ctx = new SecConvDBEntities())
{
var user = ctx.Users.Where(x => x.Login == login).FirstOrDefault();
if (user != null)
{
if (Program.onlineUsers.ContainsKey(user.UserID))
{
Program.onlineUsers[user.UserID].iAM = DateTime.Now;
return(StateChng(user.UserID));
}
}
}
return(" <EOF>");
}
public static string LogOut(List <string> param)
{
string login = param[0];
using (var ctx = new SecConvDBEntities())
{
var userToLogOut = ctx.Users.Where(x => x.Login == login).FirstOrDefault();
if (userToLogOut != null)
{
userToLogOut.LastLogoutDate = DateTime.Now;
try
{
Program.onlineUsers.Remove(userToLogOut.UserID); //delete from dictionary
ctx.Entry(userToLogOut).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
//find people who have friend that is logged in
var friends = ctx.Friends.Where(x => x.UserID2 == userToLogOut.UserID).Select(x => x.UserID1);
//wyszukaj znajomych w slowniku online i dodaj/zmień w słowniku adres IP
foreach (var item in friends)
{
if (Program.onlineUsers.ContainsKey(item))
{
Program.onlineUsers[item].friendWithChangedState[login] = "0";
}
}
}
catch (DbUpdateConcurrencyException)
{
return(Fail());
}
}
else
{
return(Fail());
}
}
return(OK());
}
public static string DelFriend(List <string> param)
{
string login1 = param[0]; //logged in user
string login2 = param[1];
using (var ctx = new SecConvDBEntities())
{
var userLoggedInID1 = ctx.Users.Where(x => x.Login == login1).Select(x => x.UserID).FirstOrDefault();
if (userLoggedInID1 != 0)
{
var user1Friend = ctx.Users.Where(x => x.Login == login2).Select(x => new { x.UserID, x.Login }).FirstOrDefault();
if (user1Friend.UserID != 0)
{
var friend = ctx.Friends.Where(x => x.UserID1 == userLoggedInID1 && x.UserID2 == user1Friend.UserID).FirstOrDefault();
ctx.Entry(friend).State = System.Data.Entity.EntityState.Deleted;
try
{
ctx.SaveChanges();
Program.onlineUsers[userLoggedInID1].friendWithChangedState.Remove(user1Friend.Login);
}
catch (DbUpdateConcurrencyException)
{
return(Fail());
}
}
else
{
return(Fail());
}
}
else
{
return(Fail());
}
}
return(OK());
}
