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