public JsonResult GetEvents()
{
using (MSIT116APEXEntities dc = new MSIT116APEXEntities())
{
var userid = User.Identity.GetUserId();
var intname = (from a in db.User
where a.nvarcharID == userid
select
a.UserID
).FirstOrDefault();
var q = (from a in db.User
where a.UserID == intname
select new
{
color = a.Department.depThemeColor
}).First();
var q1 = from a in dc.Events
where (a.UserID == intname) ||
(a.ThemeColor == q.color)
select a;
//var events = dc.Events.Where(p=>p.UserID==1).ToList();
return(new JsonResult {
Data = q1.ToList(), JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public static string GetUserSName(this IIdentity identity)
{
//string claimValue = ((ClaimsIdentity)identity).FindFirst("UserName").Value;
MSIT116APEXEntities db = new MSIT116APEXEntities();
AspNetUsers anu = db.AspNetUsers.Where(n => n.UserName == identity.Name).FirstOrDefault();
// Test for null to avoid issues during local testing
return((anu != null) ? anu.Name : "");
}
public JsonResult DeleteEvent(int eventID)
{
var status = false;
using (MSIT116APEXEntities dc = new MSIT116APEXEntities())
{
var v = dc.Events.Where(a => a.EventID == eventID).FirstOrDefault();
if (v != null)
{
dc.Events.Remove(v);
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult SaveEvent(Events e)
{
var status = false;
using (MSIT116APEXEntities dc = new MSIT116APEXEntities())
{
var userid = User.Identity.GetUserId();
var intname = (from a in db.User
where a.nvarcharID == userid
select
a.UserID
).FirstOrDefault();
if (e.ThemeColor != "aqua")
{
var intDepartmentID = (from a in db.User
where a.nvarcharID == userid
select
a.DepartmentID
).FirstOrDefault();
var q2 = (from a in db.Department
where a.departmentID == intDepartmentID
select a.departmentName).FirstOrDefault();
var q = from a in db.User
where a.DepartmentID == intDepartmentID
select new
{
a.AspNetUsers.UserName
};
List <string> uesrname = new List <string>();
foreach (var item in q)
{
uesrname.Add(item.UserName);
}
for (int i = 0; i <= uesrname.Count - 1; i++)
{
NewsHub.SendMessageToUser(User.Identity.GetUserName(), uesrname[i], q2 + "新增行程", e.Description, "");
}
}
if (e.EventID > 0)
{
//Update the event
var v = dc.Events.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
v.UserID = intname;
v.Subject = e.Subject;
v.Start = e.Start;
v.End = e.End;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColor = e.ThemeColor;
}
}
else
{
e.UserID = intname;
dc.Events.Add(e);
}
dc.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public InterviewRepository()
{
db = new MSIT116APEXEntities();
dbset = db.Set <T>();
}