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