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