//Gets all keys not assigned to any schedule
public KeyPerson[] GetNotScheduleKey()
{
var zero = keyDataRepository.Tests();
var one = scheduleKeyDataRepository.Tests();
List <KeyPerson> list = new List <KeyPerson>();
foreach (KeyData i in zero)
{
int count = 0;
foreach (ScheduleKey j in one)
{
if (j.KeyID == i.KeyID)
{
count++;
}
}
if (count == 0)
{
var three = personKeyDataRepository.GetPerson(i.KeyID);
if (three == null)
{
KeyPerson user = new KeyPerson();
user.KeyID = i.KeyID;
user.Name = "Not Assigned";
list.Add(user);
}
else
{
list.Add(three);
}
}
}
KeyPerson[] output = list.ToArray();
return(output);
}
public IHttpActionResult PostKeyPerson(KeyPerson keyPerson)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.KeyPersons.Add(keyPerson);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (KeyPersonExists(keyPerson.KeyPerson1))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = keyPerson.KeyPerson1 }, keyPerson));
}
public IHttpActionResult PutKeyPerson(string id, KeyPerson keyPerson)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != keyPerson.KeyPerson1)
{
return(BadRequest());
}
db.Entry(keyPerson).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KeyPersonExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetKeyPerson(string id)
{
KeyPerson keyPerson = db.KeyPersons.Find(id);
if (keyPerson == null)
{
return(NotFound());
}
return(Ok(keyPerson));
}
public IHttpActionResult DeleteKeyPerson(string id)
{
KeyPerson keyPerson = db.KeyPersons.Find(id);
if (keyPerson == null)
{
return(NotFound());
}
db.KeyPersons.Remove(keyPerson);
db.SaveChanges();
return(Ok(keyPerson));
}
private static Person GetPerson(KeyPerson keyPerson, CompanyData companyData)
{
var existingPerson = companyData.Members.FirstOrDefault(p => p.Name == keyPerson.Name);
if (existingPerson != null)
{
return(existingPerson);
}
var person = new Person
{
Name = keyPerson.Name,
Title = keyPerson.Title
};
companyData.Members.Add(person);
return(person);
}
//Gets all keys for a person (id = personID)
public KeyPerson[] GetLockKey(int id)
{
var one = lockKeyDataRepository.Find(id);
List <KeyPerson> list = new List <KeyPerson>();
foreach (LockKey i in one)
{
var three = personKeyDataRepository.GetPerson(i.KeyID);
if (three == null)
{
KeyPerson user = new KeyPerson();
user.KeyID = i.KeyID;
user.Name = "Not Assigned";
list.Add(user);
}
else
{
list.Add(three);
}
}
KeyPerson[] output = list.ToArray();
return(output);
}
//Gets all keys
public KeyPerson[] GetKey()
{
var one = keyDataRepository.Tests();
List <KeyPerson> list = new List <KeyPerson>();
foreach (KeyData i in one)
{
var three = personKeyDataRepository.GetPersons(i.KeyID);
if (three == null)
{
KeyPerson user = new KeyPerson();
user.KeyID = i.KeyID;
user.Content = i.Content;
user.Name = "Not Assigned";
list.Add(user);
}
else
{
list.Add(three);
}
}
KeyPerson[] output = list.ToArray();
return(output);
}
