public JsonResult SignInDemoSave()
{
var 員工編號 = Convert.ToInt32(Request.Cookies["AutoLg"]["id"]);
var 中文姓名 = Server.UrlDecode(Request.Cookies["AutoLg"]["Name"]);
var 現在日期 = new DateTime(2021, 4, 15);
var 模擬上班打卡時間 = new DateTime(2021, 4, 15, 8, 30, 0);
var 模擬下班打卡時間 = new DateTime(2021, 4, 15, 18, 30, 0);
using (dbEIPEntities db = new dbEIPEntities())
{
打卡系統 v = new 打卡系統();
var v1 = db.打卡系統.Where(a => a.員工編號 == 員工編號 && a.打卡日期 == 現在日期).FirstOrDefault();
if (v1 == null)
{
v.員工編號 = 員工編號;
v.班打卡時間 = 模擬上班打卡時間;
v.打卡日期 = new DateTime(2021, 4, 15);
v.中文姓名 = 中文姓名;
v.ThemeColor = "gray";
sr.Create(v);
}
else
{
v1.員工編號 = 員工編號;
v1.打卡日期 = new DateTime(2021, 4, 15);
v1.中文姓名 = 中文姓名;
v1.班打卡時間 = 模擬下班打卡時間;
v1.ThemeColor = "green";
sr.Update(v1);
}
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public JsonResult SaveEvent(行事曆 e)
{
var status = false;
using (dbEIPEntities db = new dbEIPEntities())
{
if (e.EventID > 0)
{
//Update the event
var v = db.行事曆.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
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
{
db.行事曆.Add(e);
}
db.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
// ---------------------------以下Fullcalendar方法----------------------------//
public JsonResult GetEvents()
{
using (dbEIPEntities db = new dbEIPEntities())
{
var events = db.行事曆.ToList();
return(new JsonResult {
Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult DeleteEvent(int eventID)
{
var status = false;
using (dbEIPEntities db = new dbEIPEntities())
{
var v = db.行事曆.Where(a => a.EventID == eventID).FirstOrDefault();
if (v != null)
{
db.行事曆.Remove(v);
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
DbSet <Table> dbTable = null; // EntityFramework 的屬性
public EIPRepository()
{
db = new dbEIPEntities(); // 建立StoreDBEntities的實體
dbTable = db.Set <Table>();
}