//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();
}
public ActionResult getUsers(int eventid)
{
var dataContext = new SqlConnectionDataContext();
List <String> users = SportEventModel.getUsersByEvent(dataContext, eventid);
return(Json(users, JsonRequestBehavior.AllowGet));
}
// GET: api/Events
public SportEvent_Parsed[] Get()
{
var dataContext = new SqlConnectionDataContext();
Table <SportEvent> table_sportEvents = dataContext.SportEvents;
//IEnumerator<SportEvent> enu_sportEvents = table_sportEvents.GetEnumerator();
List <SportEvent> list_sportEvents = table_sportEvents.ToList();
SportEvent_Parsed[] toString = new SportEvent_Parsed[list_sportEvents.Count];
for (int i = 0; i < list_sportEvents.Count; i++)
{
//string json = JsonConvert.SerializeObject(list_sportEvents[i]);
toString[i] = parsedSportEvent(list_sportEvents[i]);
}
return(toString);
/*
* string val = "[{title: 'Chuki Fluki 1 ',category: \"לגרודכ\",owner: \"s6081260\",max_attendies: \"5\",location: \"םש להוא\",notes: \"רחאל אל\", startsAt: moment().startOf('week').add(3, 'days').toDate(),endsAt: moment().startOf('week').add(3, 'days').toDate() }]; ";
* JavaScriptSerializer java = new JavaScriptSerializer();
* string toreturn = java.Serialize(val);
* val = val.Replace("\"", "");
* return val;
*/
}
//get user by his facebook id
static public UserAccount getUser(SqlConnectionDataContext db, string userfID)
{
UserAccount usera =
(from u in db.UserAccounts
where u.FacebookID == userfID
select u).FirstOrDefault();
return(usera);
}
//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();
}
// GET: api/Category
public IEnumerable <string> Get()
{
var dataContext = new SqlConnectionDataContext();
Table <Category> table_Categories = dataContext.Categories;
//IEnumerator<SportEvent> enu_sportEvents = table_sportEvents.GetEnumerator();
List <Category> list_Categories = table_Categories.ToList();
string[] toString = new string[list_Categories.Count];
for (int i = 0; i < list_Categories.Count; i++)
{
toString[i] = list_Categories[i].Name;
}
return(toString);
}
// 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/Users
public void Post(HttpRequestMessage value)
{
var dataContext = new SqlConnectionDataContext();
JObject json;
UserAccount userAccount;
//Reading the content of the request
string val = value.Content.ReadAsStringAsync().Result;
//converting the request to json
json = JObject.Parse(val);
//parsing json
string DisplayName = json["displayName"].ToString();
string Email = json["email"].ToString();
string PhotoURL = json["photoURL"].ToString();
//retrieve user from database
string Userfid = json["fid"].ToString();
userAccount = getUser(dataContext, Userfid);
/*
* var claims = new List<Claim>();
* claims.Add(new Claim(ClaimTypes.Name, Userfid));
* var id = new ClaimsIdentity(claims,
* DefaultAuthenticationTypes.ApplicationCookie);
*
* var ctx = Request.GetOwinContext();
* var authenticationManager = ctx.Authentication;
* authenticationManager.SignIn(id);
*/
/*
* FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket
* (
* 1, DisplayName, DateTime.Now, DateTime.Now.AddMinutes(15), false, Userfid
* );
*
* string enTicket = FormsAuthentication.Encrypt(authTicket);
* HttpCookie faCookie = new HttpCookie("Cookie1", enTicket);
* Response.Cookies.Add(faCookie);
*/
bool auth = User.Identity.IsAuthenticated;
if (userAccount != null)
{
//update his details
Console.WriteLine("Registred");
updateUser(dataContext, userAccount, DisplayName, Email, PhotoURL);
}
else if (userAccount == null)
{
//register user
createUser(dataContext, Userfid, DisplayName, Email, PhotoURL);
}
//Managing Permission Level
/*
* if (userAccount.isAdmin == 1)
* {
* //user is admin
*
* }
*/
}
// 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);
}
