コード例 #1
0
 protected void btnDeleteSchedule_Click(object sender, EventArgs e)
 {
     int sid = Convert.ToInt32(Request.QueryString["id"]);
     Schedule Schedule = new Schedule();
     using (Dal.DB db = new Dal.DB())
     {
         Schedule = db.Schedules.Find(sid);
         db.Schedules.Remove(Schedule);
         db.SaveChanges();
     }
     Response.Redirect("Admin_Schedules.aspx");
 }
コード例 #2
0
        protected void btnSubmitUpdate_Click(object sender, EventArgs e)
        {
            int sid = Convert.ToInt32(Request.QueryString["id"]);
            User User=(User)Session["User"];
            Schedule Schedule = new Schedule();
            using (Dal.DB db = new Dal.DB())
            {
                Schedule = db.Schedules.Find(sid);
                Schedule.Title = txtEditScheduleName.Text;
                Schedule.Content = txtEditScheduleContent.Text;
                Schedule.Time = DateTime.Now;
                Schedule.ToUserID = Convert.ToInt32(ddlEditScheduleToUser.SelectedValue);
                Schedule.SubmittionUserID = User.ID;
                Schedule.DepartmentID = Convert.ToInt32(ddlEditScheduleDepartment.SelectedValue);

                db.SaveChanges();
            }

            Response.Redirect("Admin_Schedules.aspx");
        }
コード例 #3
0
 public static string AddSchedule(int submit_user_id, int to_user_id, string title, string content, int department_id)
 {
     Schedule Schedule = new Schedule();
     Schedule.ToUserID = to_user_id;
     Schedule.SubmittionUserID = submit_user_id;
     Schedule.Title = title;
     Schedule.Content = content;
     Schedule.DepartmentID = department_id;
     Schedule.Time = DateTime.Now;
     using (Dal.DB db = new DB())
     {
         db.Schedules.Add(Schedule);
         db.SaveChanges();
     }
     return "ok";
 }