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