public bool AddNewRoom(GroopsRoom newRoom) { DataClassesContextDataContext db = new DataClassesContextDataContext(); var thisRoom = new GroopsRoom(); thisRoom.Name = newRoom.Name; thisRoom.CreatorUserId = newRoom.CreatorUserId; thisRoom.ID = newRoom.ID; db.GroopsRooms.InsertOnSubmit(thisRoom); //submit the changes to the database try { db.SubmitChanges(); return(true); } catch (Exception e) { Console.WriteLine(e.ToString()); return(false); } }
public bool AddNewUser(GroopsUser oneGroopMember) { //var ctx = HttpContext.Current; //if (ctx != null) //{ // try // { // var currentData = ((GroopsAPI[])ctx.Cache[CacheKey]).ToList(); // currentData.Add(oneGroopMember); // ctx.Cache[CacheKey] = currentData.ToArray(); // return true; // } // catch (Exception ex) // { // Console.WriteLine(ex.ToString()); // return false; // } //} DataClassesContextDataContext db = new DataClassesContextDataContext(); var thisUser = new GroopsUser(); thisUser.Name = oneGroopMember.Name; thisUser.Email = oneGroopMember.Email; thisUser.ID = oneGroopMember.ID; db.GroopsUsers.InsertOnSubmit(thisUser); //submit the changes to the database try { db.SubmitChanges(); return(true); } catch (Exception e) { Console.WriteLine(e.ToString()); return(false); } }
public string addNewComment(Guid userId, string message, Guid roomId) { DataClassesContextDataContext db = new DataClassesContextDataContext(); GroopsMessages thisMessage = new GroopsMessages(); thisMessage.Content = message; thisMessage.ID = Guid.NewGuid(); thisMessage.RoomId = roomId; thisMessage.UserId = userId; thisMessage.Created = DateTime.Now; db.GroopsMessages.InsertOnSubmit(thisMessage); try { db.SubmitChanges(); return(userIdToUserName(userId)); } catch (Exception e) { return(null); } }
public string addNewComment(Guid userId, string message, Guid roomId) { DataClassesContextDataContext db = new DataClassesContextDataContext(); GroopsMessages thisMessage = new GroopsMessages(); thisMessage.Content = message; thisMessage.ID = Guid.NewGuid(); thisMessage.RoomId = roomId; thisMessage.UserId = userId; thisMessage.Created = DateTime.Now; db.GroopsMessages.InsertOnSubmit(thisMessage); try { db.SubmitChanges(); return userIdToUserName(userId); } catch (Exception e) { return null; } }
public bool AddNewUser(GroopsUser oneGroopMember) { //var ctx = HttpContext.Current; //if (ctx != null) //{ // try // { // var currentData = ((GroopsAPI[])ctx.Cache[CacheKey]).ToList(); // currentData.Add(oneGroopMember); // ctx.Cache[CacheKey] = currentData.ToArray(); // return true; // } // catch (Exception ex) // { // Console.WriteLine(ex.ToString()); // return false; // } //} DataClassesContextDataContext db = new DataClassesContextDataContext(); var thisUser = new GroopsUser(); thisUser.Name = oneGroopMember.Name; thisUser.Email = oneGroopMember.Email; thisUser.ID = oneGroopMember.ID; db.GroopsUsers.InsertOnSubmit(thisUser); //submit the changes to the database try { db.SubmitChanges(); return true; } catch (Exception e) { Console.WriteLine(e.ToString()); return false; } }
public bool AddNewRoom(GroopsRoom newRoom) { DataClassesContextDataContext db = new DataClassesContextDataContext(); var thisRoom = new GroopsRoom(); thisRoom.Name = newRoom.Name; thisRoom.CreatorUserId = newRoom.CreatorUserId; thisRoom.ID = newRoom.ID; db.GroopsRooms.InsertOnSubmit(thisRoom); //submit the changes to the database try { db.SubmitChanges(); return true; } catch (Exception e) { Console.WriteLine(e.ToString()); return false; } }