public LogModel GetLogByID(int id)
{
using (var suspect = new SuspictionModel())
{
return(suspect.Logs.First(x => x.logId == id));
}
}
public IEnumerable <LogModel> GetAllLogs()
{
using (var suspect = new SuspictionModel())
{
return(suspect.Logs.ToList());
}
}
/// <summary>
/// Seeds data into the DB
/// </summary>
protected override void Seed(SuspictionModel context)
{
//Console.WriteLine(" ### Seeding ###");
// letting the base method do anything it needs to get done
//base.Seed(context);
// Save the changes you made, when adding the data above
//context.SaveChanges();
}
public bool DeleteLog(int id)
{
using (var suspect = new SuspictionModel())
{
suspect.Logs.Remove(suspect.Logs.First(x => x.logId == id));
suspect.SaveChanges();
var res = triggerPusher();
}
return(false);
}
public String[] getChartInfo()
{
String[] data = new String[3];
using (var suspect = new SuspictionModel())
{
data[0] = suspect.Logs.Where(x => x.type == "Insider").ToList().Count().ToString();
data[1] = suspect.Logs.Where(x => x.type == "Outsider").ToList().Count().ToString();
data[2] = suspect.Logs.Where(x => x.type == "Not Sure").ToList().Count().ToString();
}
return(data);
}
public bool AddLog(LogModel logToSave)
{
LogModel log = logToSave;
using (var suspect = new SuspictionModel())
{
suspect.Logs.Add(log);
suspect.SaveChanges();
var res = triggerPusher();
}
return(false);
}
public bool UpdateLog(LogModel log)
{
LogModel logToSave = log;
using (var suspect = new SuspictionModel())
{
LogModel logToUpdate = suspect.Logs.First(x => x.logId == logToSave.logId);
logToUpdate.header = logToSave.header;
logToUpdate.phone = logToSave.phone;
logToUpdate.useremail = logToSave.useremail;
logToUpdate.username = logToSave.username;
logToUpdate.type = logToSave.type;
suspect.SaveChanges();
var res = triggerPusher();
}
return(false);
}
