public Stream GetIntruderAlarmAreaGroups()
{
string responseBody;
using (var context = new ServerContext())
{
responseBody = JsonConvert.SerializeObject(context.IntruderAlarmAreaGroups, Formatting.Indented);
}
return SerializeHelper.GetResponceFromString(responseBody);
}
public void DeleteIntruderAlarmAreaGroup(string id)
{
Guid guidId;
if (Guid.TryParse(id, out guidId))
using (var context = new ServerContext())
{
var intruderAlarmAreaGroup = context.IntruderAlarmAreaGroups.Find(guidId);
context.Entry(intruderAlarmAreaGroup).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void DeleteAccessRule(string objectId, string subjectId, string actionId)
{
Guid guidObjectId;
int intSubjectId, intActionId;
if ((Guid.TryParse(objectId, out guidObjectId)) && (int.TryParse(subjectId, out intSubjectId)) &&
(int.TryParse(actionId, out intActionId)))
using (var context = new ServerContext())
{
var cardReaderGroup = context.AclItems.Find(guidObjectId, intSubjectId, intActionId);
context.Entry(cardReaderGroup).State = EntityState.Deleted;
context.SaveChanges();
}
else
throw new BadRequestException("Check key parameters: AclObjectID, AclSubjectID, ActionID");
}
public Stream GetAccessRule(string objectId, string subjectId, string actionId)
{
string responseBody;
Guid guidObjectId;
int intSubjectId, intActionId;
if ((Guid.TryParse(objectId, out guidObjectId)) && (int.TryParse(subjectId, out intSubjectId)) &&
(int.TryParse(actionId, out intActionId)))
using (var context = new ServerContext())
{
responseBody = JsonConvert.SerializeObject(context.AclItems.Find(guidObjectId, intSubjectId, intActionId),
Formatting.Indented);
}
else
throw new BadRequestException("Check key parameters: AclObjectID, AclSubjectID, ActionID");
return SerializeHelper.GetResponceFromString(responseBody);
}
private static Stream AddOrChangeAccessRule(Stream stream, bool add)
{
var changedAccessRule = SerializeHelper.GetObjectFromStream<AclItem>(stream);
int res;
if ((changedAccessRule.AclObjectID == new Guid()) || (changedAccessRule.AclSubjectID == 0) ||
(changedAccessRule.ActionID == 0))
{
throw new BadRequestException("Check key parameters: AclObjectID, AclSubjectID, ActionID");
}
using (var context = new ServerContext())
{
AclItem originalAccessRule;
if (add)
{
originalAccessRule = context.AclItems.Attach(new AclItem());
context.Entry(originalAccessRule).State = EntityState.Added;
}
else
{
originalAccessRule = context.AclItems.Find(changedAccessRule.AclObjectID, changedAccessRule.AclSubjectID, changedAccessRule.ActionID);
if(originalAccessRule == null)
throw new BadRequestException("Can't find item with those parameters");
context.Entry(originalAccessRule).State = EntityState.Modified;
}
context.Entry(originalAccessRule).CurrentValues.SetValues(changedAccessRule);
res = context.SaveChanges();
}
var responseBody = JsonConvert.SerializeObject(res, Formatting.Indented);
return SerializeHelper.GetResponceFromString(responseBody);
}
private static Stream AddOrChangeIntruderAlarmAreaGroup(Stream stream)
{
var chagedIntruderAlarmAreaGroup = SerializeHelper.GetObjectFromStream<IntruderAlarmAreaGroup>(stream);
int res;
using (var context = new ServerContext())
{
IntruderAlarmAreaGroup originalIntruderAlarmAreaGroup;
if (chagedIntruderAlarmAreaGroup.Id == new Guid())
{
originalIntruderAlarmAreaGroup = context.IntruderAlarmAreaGroups.Attach(new IntruderAlarmAreaGroup());
context.Entry(originalIntruderAlarmAreaGroup).State = EntityState.Added;
}
else
{
originalIntruderAlarmAreaGroup = context.IntruderAlarmAreaGroups.Find(chagedIntruderAlarmAreaGroup.Id);
context.Entry(originalIntruderAlarmAreaGroup).State = EntityState.Modified;
}
context.Entry(originalIntruderAlarmAreaGroup).CurrentValues.SetValues(chagedIntruderAlarmAreaGroup);
res = context.SaveChanges();
}
var responseBody = JsonConvert.SerializeObject(res, Formatting.Indented);
return SerializeHelper.GetResponceFromString(responseBody);
}
private static Stream AddOrChangeGuest(Stream stream)
{
var changedGuest = SerializeHelper.GetObjectFromStream<Guest>(stream);
int res;
using (var context = new ServerContext())
{
Guest originalGuest;
if (changedGuest.Id == 0)
{
originalGuest = context.Guests.Attach(new Guest());
context.Entry(originalGuest).State = EntityState.Added;
}
else
{
originalGuest = context.Guests.Find(changedGuest.Id);
context.Entry(originalGuest).State = EntityState.Modified;
}
context.Entry(originalGuest).CurrentValues.SetValues(changedGuest);
res = context.SaveChanges();
}
var responseBody = JsonConvert.SerializeObject(res, Formatting.Indented);
return SerializeHelper.GetResponceFromString(responseBody);
}
public void DeleteCardReader(string id)
{
Guid guidId;
if (Guid.TryParse(id, out guidId))
using (var context = new ServerContext())
{
var cardReader = context.CardReaders.Find(guidId);
context.Entry(cardReader).State = EntityState.Deleted;
context.SaveChanges();
}
}
private static Stream AddOrChangeCardReader(Stream stream)
{
var changedCardReader = SerializeHelper.GetObjectFromStream<CardReader>(stream);
int res;
using (var context = new ServerContext())
{
CardReader originalCardReader;
if (changedCardReader.Id == new Guid())
{
originalCardReader = context.CardReaders.Attach(new CardReader());
context.Entry(originalCardReader).State = EntityState.Added;
}
else
{
originalCardReader = context.CardReaders.Find(changedCardReader.Id);
context.Entry(originalCardReader).State = EntityState.Modified;
}
context.Entry(originalCardReader).CurrentValues.SetValues(changedCardReader);
res = context.SaveChanges();
}
var responseBody = JsonConvert.SerializeObject(res, Formatting.Indented);
return SerializeHelper.GetResponceFromString(responseBody);
}
public List<Employee> GetEmployeesDbSet()
{
List<Employee> res;
using (var context = new ServerContext())
{
res = context.Employees.AsEnumerable().ToList();
}
return res;
}
public Stream GetEmployees()
{
string responseBody;
using (var context = new ServerContext())
{
responseBody = JsonConvert.SerializeObject(context.Employees, Formatting.Indented);
}
return SerializeHelper.GetResponceFromString(responseBody);
}
public void DeleteGuest(string id)
{
int intId;
if (int.TryParse(id, out intId))
using (var context = new ServerContext())
{
var guest = context.Guests.Find(intId);
context.Entry(guest).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void DeleteEmployee(string id)
{
int intId;
if(int.TryParse(id, out intId))
using (var context = new ServerContext())
{
var employee = context.Employees.Find(intId);
context.Entry(employee).State = EntityState.Deleted;
context.SaveChanges();
}
}
