public int GetThumbnailIdByFileId(int fileId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
return(context.thumbnails.Where(thmb => thmb.fileId == fileId).FirstOrDefault().id);
}
}
public void MoveFileToPreviousDir(int fileID, string moovingSubroot)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
Files targetFile = context.Files.Where(tf => tf.id == fileID).FirstOrDefault();
List <string> targetFileRoutSubstrings = CloudManager.GetDBSubrootsFormDBRoot(targetFile.rout);
string oldDiskRoot = Path.Combine(@"D:\cloud", CloudManager.RootConvertion(targetFile.rout));
if (targetFile.type == "directory")
{
List <Files> innerFiles = context.Files.Where(innrf => innrf.rout == targetFile.rout + "-" + targetFile.name).ToList();
if (innerFiles.Count != 0)
{
foreach (Files innerFile in innerFiles)
{
MoveFileToPreviousDir(innerFile.id, moovingSubroot);
}
}
targetFileRoutSubstrings.Remove(moovingSubroot);
string nweRoot = CloudManager.GetDBRootFromSubroots(targetFileRoutSubstrings);
targetFile.rout = nweRoot;
}
else
{
targetFileRoutSubstrings.Remove(moovingSubroot);
string nweRoot = CloudManager.GetDBRootFromSubroots(targetFileRoutSubstrings);
targetFile.rout = nweRoot;
}
context.SaveChanges();
}
}
public bool RemoveAllExpiredSessions(double hours)
{
DateTime baselineDate = DateTime.UtcNow.AddHours(-hours);
try
{
using (var context = new IgorMarkivMessengerDBEntities())
{
bool result = true;
List <Sessions> expiredSessions = context.Sessions.Where(s => s.lastActivity < baselineDate).ToList();
if (expiredSessions.Count != 0)
{
foreach (Sessions s in expiredSessions)
{
context.Sessions.Remove(s);
}
context.SaveChanges();
}
return(result);
}
}
catch (Exception ex)
{
DBHelper.LogManager.LogError("DBHelper db RemoveAllExpiredSessions", ex.Message, "Temporary Empty");
return(false);
}
}
public List <msg_conv> GetconvListByUserName(string username, int userId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
List <Users> usersList = context.Users.Where(usr => usr.userName == username).ToList();
List <msg_conv> Emptyconv = new List <msg_conv>();
if (usersList.Count == 0)
{
return(Emptyconv);
}
else
{
int tergetUserId = usersList[0].id;
List <msg_conv> convList = context.msg_conv.Where(conv => (conv.user1 == tergetUserId && conv.user2 == userId) || (conv.user1 == userId && conv.user2 == tergetUserId)).ToList();
if (convList.Count == 0)
{
msg_conv conv = CreateConversation(userId, usersList[0].id);
convList.Add(conv);
return(convList);
}
else
{
return(convList);
}
}
}
}
public void SendMessege(int userId, int convId, string messege, bool isUser1)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
DBHelper.Model.MessageInfo messageInfo = new MessageInfo()
{
id = 1,
isUser1 = isUser1,
convId = convId,
time = DateTime.UtcNow,
changed = false
};
List <MessageInfo> listOfmessageInfos = new List <MessageInfo>();
listOfmessageInfos.Add(messageInfo);
message message = new message()
{
messageBody = messege,
messageSalt = "temporaryEmpty",
MessageInfo = listOfmessageInfos
};
messageInfo.message = message;
context.MessageInfo.Add(messageInfo);
context.message.Add(message);
context.SaveChanges();
}
}
public message GetMessageByMessageInfoId(int messageId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
message message = context.message.Where(ms => ms.id == messageId).FirstOrDefault();
return(message);
}
}
public msg_conv GetConversationByConversationId(int converationId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
msg_conv msg_Conv = context.msg_conv.Where(mc => mc.id == converationId).FirstOrDefault();
return(msg_Conv);
}
}
public List <Files> GetFileListByUserId(int userId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
List <Files> files = context.Files.Where(f => f.user == userId).ToList();
return(files);
}
}
public List <MessageInfo> GetAllMessageInfoByConversationId(int ConversationId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
List <MessageInfo> listOfmessageInfo = context.MessageInfo.Where(ms => ms.convId == ConversationId).ToList();
return(listOfmessageInfo);
}
}
public void DeleteThubmail(int thimbnailId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
thumbnails thumbnail = context.thumbnails.Where(thmb => thmb.id == thimbnailId).FirstOrDefault();
context.thumbnails.Remove(thumbnail);
context.SaveChanges();
}
}
public void InactivateInvitationCode(string invitationCode)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
InvitationCode invitation = context.InvitationCode.Where(inv => inv.code == invitationCode).FirstOrDefault();
invitation.used = true;
context.SaveChanges();
}
}
public void AddEncryptKeys(int fileId, byte[] key, byte[] iv)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
thumbnails thumbnail = context.thumbnails.Where(thmb => thmb.fileId == fileId).FirstOrDefault();
thumbnail.key = key;
thumbnail.iv = iv;
context.SaveChanges();
}
}
public void CreateDirectory(int userId, string name, string folderRout)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
Files Folder = new Files {
name = name, rout = folderRout, uploadDate = DateTime.UtcNow, user = userId, type = "directory"
};
context.Files.Add(Folder);
context.SaveChanges();
}
}
public static msg_conv CreateConversation(int user1, int user2)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
msg_conv conv = new msg_conv()
{
user1 = user1, user2 = user2
};
context.msg_conv.Add(conv);
context.SaveChanges();
return(conv);
}
}
public void DeleteThumbnailFromDBbyFileId(int fileId)
{
{
using (var context = new IgorMarkivMessengerDBEntities()) {
thumbnails tmbnl = context.thumbnails.Where(tmb => tmb.fileId == fileId).FirstOrDefault();
if (tmbnl != null)
{
context.thumbnails.Remove(tmbnl);
context.SaveChanges();
}
}
}
}
public int SaveThumbnail(int originalFileId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
thumbnails thumbnail = new thumbnails()
{
fileId = originalFileId
};
context.thumbnails.Add(thumbnail);
context.SaveChanges();
return(context.thumbnails.Where(thmb => thmb.fileId == originalFileId).FirstOrDefault().id);
}
}
//public bool VerifyUser(string username, string password)
//{
// using (var context = new IMWebDBEntities())
// {
// Users user = context.Users.Where(u => u.user == username && u.password == password).FirstOrDefault();
// if (user != null) { return true; }
// else { return false; }
// }
//}
public void LogVisit()
{
using (var Context = new IgorMarkivMessengerDBEntities())
{
siteVisits siteVisits = new siteVisits()
{
isSession = false,
VisiteTime = DateTime.Now
};
Context.siteVisits.Add(siteVisits);
Context.SaveChanges();
}
}
public List <string> GetSessionsList(int userId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
var sessionEntities = context.Sessions.Where(s => s.userId == userId);
var sessionKeys = new List <string>();
foreach (Sessions s in sessionEntities)
{
sessionKeys.Add(s.sessionKey);
}
return(sessionKeys);
}
}
public bool RemoveAllUsersSessions(int userId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
bool result = true;
var sessionList = context.Sessions.Where(s => s.userId == userId);
foreach (var session in sessionList)
{
context.Sessions.Remove(session);
}
context.SaveChanges();
return(result);
}
}
public bool AddInvalidLoginAttempt(int userId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
Users user = context.Users.Where(u => u.id == userId).FirstOrDefault();
if (user == null)
{
return(false);
}
user.invalidLogin++;
context.SaveChanges();
return(true);
}
}
public bool VerifyUser(string username, string password)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
Users user = context.Users.Where(u => u.user == username && u.password == password).FirstOrDefault();
if (user != null)
{
return(true);
}
else
{
return(false);
}
}
}
public bool CheckIfPasswordCorrect(int userId, string password)
{
using (var Context = new IgorMarkivMessengerDBEntities())
{
var user = Context.Users.Where(u => u.id == userId).FirstOrDefault();
if (user.password == SessionManagerDll.Util.EncodePassword(password, user.salt))
{
return(true);
}
else
{
return(false);
}
}
}
public DateTime GetUserLastActivity(int userId, string session)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
var sessionEntity = context.Sessions.Where(s => s.userId == userId && s.sessionKey == session).FirstOrDefault();
if (sessionEntity != null)
{
return(sessionEntity.lastActivity);
}
else
{
return(DateTime.MinValue);
}
}
}
public bool GetUsertableViewStatusById(int userId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
userSettings userSetting = context.userSettings.Where(us => us.userId == userId).FirstOrDefault();
if (userSetting != null)
{
return(userSetting.fileTableView.Value);
}
else
{
return(false);
}
}
}
public bool CreateSession(int userId, string sessionKey)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
var sessionEntity = new Sessions()
{
lastActivity = DateTime.UtcNow,
sessionKey = sessionKey,
userId = userId
};
context.Sessions.Add(sessionEntity);
context.SaveChanges();
}
return(true);
}
public bool TryGetUserById(int userId, out Users user)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
user = context.Users.FirstOrDefault(s => s.id == userId);
if (user != null)
{
return(true);
}
else
{
return(false);
}
}
}
public bool CheckConversationUser(int userId, int convId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
msg_conv conv = context.msg_conv.Where(cv => cv.id == convId).FirstOrDefault();
if (conv.user1 == userId)
{
return(true);
}
else
{
return(false);
}
}
}
public bool IsUserLoggedIn(int userId, out List <string> sessions)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
sessions = GetSessionsList(userId);
if (sessions.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public DateTime GetRemeinSessionTime(int userId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
Sessions userSesion = context.Sessions.Where(s => s.userId == userId).FirstOrDefault();
if (userSesion != null)
{
return(userSesion.lastActivity);
}
else
{
return(DateTime.Now);
}
}
}
public bool CheckIfFileIsDirectory(int fileId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
Files file = context.Files.Where(tf => tf.id == fileId).FirstOrDefault();
if (file.type == "directory")
{
return(true);
}
else
{
return(false);
}
}
}
