private void DBConnectedTimetable()
{
MySqlConnection con = new MySqlConnection("server=localhost;uid=root;pwd=;database=semester_planner;");
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "select * from timetable ";
cmd.Connection = con;
MySqlDataReader reader = cmd.ExecuteReader();
Timetable = new List <timetable>();
while (reader.Read())
{
int id = reader.GetInt32(0);
String user_id = reader.GetValue(1) + "";
String subject = reader.GetValue(2) + "";
String complete_time = reader.GetValue(3) + "";
String chapter = reader.GetValue(4) + "";
String[] quiz = (reader.GetValue(5) + "").Split('-');
String[] test = (reader.GetValue(6) + "").Split('-');
String[] assignment = (reader.GetValue(7) + "").Split('-');
String focus_scale = reader.GetValue(8) + "";
String[] day = (reader.GetValue(9) + "").Split('-');
timetable temp = new timetable(id, user_id, subject, complete_time, chapter, quiz, test, assignment, focus_scale, day);
Timetable.Add(temp);
}
con.Close();
}
public void deleteTimetableById(int id)
{
timetable p = ut.TimetableRepository.GetById(id);
ut.TimetableRepository.Delete(p);
ut.commit();
}
// GET: Timetable/Edit/5
public ActionResult Edit(int id)
{
timetable h = a.getTimetableById(id);
a.deleteTimetableById(id);
return(View(h));
}
public void update(int id)
{
timetable p = ut.TimetableRepository.GetById(id);
ut.TimetableRepository.Update(p);
ut.commit();
}
public ActionResult DeleteConfirmed(int id)
{
timetable timetable = db.timetables.Find(id);
db.timetables.Remove(timetable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "table_id,table_day,table_session1,table_session2,table_session3,table_session4,table_session5,table_session6,table_session7,table_session8")] timetable timetable)
{
if (ModelState.IsValid)
{
db.Entry(timetable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(timetable));
}
// GET: Timetable/Details/5 /
public ActionResult Details(int id)
{
timetable c = a.getTimetableById(id);
if (c == null)
{
return(HttpNotFound());
}
return(View(c));
}
public ActionResult Create([Bind(Include = "table_id,table_day,table_session1,table_session2,table_session3,table_session4,table_session5,table_session6,table_session7,table_session8")] timetable timetable)
{
if (ModelState.IsValid)
{
db.timetables.Add(timetable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(timetable));
}
public ActionResult Edit([Bind(Include = "timetable_id,compus_id")] timetable timetable)
{
if (ModelState.IsValid)
{
db.Entry(timetable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.compus_id = new SelectList(db.Compus, "compus_id", "compusnam", timetable.compus_id);
return(View(timetable));
}
public ActionResult Edit(int id, timetable h)
{
try {
// if (ModelState.IsValid)
// a.addConge(h);
return(RedirectToAction("Index"));
}
catch { return(View()); }
}
public ActionResult Create([Bind(Include = "timetable_id,compus_id")] timetable timetable)
{
if (ModelState.IsValid)
{
db.timetables.Add(timetable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.compus_id = new SelectList(db.Compus, "compus_id", "compusnam", timetable.compus_id);
return(View(timetable));
}
public ActionResult Edit([Bind(Include = "timetable_id,class_id_fk,faculty_id_fk,suubject_fk_id,date_time,dayss")] timetable timetable)
{
if (ModelState.IsValid)
{
db.Entry(timetable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.class_id_fk = new SelectList(db.tbl_class, "class_id", "class_name", timetable.class_id_fk);
ViewBag.faculty_id_fk = new SelectList(db.tbl_faculty_details, "faculty_Id", "facullty_name", timetable.faculty_id_fk);
ViewBag.suubject_fk_id = new SelectList(db.tbl_subject, "sub_id", "sub_name", timetable.suubject_fk_id);
return(View(timetable));
}
// GET: timetables/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
timetable timetable = db.timetables.Find(id);
if (timetable == null)
{
return(HttpNotFound());
}
return(View(timetable));
}
public ActionResult Create(timetable h)
{
if (ModelState.IsValid)
{
a.addTimetable(h);
return(RedirectToAction("IndexBack"));
}
else
{
return(View());
}
}
// GET: /timetable/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
timetable timetable = db.timetables.Find(id);
if (timetable == null)
{
return(HttpNotFound());
}
ViewBag.compus_id = new SelectList(db.Compus, "compus_id", "compusnam", timetable.compus_id);
return(View(timetable));
}
public ClassTimetable(timetable timetable)
{
if (timetable != null)
{
this.Id = timetable.Id;
this.SubjectId = timetable.SubjectId;
this.ClassId = timetable.ClassId;
this.SectionId = timetable.SectionId;
this.IsActive = timetable.IsActive;
this.DayId = timetable.DayId;
this.StartTime = timetable.StartTime;
this.EndTime = timetable.EndTime;
this.RoomNo = timetable.RoomNo;
}
}
// GET: timetables/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
timetable timetable = db.timetables.Find(id);
if (timetable == null)
{
return(HttpNotFound());
}
ViewBag.class_id_fk = new SelectList(db.tbl_class, "class_id", "class_name", timetable.class_id_fk);
ViewBag.faculty_id_fk = new SelectList(db.tbl_faculty_details, "faculty_Id", "facullty_name", timetable.faculty_id_fk);
ViewBag.suubject_fk_id = new SelectList(db.tbl_subject, "sub_id", "sub_name", timetable.suubject_fk_id);
return(View(timetable));
}
public EditTimetableDataPage(DispatcherWindow dispatcherWindow)
{
InitializeComponent();
Groups = Connection.Database.groups.ToList();
Audiences = Connection.Database.audiences.ToList();
Teachers = Connection.Database.teachers.ToList();
Disciplines = Connection.Database.disciplines.ToList();
Dir_Lessons = Connection.Database.dir_lessons.ToList();
Days_Weeks = Connection.Database.days_week.ToList();
CurrentRow = new timetable();
this.dispatcherWindow = dispatcherWindow;
DataContext = this;
}
public timetable GetDataObject()
{
var dataObject = new timetable()
{
Id = this.Id,
SubjectId = this.SubjectId,
ClassId = this.ClassId,
SectionId = this.SectionId,
IsActive = this.IsActive,
DayId = this.DayId,
StartTime = this.StartTime,
EndTime = this.EndTime,
RoomNo = this.RoomNo
};
return(dataObject);
}
public void UpdateTable() //Синхронизация таблиц в программе и бд, путем записи-перезаписи табл в бд
{
for (int i = 0; i < Days.Count; i++)
{
for (int j = 0; j < Days[i].Count; j++)
{
if (Days[i][j].teacher1 != null && Days[i][j].subject1 != null && !timetables.Contains(Days[i][j]))
{
if (timetables.Count > 0)
{
Days[i][j].idtimetable = timetables[timetables.Count - 1].idtimetable + 1;
}
else
{
Days[i][j].idtimetable = 1;
}
timetables.Add(Days[i][j]);
}
else if (Days[i][j].teacher1 == null && Days[i][j].subject1 == null && timetables.Contains(Days[i][j]))
{
timetables.AllowRemove = true;
timetables.Remove(Days[i][j]);
timetable tt = new timetable();
tt.Date = Days[i][j].Date;
tt.Day = Days[i][j].Day;
tt.Week = Days[i][j].Week;
tt.Group = Days[i][j].Group;
tt.Course = Days[i][j].Course;
tt.Time = Days[i][j].Time;
tt.times = Days[i][j].times;
Days[i][j] = tt;
}
// else if (Days[i][j].teacher1 == null && Days[i][j].subject1 == null && timetables.Contains(Days[i][j]))
// {
// timetables.Remove(Days[i][j]);
// }
}
}
DataBase.UpdateDB();
}
public void CreateDays()
{
string[] dateStr = GetWeekById(currentWeekId).dateFrom.Split('.');
DateTime date = new DateTime(Convert.ToInt32(dateStr[2]), Convert.ToInt32(dateStr[1]), Convert.ToInt32(dateStr[0]));
weekDate = new WeekDate(date);
// weekDate.CreateDate(date);
for (int i = 0; i < Days.Count; i++)
{
foreach (course f_course in courses)
{
foreach (group f_group in groups)
{
foreach (times f_Time in times)
{
string currentDate = date.AddDays(i).ToShortDateString();
int currentDateId = 0;
if (dates.Where(p => p.date == currentDate).Count() <= 0)
{
dates dt = new dates();
dt.date = date.AddDays(i).ToShortDateString();
if (dates.Count == 0)
{
dt.iddates = 0;
}
else
{
dt.iddates = dates.Last().iddates + 1;
}
dates.Add(dt);
currentDateId = dt.iddates;
DataBase.timetableDB.SaveChanges();
}
else
{
currentDateId = dates.Where(p => p.date == currentDate).Last().iddates;
}
timetable tt = CheckLesson(currentWeekTimetable.ToList <timetable>(), currentDateId, f_Time.idtimes, dbDays[i].idDay, f_course.idcourse, f_group.idgroup);
if (tt == null)
{
tt = new timetable();
tt.Date = dates.Where(p => p.date == date.AddDays(i).ToShortDateString()).Last().iddates;
tt.Day = dbDays[i].idDay;
tt.Week = currentWeekId;
tt.Group = f_group.idgroup;
tt.Course = f_course.idcourse;
tt.Time = f_Time.idtimes;
tt.times = f_Time;
}
Days[i].Add(tt);
}
}
}
}
}
public void addTimetable(timetable p)
{
ut.TimetableRepository.Add(p);
ut.commit();
}
public void deleteTimetable(timetable p)
{
ut.TimetableRepository.Delete(p);
ut.commit();
}
