partial void DeleteEvent(Event instance);
partial void UpdateEvent(Event instance);
partial void InsertEvent(Event instance);
public int GetLastPastEvent()
{
EventGame result = new EventGame();
using (MasterDBDataContext db = new MasterDBDataContext())
{
DateTime date = DateTime.Now;
var eventGames = db.Event.Where(ev => ev.EndDate < date).OrderByDescending(ev => ev.EndDate);
if (eventGames != null)
{
Event[] arrayEventGames = new Event[eventGames.ToArray().Count()];
arrayEventGames = eventGames.ToArray();
return arrayEventGames[0].idEvent;
}
}
return -1;
}
public int[] GetAllPastEvent()
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
DateTime date = DateTime.Now;
var eventGames = db.Event.Where(ev => ev.EndDate < date).OrderByDescending(ev => ev.EndDate);
if (eventGames != null)
{
int numberOfPastEvents = eventGames.ToArray().Count();
int[] result = new int[numberOfPastEvents];
Event[] arrayEventGames = new Event[numberOfPastEvents];
arrayEventGames = eventGames.ToArray();
for(int i = 0; i < numberOfPastEvents; i++)
{
result[i] = arrayEventGames[i].idEvent;
}
return result;
}
}
return null;
}
public int CreateOrUpdateEvent(int id, string name, DateTime startDate, DateTime endDate, byte[] image, string description)
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
Event eventGame = null;
if (id == 0)
{
eventGame = new Event()
{
Name = name,
StartDate = startDate,
EndDate = endDate,
Image = "",
Description = description
};
db.Event.InsertOnSubmit(eventGame);
}
else
{
eventGame = db.Event.SingleOrDefault(e => e.idEvent == id);
if (name != "")
{
eventGame.Name = name;
}
eventGame.StartDate = startDate;
eventGame.EndDate = endDate;
if (description != "")
{
eventGame.Description = description;
}
}
try
{
if (image != null)
{
if (id == 0)
db.SubmitChanges();
string path = IMAGE_PATH + "events\\" + eventGame.idEvent + "-" + eventGame.Name;
if (!Directory.Exists(path))
Directory.CreateDirectory(IMAGE_PATH + "events\\" + eventGame.idEvent + "-" + eventGame.Name);
using (FileStream fs = new FileStream(path + "\\" + "cover", FileMode.OpenOrCreate, FileAccess.Write))
{
fs.Write(image, 0, image.Length);
eventGame.Image = path + "\\" + "cover";
}
}
db.SubmitChanges();
return eventGame.idEvent;
}
catch (Exception ex)
{
Console.WriteLine("ERROR CreateEvent " + ex.Message);
return -1;
}
}
}