//update all facebook details
static public void updateUser(SqlConnectionDataContext db, UserAccount u, string displayName, string Email, string photoURL)
{
u.DisplayName = displayName;
u.Email = Email;
u.PhotoURL = photoURL;
db.SubmitChanges();
}
//create user from facebook
static public void createUser(SqlConnectionDataContext db, string fid, string displayName, string Email, string photoURL)
{
//creating instance user
UserAccount u = new UserAccount();
u.DisplayName = displayName;
u.FacebookID = fid;
u.Email = Email;
u.PhotoURL = photoURL;
u.isAdmin = 0;
//update database
db.UserAccounts.InsertOnSubmit(u);
db.SubmitChanges();
}
// POST api/values
public string Post([FromBody] string value)
{
var dataContext = new SqlConnectionDataContext();
/*
* var query_eventID = (from sportEvents in dataContext.SportEvents
* orderby sportEvents.EventID descending
* select sportEvents.EventID).First();
* return query_eventID;
*/
var events = from sportEvents in dataContext.SportEvents
select sportEvents;
SportEvent sportEvent = new SportEvent {
Date = DateTime.Now,
Duration = 3,
MaxAttendies = 8,
CategoryName = "Football",
OwnerID = "8329795"
};
dataContext.SportEvents.InsertOnSubmit(sportEvent);
dataContext.SubmitChanges();
return(sportEvent.ToString());
/*
* int eventID;
* if (query_eventID is null)
* {
* eventID = (query_eventID);
* }
* eventID =
* if (eventID == null)
* eventID = 1;
*
* SportEvent sportEvent = new SportEvent();
* return "value";
*/
}
// POST: api/Events
public string Post(HttpRequestMessage value)
{
var dataContext = new SqlConnectionDataContext();
JObject json;
SportEvent sportEvent = new SportEvent();
//Reading the content of the request
string val = value.Content.ReadAsStringAsync().Result;
//converting the request to json
json = JObject.Parse(val);
sportEvent.OwnerID = Environment.UserName.ToString();
sportEvent.CategoryName = json["categories"].ToString();
sportEvent.Date = DateTime.Parse(json["datetime"].ToString());
string duration = json["duration"].ToString();
if (duration == "")
{
sportEvent.Duration = 2;
}
else
{
sportEvent.Duration = int.Parse(duration);
}
string attendies = json["attendies"].ToString();
if (attendies == "")
{
sportEvent.MaxAttendies = 50;
}
else
{
sportEvent.MaxAttendies = int.Parse(attendies);
}
sportEvent.location = json["location"].ToString();
sportEvent.notes = json["notes"].ToString();
if (sportEvent.title == "")
{
sportEvent.title = "ללא כותרת";
}
else
{
sportEvent.title = json["title"].ToString();
}
dataContext.SportEvents.InsertOnSubmit(sportEvent);
try
{
dataContext.SubmitChanges();
}
catch (Exception e)
{
dataContext.SubmitChanges();
}
return(val);
}