public async Task <ActionResult> DeleteConfirmed(int id)
{
TIMETABLE tIMETABLE = await db.TIMETABLE.FindAsync(id);
db.TIMETABLE.Remove(tIMETABLE);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public void LoadTimetable()
{
SqlConnection connection = new SqlConnection(MyProject.Properties.Settings.Default.Connection);
try
{
connection.Open();
}
finally
{
string select = $"SELECT * FROM TIMETABLE INNER JOIN (SELECT * FROM DOCTOR INNER JOIN TABLECONNECTION ON DOCTOR.DOCTORID=TABLECONNECTION.idDOCTOR) DOCTORS ON DOCTORS.idTAMETABLE=TIMETABLE.ID";
SqlCommand command = new SqlCommand(select, connection);
using (SqlDataReader reader = command.ExecuteReader())
{
int counter = 0;
Timetable timetable = new Timetable();
while (reader.Read())
{
if (counter == 5)
{
TIMETABLE.Add(timetable);
timetable = new Timetable();
counter = 0;
}
timetable.Room = reader.GetInt32(9);
timetable.Doctor = reader.GetString(6);
switch (reader.GetString(3))
{
case "Mon":
timetable.Mon = reader.GetTimeSpan(1).ToString().Remove(5, 3) + "-" + reader.GetTimeSpan(2).ToString().Remove(5, 3);
break;
case "Tues":
timetable.Tues = reader.GetTimeSpan(1).ToString().Remove(5, 3) + "-" + reader.GetTimeSpan(2).ToString().Remove(5, 3);
break;
case "Wed":
timetable.Wed = reader.GetTimeSpan(1).ToString().Remove(5, 3) + "-" + reader.GetTimeSpan(2).ToString().Remove(5, 3);
break;
case "Thurs":
timetable.Thurs = reader.GetTimeSpan(1).ToString().Remove(5, 3) + "-" + reader.GetTimeSpan(2).ToString().Remove(5, 3);
break;
case "Fri":
timetable.Fri = reader.GetTimeSpan(1).ToString().Remove(5, 3) + "-" + reader.GetTimeSpan(2).ToString().Remove(5, 3);
break;
}
counter++;
}
TIMETABLE.Add(timetable);
}
connection.Close();
Timetable = TIMETABLE[0];
}
}
// GET: TIMETABLEs/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TIMETABLE tIMETABLE = await db.TIMETABLE.FindAsync(id);
if (tIMETABLE == null)
{
return(HttpNotFound());
}
return(View(tIMETABLE));
}
public async Task <ActionResult> Edit([Bind(Include = "LESSON_CODE,WEEKDAY_CODE,COURSE_CODE,GROUP_CODE,TEACHER_CODE,DISCIPLINE_CODE,ACTIVITY_TYPE_CODE,AUDITORIUM_CODE,WEEK_NUMBER,TIME_CODE,CROSSES,TYPE_CODE")] TIMETABLE tIMETABLE)
{
if (ModelState.IsValid)
{
db.Entry(tIMETABLE).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.ACTIVITY_TYPE_CODE = new SelectList(db.ACTIVITY, "ACTIVITY_TYPE_CODE", "ACTIVITY_TYPE_NAME", tIMETABLE.ACTIVITY_TYPE_CODE);
ViewBag.AUDITORIUM_CODE = new SelectList(db.AUDITORIUM, "AUDITORIUM_CODE", "BUILDING", tIMETABLE.AUDITORIUM_CODE);
ViewBag.DISCIPLINE_CODE = new SelectList(db.DISCIPLINE, "DISCIPLINE_CODE", "DISCIPLINE_NAME", tIMETABLE.DISCIPLINE_CODE);
ViewBag.GROUP_CODE = new SelectList(db.GROUPS, "GROUP_CODE", "GROUP_NUMBER", tIMETABLE.GROUP_CODE);
ViewBag.TEACHER_CODE = new SelectList(db.TEACHER, "TEACHER_CODE", "TEACHER_NAME", tIMETABLE.TEACHER_CODE);
ViewBag.TIME_CODE = new SelectList(db.TIME, "TIME_CODE", "TIME_START", tIMETABLE.TIME_CODE);
ViewBag.TYPE_CODE = new SelectList(db.TYPE, "TYPE_CODE", "TYPE_NAME", tIMETABLE.TYPE_CODE);
ViewBag.WEEKDAY_CODE = new SelectList(db.WEEKDAY, "WEEKDAY_CODE", "WEEKDAY_NAME", tIMETABLE.WEEKDAY_CODE);
return(View(tIMETABLE));
}
// GET: TIMETABLEs/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TIMETABLE tIMETABLE = await db.TIMETABLE.FindAsync(id);
if (tIMETABLE == null)
{
return(HttpNotFound());
}
ViewBag.ACTIVITY_TYPE_CODE = new SelectList(db.ACTIVITY, "ACTIVITY_TYPE_CODE", "ACTIVITY_TYPE_NAME", tIMETABLE.ACTIVITY_TYPE_CODE);
ViewBag.AUDITORIUM_CODE = new SelectList(db.AUDITORIUM, "AUDITORIUM_CODE", "BUILDING", tIMETABLE.AUDITORIUM_CODE);
ViewBag.DISCIPLINE_CODE = new SelectList(db.DISCIPLINE, "DISCIPLINE_CODE", "DISCIPLINE_NAME", tIMETABLE.DISCIPLINE_CODE);
ViewBag.GROUP_CODE = new SelectList(db.GROUPS, "GROUP_CODE", "GROUP_NUMBER", tIMETABLE.GROUP_CODE);
ViewBag.TEACHER_CODE = new SelectList(db.TEACHER, "TEACHER_CODE", "TEACHER_NAME", tIMETABLE.TEACHER_CODE);
ViewBag.TIME_CODE = new SelectList(db.TIME, "TIME_CODE", "TIME_START", tIMETABLE.TIME_CODE);
ViewBag.TYPE_CODE = new SelectList(db.TYPE, "TYPE_CODE", "TYPE_NAME", tIMETABLE.TYPE_CODE);
ViewBag.WEEKDAY_CODE = new SelectList(db.WEEKDAY, "WEEKDAY_CODE", "WEEKDAY_NAME", tIMETABLE.WEEKDAY_CODE);
return(View(tIMETABLE));
}
private static extern bool VSNET_ClientSetImageAlarmTime(uint lUserID, int m_alarmType, int m_channel, int m_dayofweek,
ref TIMETABLE m_timelist);
private static extern bool VSNET_ClientSetAlarmOutTime(uint lUserID, int m_alarmOutID, int m_dayofweek,
ref TIMETABLE m_timelist);
