public static async Task <List <History_User> > Users(bool last100 = false, string userId = null)
{
try
{
if (last100 && userId == null)
{
return(await db.History_User.OrderByDescending(x => x.user_datetime).Take(100).ToListAsync());
}
else if (!last100 && userId != null)
{
return(await db.History_User.Where(x => x.user_id == userId).ToListAsync());
}
else
{
return(await db.History_User.ToListAsync());
}
}
catch (Exception ex)
{
await Set.API(new History_API()
{
api_action = "Problem occured when getting data from history tables : " + ex.Message,
api_type = "Exception -> thrown at Get.Users",
api_datetime = DateTime.Now
});
return(new List <History_User>());
}
}
public static async Task <List <History_API> > API(bool last100 = true)
{
try
{
if (last100)
{
return(await db.History_API.OrderByDescending(x => x.api_datetime).Take(100).ToListAsync());
}
else
{
return(await db.History_API.ToListAsync());
}
}
catch (Exception ex)
{
await Set.API(new History_API()
{
api_action = "Problem occured when getting data from history tables : " + ex.Message,
api_type = "Exception -> thrown at Get.API",
api_datetime = DateTime.Now
});
return(new List <History_API>());
}
}
public static async Task <bool> Create(Type table, object data)
{
switch (table)
{
case Type.API: {
await Set.API((History_API)data);
return(true);
};
case Type.User: {
await Set.User((History_User)data);
return(true);
};
}
return(false);
}
/// <summary>
/// Return list of database entries for specific table of history
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="table">Specify which table to read from</param>
/// <param name="par">Specify additional parramaters ex: datetime > 10.10.2016</param>
/// <returns></returns>
public static async Task <List <T> > Return <T>(Type table, string[] par = null)
{
try
{
if (par == null)
{
switch (table)
{
case Type.API: {
var a = db.History_API.ToList();
return(a as List <T>);
};
case Type.User: {
var u = db.History_User.ToList();
return(u as List <T>);
};
}
return(new List <T>());
}
else
{
return(new List <T>());
}
}
catch (Exception ex)
{
await Set.API(new History_API()
{
api_action = "Problem occured when getting data from history tables : " + ex.Message,
api_type = "Exception -> thrown at History.Return",
api_datetime = DateTime.Now
});
return(new List <T>());
}
}
