protected void lbtAdd_Click(object sender, EventArgs e)
{
try
{
string alert;
int teacher = TeacherHelper.getTeacherIDByNumber(Session["TeacherNumber"].ToString());
//int teacher = 1;
int id;
//int teacher = 1, id = 3;
try
{
id = Convert.ToInt32(Request.QueryString["id"].ToString());
}
catch
{
id = 3;
}
using (var db = new TeachingCenterEntities())
{
Activity ac = db.Activity.Single(a => a.Activity_id == id);
if (ac.Activity_nowcount >= ac.Activity_limitcount)
{
alert = "操作失败，人数已达到上限。";
}
else if (ac.Activity_hold_time < DateTime.Now)
{
alert = "该活动已结束！";
}
else
{
var acs = from it in db.ActivityTeacher where it.teacher_id == teacher && it.activity_id == id select it;
if (acs.Count() > 0)
{
alert = "您已参加了该项目！";
}
else
{
ac.Activity_nowcount++;
db.SaveChanges();
ActivityTeacher at = new ActivityTeacher();
at.activity_id = id;
at.teacher_id = teacher;
db.ActivityTeacher.Add(at);
db.SaveChanges();
alert = "参与成功！";
}
}
}
JSHelper.ShowAlert(alert);
}
catch
{
JSHelper.ShowAlert("请先登录！");
}
}
protected void rptActivity_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
//int teacher = TeacherHelper.getTeacherIDByNumber(Session["TeacherNumber"].ToString());
int teacher = 1;
using (var db = new TeachingCenterEntities())
{
ActivityTeacher at = db.ActivityTeacher.Single(a => a.activity_id == id && a.teacher_id == teacher);
db.ActivityTeacher.Remove(at);
Activity ac = db.Activity.Single(a => a.Activity_id == id);
ac.Activity_nowcount--;
db.SaveChanges();
//JSHelper.ShowAlert("取消成功！");
JSHelper.js("window.location.reload();");
}
}
}
