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