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