/* Edit Locker *
* Input = locker *
* edit some info about the locker */
public bool EditLocker(LockerMetadata locker)
{
try
{
var _locker = _dbContext.lockerMetadatas.FirstOrDefault(x => x.Mac_address == locker.Mac_address);
//check locker is existed
if (_locker != null)
{
_dbContext.lockerMetadatas.FirstOrDefault(x => x.Mac_address == locker.Mac_address).IsActive = locker.IsActive;
_dbContext.lockerMetadatas.FirstOrDefault(x => x.Mac_address == locker.Mac_address).Location = locker.Location;
_dbContext.SaveChanges();
return(true);
}
//if locker is not existed
else
{
return(false);
}
}
catch (Exception)
{
//error
Console.WriteLine("Cannot Edit Locker");
return(false);
}
}
public IActionResult AddLocker([FromBody] LockerMetadata locker)
{
if (_lockerRepo.AddLocker(locker))
{
return(Ok(locker.Mac_address));
}
return(NotFound());
}
/* Add Locker *
* input = locker *
* Attributes => string Mac_address, string Location, bool IsActive *
* string Mac_address can not be dupilcated and null */
public bool AddLocker(LockerMetadata locker)
{
try
{
//if mac is replicated
if (_dbContext.lockerMetadatas.FirstOrDefault(x => x.Mac_address == locker.Mac_address) != null)
{
//if mac is replicated and locker is active.
if (_dbContext.lockerMetadatas.FirstOrDefault(x => x.Mac_address == locker.Mac_address && x.IsActive == true) != null)
{
return(false);
}
//if mac is replicated and locker is inactive.
else
{
//location is replicated.
if (_dbContext.lockerMetadatas.FirstOrDefault(x => x.Location.ToLower() == locker.Location.ToLower()) != null)
{
return(false);
}
else
{
_dbContext.lockerMetadatas.FirstOrDefault(x => x.Mac_address == locker.Mac_address).Location = locker.Location;
_dbContext.lockerMetadatas.FirstOrDefault(x => x.Mac_address == locker.Mac_address).IsActive = true;
_dbContext.SaveChanges();
return(true);
}
}
}
//if mac is not replicated
else
{
//location is replicated.
if (_dbContext.lockerMetadatas.FirstOrDefault(x => x.Location.ToLower() == locker.Location.ToLower()) != null)
{
return(false);
}
else
{
_dbContext.lockerMetadatas.Add(locker);
_dbContext.SaveChanges();
return(true);
}
}
}
catch (Exception)
{
//error
Console.WriteLine("Have %s it already", locker.Mac_address.ToString());
return(false);
}
}
public IActionResult EditLocker([FromBody] LockerMetadata locker)
{
TimeZoneInfo zone = TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time");
DateTime dateTime = TimeZoneInfo.ConvertTime(DateTime.Now, zone);
//if editing locker success
if (_lockerRepo.EditLocker(locker))
{
Log.Information("Edit Locker {mac} OK. {DateTime}.", locker.Mac_address, dateTime);
return(Ok(locker.Mac_address));
}
//if editing locker fail
Log.Information("Edit Locker {mac} Error. {DateTime}.", locker.Mac_address, dateTime);
return(NotFound(locker.Mac_address));
}
public bool AddLocker(LockerMetadata locker)
{
//_dbContext.Database.ExecuteSqlCommandAsync(@"CREATE VIEW View_vacancy AS
// SELECT Mac_address, No_vacancy from Vacancies");
try
{
if ((_dbContext.LockerMetadatas.FirstOrDefault(x => x.Mac_address == locker.Mac_address)) != null)
{
return(false);
}
_dbContext.LockerMetadatas.Add(locker);
_dbContext.SaveChanges();
return(true);
}
catch (Exception)
{
Console.WriteLine("Have %s it already", locker.ToString());
return(false);
}
}
