Пример #1
0
 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();
 }
Пример #2
0
        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()
                }));
            }
        }
Пример #3
0
        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();
                    }
                }
            }
        }
Пример #4
0
        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()
                }));
            }
        }
Пример #5
0
 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();
 }