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