protected void Button1_Click(object sender, EventArgs e)
{
if (lblstare.Text == "點擊星星評價")
{
Response.Write("<script>alert('請選擇評價分數');</script>");
}
else if (Convert.ToInt32(Request["Sid"]) > 0 && (!string.IsNullOrEmpty(Request["Sid"])))
{
tCalendar x = db.tCalendar.First(t => t.fIdServices == Convert.ToInt32(Request["Sid"]));
x.fOK = "True";
//更新
db.SubmitChanges();
var newEva = new tEvaluation
{
fidMember = id,
fidServices = Convert.ToInt32(Request["Sid"]),
fStar = Convert.ToInt32(lblstare.Text),
fContent = tbContent.Text,
};
db.tEvaluation.InsertOnSubmit(newEva);
db.SubmitChanges();
Response.Redirect("memberCenter_New.aspx?tab=5&suc=1");
// Response.Write("<script language=javascript>alert('評價成功!')</script>");
// Response.Write("<script language=javascript>window.location.href='memberCenter_New.aspx'</script>");
}
else
{
Response.Write("<script language=javascript>alert('評價失敗!')</script>");
}
}
public string Create(tProjectDetail target)
{
TempData.Keep();
var prjId = TempData["prjId"] as int?;
if (target.fTaskName == null || target.fEmployeeId == null)
{
//任務名稱不為空
return("error");
}
tProjectDetail prjDetail = new tProjectDetail();
prjDetail.fProjectId = target.fProjectId;
prjDetail.fLevelId = target.fLevelId;
prjDetail.fTaskName = target.fTaskName;
prjDetail.fEmployeeId = target.fEmployeeId;
prjDetail.fStatus = target.fStatus;
prjDetail.fStartTime = target.fStartTime;
prjDetail.fDeadline = target.fDeadline;
prjDetail.fRemarks = target.fRemarks;
prjDetail.fTimes = 0;
db.tProjectDetails.Add(prjDetail);
db.SaveChanges();
updateProgress(prjDetail.fProjectId);
var startTime = prjDetail.fStartTime;
var deadline = prjDetail.fDeadline;
//發通知給任務負責人
tNotify notify = new tNotify();
notify.fEmployeeId = Convert.ToInt32(prjDetail.fEmployeeId);
notify.fTitle = prjDetail.tProject.fProjectName;
notify.fContent = "請到我的任務查看新任務";
notify.fType = 0;
notify.fTime = DateTime.Now;
db.tNotifies.Add(notify);
db.SaveChanges();
//存到行事曆上
tCalendar task = new tCalendar();
task.fEmployeeId = prjDetail.fEmployeeId;
task.fStart = Convert.ToDateTime(startTime).ToString("yyyy-MM-dd");
task.fEnd = Convert.ToDateTime(deadline).ToString("yyyy-MM-dd");
task.fTitle = db.tProjects.Where(p => p.fProjectId == prjDetail.fProjectId).FirstOrDefault().fProjectName;
task.fContent = prjDetail.fTaskName;
task.fSort = "1";
db.tCalendars.Add(task);
db.SaveChanges();
return("success");
}
public string InsertCalendar(string id, string start, string end, string title, string content)
{
HttpCookie cookie = Request.Cookies["id"];
int empid = Convert.ToInt32(cookie.Value);
EIP_DBEntities db = new EIP_DBEntities();
string json = "";
IQueryable list;
if (string.IsNullOrEmpty(id))
{
tCalendar tc = new tCalendar();
tc.fTitle = title;
tc.fContent = content;
tc.fStart = start;
tc.fEnd = end;
tc.fEmployeeId = empid;
tc.fSort = "0";
db.tCalendars.Add(tc);
db.SaveChanges();
list = from c in db.tCalendars
where c.fEmployeeId == tc.fEmployeeId
select new {
c.fId,
c.fTitle,
c.fStart,
c.fEnd,
c.fSort
};
json = JsonConvert.SerializeObject(list);
return(json);
}
//現有行事曆
int fid = Convert.ToInt32(id);
var listu = (db.tCalendars.Where(x => x.fId == fid)).FirstOrDefault();
listu.fStart = start;
listu.fEnd = end;
listu.fTitle = title;
listu.fContent = content;
db.SaveChanges();
list = from c in db.tCalendars
where c.fEmployeeId == empid
select new
{
c.fId,
c.fContent,
c.fTitle,
c.fStart,
c.fEnd,
c.fSort
};
json = JsonConvert.SerializeObject(list);
return(json);
}