public static void AddTeacher(techer techer) { using (sqlEntities sqlEntities = new sqlEntities()) { sqlEntities.techer.Add(techer); sqlEntities.SaveChanges(); } }
public static void selectByClass(int clss) { using (sqlEntities sqlEntities = new sqlEntities()) { var listMain = sqlEntities.schedules.Where(x => x.@class == clss).ToList(); var listOrderTacher = listMain.OrderBy(x => x.day).ToList(); } }
public static void selectBySubject(int subject) { using (sqlEntities sqlEntities = new sqlEntities()) { var listMain = sqlEntities.schedules.Where(x => x.subjectIn == subject).ToList(); var listOrderTacher = listMain.OrderBy(x => x.techer).ToList(); } }
// var s = sqlEntities.Presence.Where(z => z.dateDay.Value.Month == month).ToList(); // var xx = sqlEntities.Presence.ToList(); //var listOrderStatus = listOrderTacher.OrderBy(x => x.statusN); //var listOrderday = listMain.OrderBy(x => x.day); //var listOrderdayMis_Hour = listMain.OrderBy(x => x.mis_Hour); public static void selectByMonth(int month) { using (sqlEntities sqlEntities = new sqlEntities()) { var listMain = sqlEntities.Presence.Where(x => x.dateDay.Value.Month == month).ToList(); var listOrderTacher = listMain.OrderBy(x => x.techer).ToList(); } }
public static void add(common.Schedule schedule) { using (sqlEntities sqlEntities = new sqlEntities()) { var a = Mapper.Casting(schedule); sqlEntities.schedules.Add(a); sqlEntities.SaveChanges(); } }
public static void Add(Presence presence) { using (sqlEntities sqlEntities = new sqlEntities()) { //presence.day = (int)presence.dateDay.Value.DayOfWeek; sqlEntities.Presence.Add(presence); sqlEntities.SaveChanges(); } }
public static List <schedule> selectByTacherWhereDayWorks(int dayOfWeek) { List <schedule> listMain; using (sqlEntities sqlEntities = new sqlEntities()) { listMain = sqlEntities.schedules.Where(x => x.day == dayOfWeek).ToList(); } return(listMain); }
public static List <dal.subjectToClass> GetSubject() { var subjects = new List <dal.subjectToClass>(); using (sqlEntities sqlEntities = new sqlEntities()) { subjects = sqlEntities.subjectToClass.ToList(); } return(subjects); }
public static void Add(Class1 t) { @class clss = Mapper.Casting(t); using (sqlEntities sqlEntities = new sqlEntities()) { [email protected](clss); sqlEntities.SaveChanges(); } }
public static void Add(common.subjectToClass subject) { subjectToClass subjectToClass = Mapper.Casting(subject); using (sqlEntities sqlEntities = new sqlEntities()) { sqlEntities.subjectToClass.Add(subjectToClass); sqlEntities.SaveChanges(); } }
public static List <schedule> get() { List <schedule> a; using (sqlEntities sql = new sqlEntities()) { a = sql.schedules.ToList(); } return(a); }
public static List <@class> get() { List <Class1> classes = new List <Class1>(); List <@class> a; using (sqlEntities sqlEntities = new sqlEntities()) { a = [email protected](); } return(a); }
public static void Update(common.Teacher t) { using (sqlEntities sqlEntities = new sqlEntities()) { var s = sqlEntities.techer.Where(z => z.codeTecher == t.CodeTeacher).First(); s.name = t.Name; s.permanent = t.Permanent; s.hour_teken_month = s.hour_teken_month; sqlEntities.SaveChanges(); } }
public static void Update(int id, int num_hour, bool teken) { using (sqlEntities sqlEntities = new sqlEntities()) { var s = sqlEntities.techer.Where(z => z.codeTecher == id).FirstOrDefault(); if (s != null) { s.hour_teken_month = num_hour; s.permanent = teken; } } }
public static void Update(common.subjectToClass subjectToClass) { using (sqlEntities sqlEntities = new sqlEntities()) { var s = sqlEntities.subjectToClass.Where(z => z.codeSubject == subjectToClass.CodeSubject).First(); // sqlEntities.subjectToClass. s.name = subjectToClass.Name; s.group1 = subjectToClass.Group1; s.group2 = subjectToClass.Group2; sqlEntities.SaveChanges(); } }
public static void Update(common.Class1 class1) { using (sqlEntities sqlEntities = new sqlEntities()) { var s = [email protected](z => z.codeClass == class1.CodeClass).First(); try { s.name = class1.Name; sqlEntities.SaveChanges(); } catch { } } }
public static void Update(int codeTachar, int code, int hour, DateTime date, int day, int statusToDay) { using (sqlEntities sqlEntities = new sqlEntities()) { var s = sqlEntities.Presence.Where(z => z.codeTecher == code && z.dateDay == date && z.mis_Hour == hour).First(); try { s.statusToDay = statusToDay; s.codeTecher = codeTachar; } catch (NullReferenceException) { } } }
public static void Remove(int id) { using (sqlEntities sqlEntities = new sqlEntities()) { var s = [email protected](z => z.codeClass == id).First(); try { var schedules = sqlEntities.schedules.Where(z => z.@class == id).ToList(); schedules.ForEach(s1 => s1.class1 = null); [email protected](s); sqlEntities.SaveChanges(); } catch { } } }
public static void remove(int code, int hour, DateTime date, int day) { using (sqlEntities sqlEntities = new sqlEntities()) { var s = sqlEntities.Presence.Where(z => z.codeTecher == code && z.dateDay == date && z.mis_Hour == hour).First(); try { sqlEntities.Presence.Remove(s); sqlEntities.SaveChanges(); } catch (NullReferenceException) { } } }
public static void Add(Teacher t) { techer techer = Mapper.Casting(t); using (sqlEntities sqlEntities = new sqlEntities()) { try { sqlEntities.techer.Add(techer); } catch (Exception e) { } //{("אין אפשרות להוסיף" + " אנא בדקי את הערכים שהכנסת"); } sqlEntities.SaveChanges(); } }
public static void Remove(int id) { using (sqlEntities sqlEntities = new sqlEntities()) { var s = sqlEntities.subjectToClass.Where(z => z.codeSubject == id).First(); try { var schedules = sqlEntities.schedules.Where(z => z.subjectIn == id).ToList(); schedules.ForEach(s1 => s1.subjectToClass = null); sqlEntities.subjectToClass.Remove(s); sqlEntities.SaveChanges(); } catch (NullReferenceException) { } } }
public static void remove(int id) { using (sqlEntities sqlEntities = new sqlEntities()) { var s = sqlEntities.techer.Where(z => z.codeTecher == id).FirstOrDefault(); if (s != null) { try { sqlEntities.techer.Remove(s); sqlEntities.SaveChanges(); } catch (NullReferenceException) { } } } }
public static void Rename(int id) { using (sqlEntities sqlEntities = new sqlEntities()) { var s = sqlEntities.techer.Where(z => z.codeTecher == id).First(); //var users = s.schedule.ToList(); //var presence = s.Presence.ToList(); //if (users != null) //{ // foreach (var user in users) // { // s.schedule.Remove(user); // } //} //if (presence != null) //{ // foreach (var p in presence) // { // s.Presence.Remove(p); // } //} if (s != null) { try { var schedules = sqlEntities.schedules.Where(z => z.techer == id).ToList(); var p = sqlEntities.Presence.Where(z => z.codeTecher == id).ToList(); schedules.ForEach(s1 => s1.techer1 = null); p.ForEach(p1 => p1.techer = null); sqlEntities.techer.Remove(s); sqlEntities.SaveChanges(); } catch (NullReferenceException) { } } } }
public static List <Teacher> GetTechers() { List <Teacher> teachers = new List <Teacher>(); IEnumerable <techer> a; try { using (sqlEntities sqlEntities = new sqlEntities()) { a = sqlEntities.techer.ToList(); foreach (var item in a) { var i = Mapper.Casting(item); teachers.Add(i); } } } catch (EntityDataSourceValidationException e) { e.InnerException.ToString(); } return(teachers); }
public static List <int> getInfoForResponce(techer t) { DateTime? dateTime; int numHouerForTeacherPresence = 0; int numHouerForTeacherSick = 0; int numToDaySick = 0; int numHouerForTeacherAbsent = 0; int numDayToDriver = 0; List <int> listReturn = new List <int>(); using (sqlEntities sqlEntities = new sqlEntities()) { try { var x = sqlEntities.Presence.ToList().Where(z => z.techer.codeTecher == t.codeTecher).ToList(); //לא נותן ברשימות נוכחות ריקות מה עושים? x.OrderBy(o => o.dateDay); try { dateTime = x.FirstOrDefault().dateDay; } catch (Exception) { dateTime = new DateTime(); } int d = 0; foreach (var item in x) { switch (item.statusToDay) { case (1): { //שעות עבודה +נסיעות numHouerForTeacherPresence++; if (dateTime != null && (dateTime < item.dateDay || d == 0)) { d = 1; dateTime = item.dateDay; numDayToDriver++; } break; } case (2): //שעות מחלה { numToDaySick++; numHouerForTeacherSick++; break; } case (3): { numHouerForTeacherPresence++; break; } case (4): //חסרה { numHouerForTeacherAbsent++; break; } } } } catch { } listReturn.Add(numHouerForTeacherPresence); listReturn.Add(numHouerForTeacherSick); // listReturn.Add(numHouerForTeacher3); // listReturn.Add(numHouerForTeacher4); listReturn.Add(numDayToDriver); return(listReturn); } }