private void CreateBoard(HttpContext context) { Data.dbml.Boards boards = new Data.dbml.Boards(); boards.Name = context.Request.Params["name"]; GetDataContext2.Boards.InsertOnSubmit(boards); GetDataContext2.SubmitChanges(); }
private void SaveCreatedBoard(HttpContext context) { string name = context.Request.Params["name"].Trim(); Data.dbml.Boards b = this.GetDataContext2.Boards.FirstOrDefault(o => o.Name == name && o.UserID == Common.UserID); if (b != null) { context.Response.WriteError(strings.ErrSameBoardName); } else { int catid = int.Parse(context.Request.Params["catid"]); string contributors = context.Request.Params["contributors[]"]; Data.dbml.Boards board = new Data.dbml.Boards() { Name = name, CatID = catid, UserID = Common.UserID.Value }; this.GetDataContext2.Boards.InsertOnSubmit(board); this.GetDataContext2.SubmitChanges(); if (!string.IsNullOrEmpty(contributors)) { string[] acontributors = contributors.Split(','); foreach (string contributor in acontributors) { this.GetDataContext2.BoardContributor.InsertOnSubmit(new Data.dbml.BoardContributor() { BoardID = board.ID, ContributorID = GetDataContext2.AppUsers.First(o => o.Email == contributor).ID }); } this.GetDataContext2.SubmitChanges(); } UpdatePoints(Common.PointsNewBoard); this.GetDataContext2.SubmitChanges(); UpdateUPCount(); context.WriteJsonP(JsonConvert.SerializeObject(new { boards = (from o in GetDataContext2.Boards where o.UserID == Common.UserID || (from o1 in this.GetDataContext2.BoardContributor where o1.ContributorID == Common.UserID select o1.BoardID).Contains(o.ID) select new { o.ID, o.Name }).Distinct() })); } }
private void SaveEditBoard(HttpContext context) { string name = context.Request.Params["name"].Trim(); int boardid = int.Parse(context.Request.Params["boardid"]); Data.dbml.Boards b = GetDataContext2.Boards.FirstOrDefault(o => o.Name == name && o.UserID == Common.UserID && o.ID != boardid); if (b != null) { context.Response.WriteError(strings.ErrSameBoardName); } else { int cat = int.Parse(context.Request.Params["catid"]); JArray removebc = JArray.Parse(context.Request.Params["removebc"]); JArray bc = JArray.Parse(context.Request.Params["bc"]); using (TransactionScope ts = new TransactionScope()) { try { foreach (JObject obj in removebc) { GetDataContext3.DeleteBoardContributor((string)obj["Email"], boardid).Execute(); } foreach (JObject obj in bc) { GetDataContext3.AddBoardContributor((string)obj["Email"], boardid).Execute(); } SubSonic.POCOS.Board board = GetDataContext3.Boards.Single(o => o.ID == boardid); board.CatID = cat; board.Name = name; board.Save(); ts.Complete(); } catch (Exception ex) { context.Response.WriteError(ex.Message); } finally { ts.Dispose(); } } } }
private void SaveCreatedBoard(HttpContext context) { string name = context.Request.Params["name"].Trim(); Data.dbml.Boards b = this.GetDataContext2.Boards.FirstOrDefault(o => o.Name == name && o.UserID == Common.UserID); if (b != null) context.Response.WriteError(strings.ErrSameBoardName); else { int catid = int.Parse(context.Request.Params["catid"]); string contributors = context.Request.Params["contributors[]"]; Data.dbml.Boards board = new Data.dbml.Boards() { Name = name, CatID = catid, UserID = Common.UserID.Value }; this.GetDataContext2.Boards.InsertOnSubmit(board); this.GetDataContext2.SubmitChanges(); if (!string.IsNullOrEmpty(contributors)) { string[] acontributors = contributors.Split(','); foreach (string contributor in acontributors) { this.GetDataContext2.BoardContributor.InsertOnSubmit(new Data.dbml.BoardContributor() { BoardID = board.ID, ContributorID = GetDataContext2.AppUsers.First(o => o.Email == contributor).ID }); } this.GetDataContext2.SubmitChanges(); } UpdatePoints(Common.PointsNewBoard); this.GetDataContext2.SubmitChanges(); UpdateUPCount(); context.WriteJsonP(JsonConvert.SerializeObject(new { boards = (from o in GetDataContext2.Boards where o.UserID == Common.UserID || (from o1 in this.GetDataContext2.BoardContributor where o1.ContributorID == Common.UserID select o1.BoardID).Contains(o.ID) select new { o.ID, o.Name }).Distinct() })); } }
private void CreateBoard(HttpContext context) { Data.dbml.Boards boards = new Data.dbml.Boards(); boards.Name = context.Request.Params["name"]; GetDataContext2.Boards.InsertOnSubmit(boards); GetDataContext2.SubmitChanges(); }