public JsonResult ChatRefresh(ChatObject aaa)
{
var my_lock = new object();
var objs = new List<ChatObject>();
using (var db = new ObjectDatabase())
{
var x = db.ChatLog.Where(m => m.BoardId == aaa.BoardId);
objs.AddRange(x.ToArray());
}
return Json(objs);
}
public ActionResult BoardList()
{
var objs = new List<BoardList>();
var uid = User.Identity.GetUserId();
using (var db = new ObjectDatabase())
{
var x = db.Boards.Join(db.Permissions, c => c.BoardId, cm => cm.BoardId, (a, b) => new BoardList { BoardId = a.BoardId, Owner = b.UserId, Name = a.Name }).Where(m => m.Owner == uid);
objs.AddRange(x.ToArray());
}
return View(objs);
}
public ActionResult FriendList()
{
var objs = new List<Friendship>();
var uid = User.Identity.GetUserId();
using (var db = new ObjectDatabase())
{
var x = db.Friendships.Where(m => (m.UserId == uid || m.FriendId == uid));
objs.AddRange(x.ToArray());
}
ViewBag.User = uid;
return View(objs);
}
public ActionResult DeclineFriend(int? id)
{
using (var db = new ObjectDatabase())
{
var x = db.Friendships.Single(m => m.FriendshipId == id);
if (x == null)
return new HttpNotFoundResult();
db.Friendships.Remove(x);
db.SaveChanges();
}
return RedirectToAction("FriendList", "Admin");
}
public ActionResult AcceptFriend(int? id)
{
using (var db = new ObjectDatabase())
{
var x = db.Friendships.SingleOrDefault(m => m.FriendshipId == id);
if (x == null)
return new HttpNotFoundResult();
x.Accepted = true;
db.SaveChanges();
}
return RedirectToAction("FriendList", "Admin");
}
public JsonResult ChatAdd(ChatObject aaa)
{
var objs = new List<ChatObject>();
aaa.Timestamp = DateTime.Now;
using (var db = new ObjectDatabase())
{
db.ChatLog.Add(aaa);
db.SaveChanges();
var x = db.ChatLog.Where(m => m.BoardId == aaa.BoardId);
objs.AddRange(x.ToArray());
}
return Json(objs);
}
public ActionResult Index(int? id)
{
string uid = User.Identity.GetUserId();
if (id != null)
{
using (var db = new ObjectDatabase()) {
var x = db.Permissions.SingleOrDefault(m => (m.BoardId == id && m.UserId == uid));
if (x != null) {
return View();
}
}
}
return new HttpNotFoundResult();
}
public JsonResult Delete(GraphicObject aaa)
{
string uid = User.Identity.GetUserId();
var objs = new List<GraphicObject>();
using (var db = new ObjectDatabase())
{
var z = db.Permissions.SingleOrDefault(m => (m.BoardId == aaa.BoardId && m.UserId == uid && m.DeleteObject == true));
if (z != null)
{
var obj = db.GraphicObjects.SingleOrDefault(m => m.GraphicObjectId == aaa.GraphicObjectId);
if (obj != null)
{
db.GraphicObjects.Remove(obj);
db.SaveChanges();
}
}
var x = db.GraphicObjects.Where(m => m.BoardId == aaa.BoardId);
objs.AddRange(x.ToArray());
}
return Json(objs);
}
public ActionResult PermissionList()
{
var objs = new List<Permission>();
using (var db = new ObjectDatabase())
{
objs.AddRange(db.Permissions.ToArray());
}
return View(objs);
}
public ActionResult _PermissionPartial(Permission a)
{
//a.UserId = User.Identity.GetUserId();
using (var db = new ObjectDatabase())
{
db.Permissions.Add(a);
db.SaveChanges();
}
ViewBag.Status = "success";
return RedirectToAction("PermissionList");
}
public ActionResult _FriendPartial(Friendship a)
{
a.UserId = User.Identity.GetUserId();
using (var db = new ObjectDatabase())
{
db.Friendships.Add(a);
db.SaveChanges();
}
ViewBag.Status = "success";
return RedirectToAction("FriendList");
}
public ActionResult _BoardPartial(Board a)
{
a.UserId = User.Identity.GetUserId();
using (var db = new ObjectDatabase())
{
db.Boards.Add(a);
db.SaveChanges();
db.Permissions.Add(new Permission { UserId = a.UserId, BoardId = a.BoardId, AddObject = true, DeleteObject = true, EditObject = true });
db.SaveChanges();
}
ViewBag.Status = "success";
return RedirectToAction("BoardList");
}
public JsonResult Update(GraphicObject aaa)
{
string uid = User.Identity.GetUserId();
var objs = new List<GraphicObject>();
using (var db = new ObjectDatabase())
{
var z = db.Permissions.SingleOrDefault(m => (m.BoardId == aaa.BoardId && m.UserId == uid && m.EditObject == true));
if (z != null)
{
var obj = db.GraphicObjects.SingleOrDefault(m => m.GraphicObjectId == aaa.GraphicObjectId);
if (obj != null)
{
obj.x = aaa.x;
obj.y = aaa.y;
obj.fill = aaa.fill;
obj.stroke = aaa.stroke;
obj.stroke_width = aaa.stroke_width;
obj.width = aaa.width;
obj.height = aaa.height;
db.SaveChanges();
}
}
var x = db.GraphicObjects.Where(m => m.BoardId == aaa.BoardId);
objs.AddRange(x.ToArray());
}
return Json(objs);
}
public JsonResult Refresh(GraphicObject aaa)
{
var objs = new List<GraphicObject>();
using (var db = new ObjectDatabase())
{
var x = db.GraphicObjects.Where(m => m.BoardId == aaa.BoardId);
objs.AddRange(x.ToArray());
}
return Json(objs);
}
