public static void AddTeacher(techer techer)
{
using (sqlEntities sqlEntities = new sqlEntities())
{
sqlEntities.techer.Add(techer);
sqlEntities.SaveChanges();
}
}
public static techer Casting(Teacher t)
{
techer techer = new techer
{
codeTecher = t.CodeTeacher,
hour_teken_month = t.Hour_teken_month,
name = t.Name,
permanent = t.Permanent,
};
return(techer);
}
public static Teacher Casting(techer t)
{
Teacher techer = new Teacher
{
CodeTeacher = t.codeTecher,
Hour_teken_month = t.hour_teken_month,
Name = t.name,
Permanent = t.permanent
};
return(techer);
}
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 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); }
}