public Player GetWaiver(string position, int skip)
{
if (Waivers != null && Waivers.Count > skip)
{
List <Player> players = Waivers.Where(p => p.Position == position).ToList <Player>();
return(players.Skip(skip).Take(1).FirstOrDefault <Player>());
}
return(null);
}
/// <summary>
/// Overriding the delete to make sure that all of the attached items are deleted as well from the member.
/// </summary>
/// <param name="db">Database being used.</param>
public override void Delete(DatabaseContext db)
{
DisciplineEnrolledMembers.ToList().ForEach(a => a.IsArchived = true);
Payments.ToList().ForEach(a => a.IsArchived = true);
Waivers.ToList().ForEach(a => a.IsArchived = true);
Contacts.ToList().ForEach(a => a.IsArchived = true);
AttendanceSheets.ToList().ForEach(a => a.IsArchived = true);
//User?.Delete(db);
base.Delete(db);
}
public static bool SaveWaiverNews(DateTime dateStamp, string line, string system)
{
DateTime dbDateTime = new DateTime();
var table = "";
const int index = 1;
if (system == "xbox")
{
table = "XboxWaiver";
}
else if (system == "psn")
{
table = "PsnWaiver";
}
using (var waiverDb = new LiteDatabase("News.db"))
{
var waiver = waiverDb.GetCollection <Waivers>(table);
var result = waiver.Find(x => x.Id == 1);
foreach (var dateTime in result)
{
dbDateTime = dateTime.dateTime;
}
}
using (var database = new LiteDatabase("News.db"))
{
var waiverCollection = database.GetCollection <Waivers>(table);
waiverCollection.EnsureIndex(x => x.dateTime);
int Id = 1;
var waiverFeed = new Waivers
{
Id = Id,
dateTime = dateStamp,
line = line
};
try
{
var dateFound = waiverCollection.FindById(index);
var value = DateTime.Compare(dbDateTime, dateStamp);
if (dateFound == null)
{
waiverCollection.Insert(waiverFeed);
return(true);
}
else if (dateFound != null)
{
if (value < 0)
{
waiverCollection.Update(waiverFeed);
return(true);
}
else if (value == 0)
{
return(false);
}
else
{
return(false);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
return(false);
}
