public string CreateFacultySchedule(FacultyScheduleDTO schedule) { using (officehoursEntities officeHoursDB = new officehoursEntities()) { officehours_schedule scheduleData = new officehours_schedule() { faculty_email = schedule.facultyEmail, schedule_color = schedule.scheduleColor, schedule_note = schedule.scheduleNote, schedule_start = schedule.scheduleStart, schedule_end = schedule.scheduleEnd, schedule_id = schedule.scheduleId, schedule_group = schedule.scheduleGroup }; officeHoursDB.officehours_schedule.Add(scheduleData); try { officeHoursDB.SaveChanges(); return(scheduleData.faculty_email); } catch (Exception e) { Console.WriteLine(e); return(e.Message); } } }
public List <FacultyScheduleDTO> GetFacultyScheduleByMailandDate(string email, DateTime startDate, DateTime endDate) { List <FacultyScheduleDTO> facultySchedules = new List <FacultyScheduleDTO>(); using (officehoursEntities officeHoursDB = new officehoursEntities()) { var facultyData = from f in officeHoursDB.officehours_schedule where f.faculty_email == email && (f.schedule_start >= startDate && f.schedule_end <= endDate) select f; foreach (officehours_schedule fac in facultyData) { if (fac != null) { FacultyScheduleDTO faculty = new FacultyScheduleDTO() { facultyEmail = fac.faculty_email, scheduleColor = fac.schedule_color, scheduleId = fac.schedule_id, scheduleNote = fac.schedule_note, scheduleStart = fac.schedule_start, scheduleEnd = fac.schedule_end, scheduleGroup = fac.schedule_group }; facultySchedules.Add(faculty); } } return(facultySchedules); } }
protected void addScheule_Click(object sender, EventArgs e) { var sTime = Convert.ToDateTime(starttimepickerTB.Text); string startTime = sTime.ToString("HH:mm:ss", CultureInfo.CurrentCulture); var eTime = Convert.ToDateTime(endTimepickerTB.Text); string endTime = eTime.ToString("HH:mm:ss", CultureInfo.CurrentCulture); DateTime startDateTime = Convert.ToDateTime(startdatepickerTB.Text + " " + startTime); DateTime endDateTime = Convert.ToDateTime(startdatepickerTB.Text + " " + endTime); FacultyScheduleDTO scheduleDTO = new FacultyScheduleDTO(); scheduleDTO.facultyEmail = Session["Email"].ToString(); scheduleDTO.scheduleStart = startDateTime; scheduleDTO.scheduleEnd = endDateTime; facultySchedule.CreateFacultySchedule(scheduleDTO); btnAddScheule.Text = "Add Again"; BindScheduleGridView(); }
public string CreateFacultySchedule(FacultyScheduleDTO schedule) { return(facultyScheduleDB.CreateFacultySchedule(schedule)); }