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(); }