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); }
private void GetStores() { using (var ctx = new CashSummaryDBDataContext()) { Stores = new ObservableCollection <Store>(ctx.Stores); } }
public void GetDrawers(string storeId) { using (var ctx = new CashSummaryDBDataContext()) { Drawers = new ObservableCollection <Drawer>(ctx.Drawers.Where(x => x.StoreId == storeId)); Cashiers = new ObservableCollection <Cashier>(ctx.Cashiers.Where(x => x.WorkGroupId == storeId)); Supervisors = new ObservableCollection <Supervisor>(ctx.Supervisors.Where(x => x.WorkGroupId == storeId)); } }
public void ShowUserOptions() { LoginRow.Height = new GridLength(0); UserOptionsRow.Height = new GridLength(RowHeight); _status = Status.UserOptions; using (var ctx = new CashSummaryDBDataContext()) { Users = User.UserPermissions.Any(x => x.Permission.Name == "Admin") ? ctx.Users.ToList() : ctx.Users.Where(x => x.Id == User.Id).ToList(); } }
public static bool Authenticate(string user, string pass) { using (var ctx = new CashSummaryDBDataContext()) { _user = ctx.Users.FirstOrDefault(x => x.LoginName == user); if (_user != null && _user.Password == pass) { _user.UserPermissions.Load(); return(LogIn()); } else { return(false); } } }