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); }
}
