public JsonResult SaveEvent(MeetingRoomBooking e) { var status = false; if (e.BookingId > 0) { var v = db.MeetingRoomBooking.Where(a => a.BookingId == e.BookingId).FirstOrDefault(); if (v != null) { v.EmployeeID = e.EmployeeID; v.中文姓名 = e.中文姓名; v.MeetingRoomName = e.MeetingRoomName; v.MeetingSubject = e.MeetingSubject; v.BookingStartTime = e.BookingStartTime; v.BookingEndTime = e.BookingEndTime; v.MeetingAttentee = e.MeetingAttentee; v.MeetingRemark = e.MeetingRemark; v.IsAllDay = e.IsAllDay; } } else { db.MeetingRoomBooking.Add(e); } db.SaveChanges(); status = true; return(new JsonResult { Data = new { status = status } }); }
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 } }); }
public void SendGroup(int 類別, string 職稱, string message, string[] 限) //對特定群組發送通知 { foreach (var x in 限) { var 通知 = new 通知 { 通知類別id = 類別, 通知內容 = message, 讀取狀態 = "未讀", 通知權限 = x.ToString() }; db.通知.Add(通知); db.SaveChanges(); } var 通知類別轉換 = db.通知類別.FirstOrDefault(m => m.通知類別id == 類別); if (職稱 == "員工") { Clients.Group("員工").sendlv1(通知類別轉換.通知類別1, message, 限[3]); Clients.Group("人事").sendlv2(通知類別轉換.通知類別1, message, 限[2]); Clients.Group("主管").sendlv3(通知類別轉換.通知類別1, message, 限[1]); Clients.Group("總經理").sendtop(通知類別轉換.通知類別1, message, 限[0]); //sendtop=前端的function(自定義) } if (職稱 == "人事") { Clients.Group("人事").sendlv2(通知類別轉換.通知類別1, message, 限[2]); Clients.Group("主管").sendlv3(通知類別轉換.通知類別1, message, 限[1]); Clients.Group("總經理").snedlvtop(通知類別轉換.通知類別1, message, 限[0]); //sendtop=前端的function(自定義) } if (職稱 == "主管") { Clients.Group("主管").sendtop(通知類別轉換.通知類別1, message, 限[1]); Clients.Group("總經理").sendtop(通知類別轉換.通知類別1, message, 限[0]); } }
public string AskForAjax1(請假細項 k, HttpPostedFileBase upPhoto) // { string filePath = ""; if (upPhoto != null) { filePath = "/images/" + DateTime.Now.ToString("yyyyMMddhhmmss") + upPhoto.FileName; upPhoto.SaveAs(Server.MapPath("~") + filePath); } k.圖片 = filePath; db.請假細項.Add(k); db.SaveChanges(); return("ok"); }
public JsonResult EditPW(string pw) { int ID = Convert.ToInt32(Request.Cookies["AutoLg"]["id"]); db.人資料.FirstOrDefault(x => x.EmployeeID == ID).EmployeePW = pw; db.SaveChanges(); return(Json("", JsonRequestBehavior.AllowGet)); }
//---------- T E S T ----------------- public void getCr8formVal(pjProject val) { var x = new pjProject { pjName = val.pjName, pjIntroduction = val.pjIntroduction, pjManager = val.pjManager, pjClient = val.pjClient, pjBudget = val.pjBudget, pjMemberCount = val.pjMemberCount, pj結束日期 = val.pj結束日期, pj開始日期 = val.pj開始日期, pj預估時間 = val.pj預估時間, pjManagerId = val.pjManagerId, pj初審結果 = val.pj初審結果, pj審核階段 = val.pj審核階段, }; db.pjProject.Add(x); db.SaveChanges(); }
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 } }); }
public JsonResult PJEditDetail(pj總表 PJet) { var epj = new pj總表() { pjId = PJet.pjId, pjName = PJet.pjName, pjManager = PJet.pjManager, pjCreateId = PJet.pjCreateId, }; dbEIP.Entry(epj).State = EntityState.Modified; dbEIP.SaveChanges(); return(Json(epj, JsonRequestBehavior.AllowGet)); }
public void Create(Table _entity) { dbTable.Add(_entity); // 新增資料 db.SaveChanges(); }
public string addPj總表(pj總表 data) { db.pj總表.Add(data); db.SaveChanges(); return("ok"); }