private static void addUserToEvent(SqlConnectionDataContext db, int eventID, int userID)
{
Users_Event ue = new Users_Event();
ue.EventID = eventID;
ue.UserID = userID;
db.Users_Events.InsertOnSubmit(ue);
try
{
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
partial void DeleteUsers_Event(Users_Event instance);
private void detach_Users_Events(Users_Event entity)
{
this.SendPropertyChanging();
entity.UserAccount = null;
}
partial void UpdateUsers_Event(Users_Event instance);
partial void InsertUsers_Event(Users_Event instance);
private void attach_Users_Events(Users_Event entity)
{
this.SendPropertyChanging();
entity.SportEvent = this;
}
public static void createEvent(FormCollection sportEventModel)
{
var dataContext = new SqlConnectionDataContext();
int placeID = getPlaceIDByName(dataContext, sportEventModel["location"]); //validate exist location
if (placeID == 0)
{
return;
}
int catID = getCategoryID(dataContext, sportEventModel["category"]); //validate exist category
if (catID == 0)
{
return;
}
SportEvent sportEvent = new SportEvent();
int userID = ManageCookie.user.UserID;
sportEvent.OwnerID = userID;
sportEvent.CategoryID = catID;
sportEvent.Date = DateTime.Parse(sportEventModel["datetime"]);
string duration = sportEventModel["duration"];
if (String.IsNullOrWhiteSpace(duration))
{
sportEvent.Duration = 120;
}
else
{
if (!ValidationModel.ValidDuration(duration)) //validate duration
{
return;
}
sportEvent.Duration = int.Parse(duration);
}
string max_attendies = sportEventModel["attendies"];
if (String.IsNullOrWhiteSpace(max_attendies))
{
sportEvent.MaxAttendies = 12;
}
else
{
if (!ValidationModel.ValidAttendies(max_attendies)) // validate attendies
{
return;
}
sportEvent.MaxAttendies = int.Parse(max_attendies);
}
string title = sportEventModel["title"];
sportEvent.PlaceID = placeID;
if (!ValidationModel.LengthAndNotSpecialValidationMaxOnly(title))
{
return;
}
sportEvent.title = title;
string notes = sportEventModel["notes"];
if (!ValidationModel.LengthAndNotSpecialValidationMaxOnly(notes))
{
return;
}
sportEvent.notes = notes;
dataContext.SportEvents.InsertOnSubmit(sportEvent);
try
{
dataContext.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
//insert to user_event table
Users_Event uevent = new Users_Event();
uevent.EventID = sportEvent.EventID;
uevent.UserID = sportEvent.OwnerID;
dataContext.Users_Events.InsertOnSubmit(uevent);
try
{
dataContext.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
//Retrieve ML instance
MLModel mlModel = MLModel.GetInstance();
//Predict classification for each user - ML
Hashtable usersPredict = mlModel.Predict(uevent.UserID, sportEvent);
//posting to facebook asyncly
new Task(() => { FacebookModel.PostFacebook(sportEvent.EventID, sportEvent.title, usersPredict); }).Start();
}
