private static bool LogOut() { if (_user == null) { return(false); } using (var ctx = new CashSummaryDBDataContext()) { UserLog log = ctx.UserLogs.OrderByDescending(x => x.LoginTime).FirstOrDefault(x => x.UserId == _user.Id && x.MachineName == Environment.MachineName); if (log != null && log.Status == "LogIn") { log.MachineName = Environment.MachineName; log.LogoutTime = DateTime.Now; log.Status = "LogOut"; log.UserId = _user.Id; //log.User = user; //ctx.UserLogs.(log); ctx.SubmitChanges(); } //db.Dispose(); return(true); } }
private static bool LogIn() { using (var ctx = new CashSummaryDBDataContext()) { UserLog log = ctx.UserLogs .FirstOrDefault(x => x.UserId == _user.Id && x.MachineName == Environment.MachineName && x.LoginTime != null); if (log != null) { LogOut(); } DrawerSelector.Instance.User = _user; log = new UserLog() { MachineName = Environment.MachineName, LoginTime = DateTime.Now, Status = "LogIn", UserId = _user.Id, }; ctx.UserLogs.InsertOnSubmit(log); //ctx.UserLogs.Add(log); ctx.SubmitChanges(); } // db.Dispose(); return(true); }