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