public async Task <bool> SaveDevice(DeviceViewModel model) { using (LockerDBContext db = new LockerDBContext()) { Device device = db.Device.Where(x => x.DeviceId == model.DeviceId).FirstOrDefault(); if (device == null) { device = new Device() { DeviceName = model.DeviceName, DeviceId = model.DeviceId, Status = model.Status, LockerId = model.LockerId }; db.Device.Add(device); } else { device.DeviceName = model.DeviceName; device.DeviceId = model.DeviceId; device.Status = model.Status; device.LockerId = model.LockerId; } return(await db.SaveChangesAsync() >= 1); } }
public async Task <bool> SaveUser(UserViewModel model) { using (LockerDBContext db = new LockerDBContext()) { Users User = db.Users.Where(x => x.UserId == model.UserId).FirstOrDefault(); if (User == null) { User = new Users() { FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, Phone = model.Phone, LoginUserId = model.LoginUserId, Pin = model.Pin, Status = model.Status }; db.Users.Add(User); } else { User.FirstName = model.FirstName; User.LastName = model.LastName; User.Email = model.Email; User.Phone = model.Phone; User.LoginUserId = model.LoginUserId; User.Pin = model.Pin; User.Status = model.Status; } return(await db.SaveChangesAsync() >= 1); } }
public async Task <bool> SaveContact(Contact model) { using (LockerDBContext db = new LockerDBContext()) { Contacts contact = db.Contacts.Where(x => x.ContactId == model.ContactId).FirstOrDefault(); if (contact == null) { contact = new Contacts() { FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, Phone = model.Phone }; db.Contacts.Add(contact); } else { contact.FirstName = model.FirstName; contact.LastName = model.LastName; contact.Email = model.Email; contact.Phone = model.Phone; } return(await db.SaveChangesAsync() >= 1); } }
public float HasDevice(int UserId) { using (LockerDBContext db = new LockerDBContext()) { float deviceCount = db.Users.Where(x => (x.LoginUserId == UserId && x.LockerId != null)).Count(); return(deviceCount); } }
public async Task <bool> DeleteUserByID(int id) { using (LockerDBContext db = new LockerDBContext()) { Users User = db.Users.Where(x => x.UserId == id).FirstOrDefault(); if (User != null) { db.Users.Remove(User); } return(await db.SaveChangesAsync() >= 1); } }
public async Task <bool> DeleteDeviceByID(int id) { using (LockerDBContext db = new LockerDBContext()) { Device device = db.Device.Where(x => x.Id == id).FirstOrDefault(); if (device != null) { db.Device.Remove(device); } return(await db.SaveChangesAsync() >= 1); } }
public async Task <bool> DeleteContactByID(int id) { using (LockerDBContext db = new LockerDBContext()) { Contacts contact = db.Contacts.Where(x => x.ContactId == id).FirstOrDefault(); if (contact != null) { db.Contacts.Remove(contact); } return(await db.SaveChangesAsync() >= 1); } }
public CheckinDeviceViewModel Checkout(int UserId) { using (LockerDBContext db = new LockerDBContext()) { return((from a in db.Users where (a.LoginUserId == UserId) select new CheckinDeviceViewModel { LockerNumber = a.LockerId, Status = 1 }).FirstOrDefault()); } }
public async Task <List <LockerViewModel> > GetAllLocker() { using (LockerDBContext db = new LockerDBContext()) { return(await(from a in db.Locker select new LockerViewModel { CabinetId = a.CabinetId, Id = a.Id, DeviceId = a.DeviceId, HasDevice = a.HasDevice, LockerId = a.LockerId, Name = a.Name }).ToListAsync()); } }
public CheckinDeviceViewModel Checkin(int UserId) { using (LockerDBContext db = new LockerDBContext()) { var lockerNumber = (from a in db.Locker where (a.HasDevice == false) select new CheckinDeviceViewModel { LockerNumber = a.LockerId, Status = 1 }).FirstOrDefault(); var User = db.Users.Where(x => x.LoginUserId == UserId).FirstOrDefault(); User.LockerId = lockerNumber.LockerNumber; db.SaveChanges(); return(lockerNumber); } }
public UserViewModel AuthenticateUser(int UserId, int Pin) { using (LockerDBContext db = new LockerDBContext()) { return((from a in db.Users where (a.LoginUserId == UserId && a.Pin == Pin) select new UserViewModel { UserId = a.UserId, FirstName = a.FirstName, LastName = a.LastName, Email = a.Email, Phone = a.Phone, LoginUserId = a.LoginUserId, Pin = a.Pin, Status = a.Status }).FirstOrDefault()); } }
public async Task <List <UserViewModel> > GetAllUser() { using (LockerDBContext db = new LockerDBContext()) { return(await(from a in db.Users select new UserViewModel { UserId = a.UserId, FirstName = a.FirstName, LastName = a.LastName, Email = a.Email, Phone = a.Phone, LoginUserId = a.LoginUserId, Pin = a.Pin, Status = a.Status }).ToListAsync()); } }
public async Task <List <DeviceViewModel> > GetAllDevice() { try { using (LockerDBContext db = new LockerDBContext()) { return(await(from a in db.Device select new DeviceViewModel { DeviceId = a.DeviceId, DeviceName = a.DeviceName, Status = a.Status, LockerId = a.LockerId }).ToListAsync()); } } catch (Exception ex) { List <DeviceViewModel> asd = new List <DeviceViewModel>(); return(asd); } }
public async Task <List <Contact> > GetAllContact() { try { using (LockerDBContext db = new LockerDBContext()) { return(await(from a in db.Contacts select new Contact { ContactId = a.ContactId, FirstName = a.FirstName, LastName = a.LastName, Email = a.Email, Phone = a.Phone }).ToListAsync()); } } catch (Exception ex) { List <Contact> asd = new List <Contact>(); return(asd); } }