public static bool deleteEvent(int eventID)
{
var db = new SqlConnectionDataContext();
var result =
(from esport in db.SportEvents
where esport.EventID == eventID
select esport).FirstOrDefault();
if (result == null)
{
return(false);
}
db.SportEvents.DeleteOnSubmit(result);
foreach (Users_Event uevent in db.Users_Events.Where(p => p.EventID == eventID))
{
db.Users_Events.DeleteOnSubmit(uevent);
}
try
{
db.SubmitChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
// Provide for exceptions.
}
}
public static bool cancelEvent(int eventID, int userID)
{
var db = new SqlConnectionDataContext();
var result =
(from uevent in db.Users_Events
where uevent.EventID == eventID && uevent.UserID == userID
select uevent).FirstOrDefault();
if (result == null)
{
return(false);
}
db.Users_Events.DeleteOnSubmit(result);
try
{
db.SubmitChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
// Provide for exceptions.
}
}
//update all facebook details
private static void updateUser(SqlConnectionDataContext db, UserAccount u, string displayName, string Email, string photoURL, string accessToken)
{
u.DisplayName = displayName;
u.Email = Email;
u.PhotoURL = photoURL;
u.LastLogon = DateTime.Now;
u.accessToken = accessToken;
db.SubmitChanges();
}
public static void removeUserByID(int userID)
{
var db = new SqlConnectionDataContext();
var user = db.UserAccounts.Where(u => u.UserID == userID).SingleOrDefault();
if (user != null)
{
db.UserAccounts.DeleteOnSubmit(user);
db.SubmitChanges();
}
}
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);
}
}
public static bool updatePlaceInput(FormCollection placeUpdate)
{
// Valid place input
if (!ValidationModel.LengthAndNotSpecialValidation(placeUpdate["name"]) ||
!ValidationModel.LengthAndNotSpecialValidation(placeUpdate["address"]) ||
!ValidationModel.LengthAndNotSpecialValidation(placeUpdate["description"]) ||
!ValidationModel.isDouble(placeUpdate["lat"]) ||
!ValidationModel.isDouble(placeUpdate["lng"]))
{
return(false);
}
var db = new SqlConnectionDataContext();
int placeID = int.Parse(placeUpdate["placeID"]);
var placeObj =
(from place in db.Places
where place.Id == placeID
select place).SingleOrDefault();
// Execute the query, and change the column values
// you want to change.
placeObj.Name = placeUpdate["name"];
placeObj.Address = placeUpdate["address"];
placeObj.Description = placeUpdate["description"];
placeObj.lat = double.Parse(placeUpdate["lat"]);
placeObj.lng = double.Parse(placeUpdate["lng"]);
// Insert any additional changes to column values.
// Submit the changes to the database.
try
{
db.SubmitChanges();
return(true);
}
catch (Exception e)
{
return(false);
// Provide for exceptions.
}
return(true);
}
//create user from facebook
private static void createUser(SqlConnectionDataContext db, string fid, string displayName, string Email, string photoURL, string Hash, string accessToken)
{
//creating instance user
UserAccount u = new UserAccount();
u.DisplayName = displayName;
u.FacebookID = fid;
u.Email = Email;
u.PhotoURL = photoURL;
u.isAdmin = 0;
u.LastLogon = DateTime.Now;
u.Hash = Hash;
u.accessToken = accessToken;
//update database
db.UserAccounts.InsertOnSubmit(u);
db.SubmitChanges();
}
public static bool updateUserInput(FormCollection userUpdate)
{
// Valid user input
if (!ValidationModel.EmailValidation(userUpdate["email"]) ||
!ValidationModel.LengthAndNotSpecialValidation(userUpdate["name"]) ||
!ValidationModel.LengthAndNotSpecialValidation(userUpdate["address"]) ||
!ValidationModel.isInt(userUpdate["admin"]))
{
return(false);
}
var db = new SqlConnectionDataContext();
int userID = int.Parse(userUpdate["userID"]);
var userObj =
(from user in db.UserAccounts
where user.UserID == userID
select user).SingleOrDefault();
// Execute the query, and change the column values
// you want to change.
userObj.DisplayName = userUpdate["name"];
userObj.Address = userUpdate["address"];
userObj.Email = userUpdate["email"];
userObj.isAdmin = Byte.Parse(userUpdate["admin"]);
// Insert any additional changes to column values.
// Submit the changes to the database.
try
{
db.SubmitChanges();
return(true);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
return(false);
// Provide for exceptions.
}
return(true);
}
public static void removePlaceByID(int placeID)
{
var db = new SqlConnectionDataContext();
//delete dependencies events
var events = db.SportEvents.Where(s => s.PlaceID == placeID).ToList();
foreach (var sevent in events)
{
SportEventModel.deleteEventLocal(sevent.EventID);
}
//delete place
var place = db.Places.Where(p => p.Id == placeID).SingleOrDefault();
if (place != null)
{
db.Places.DeleteOnSubmit(place);
db.SubmitChanges();
}
}
public static void updateEventInput(FormCollection eventUpdate)
{
// Valid event input
if (!ValidationModel.LengthAndNotSpecialValidationMaxOnly(eventUpdate["title"]) ||
!ValidationModel.isDateTime(eventUpdate["date"]) ||
!ValidationModel.ValidAttendies(eventUpdate["attendies"]) ||
!ValidationModel.ValidDuration(eventUpdate["duration"]) ||
!ValidationModel.LengthAndNotSpecialValidationMaxOnly(eventUpdate["notes"]))
{
return;
}
var db = new SqlConnectionDataContext();
int eventID = int.Parse(eventUpdate["eventID"]);
var eventObj =
(from e in db.SportEvents
where e.EventID == eventID
select e).SingleOrDefault();
// Execute the query, and change the column values
// you want to change.
eventObj.title = eventUpdate["title"];
eventObj.Date = DateTime.Parse(eventUpdate["date"]);
eventObj.MaxAttendies = int.Parse(eventUpdate["attendies"]);
eventObj.Duration = int.Parse(eventUpdate["duration"]);
eventObj.notes = eventUpdate["notes"];
try
{
db.SubmitChanges();
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
// Provide for exceptions.
}
}
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();
}