private static int GetBreakHourFromClass(DateTime dt, string className) { // if(DayOfWeek.Monday) using (var context = new sqlprobeEntities6()) { List <Class> classes = context.Class.ToList(); // if (dt.DayOfWeek == DayOfWeek.Monday) // return classes.Where(n => n.ClassName == className).Select(n => n.BreakMon).First(); } return(0); }
static void Main(string[] args) { var csv = new StringBuilder(); csv.Append("sep=;\ntemp;hum;co2;vol;volpp;bright;brightClass;dust;time;group;deviceId;room;seatsBehind;class;countPersons;teacher1;teacher2;isSupp;\n"); using (var context = new sqlprobeEntities6()) { //csv.Append(context.Nachricht.First().Temperatur,context.Nachricht) List <Message> nachrichten = context.Message.ToList(); List <Room> rooms = context.Room.ToList(); List <RoomSubject> roomSubjects = context.RoomSubject.ToList(); List <Class> classes = context.Class.ToList(); //nachrichten.Where(n=>n.deviceID==) foreach (var item in nachrichten) { string className = ""; string roomNR = item.Device.Room_Device.Where(n => item.timesent > n.ValidFrom && item.timesent < n.ValidUntil).Select(n => n.Room.RoomNr).First(); string roomID = rooms.Where(n => n.RoomNr == roomNR).Select(n => n.Room_ID).First().ToString(); int hour = GetHourFromMessage(item.timesent); if (hour != 0 && roomSubjects.Where(n => n.Hour == hour && n.fk_RoomID.ToString() == roomID).Count() != 0) { if (!roomSubjects.Where(n => n.fk_RoomID.ToString() == roomID).Select(n => n.isFree).First() && !roomSubjects.Where(n => n.fk_RoomID.ToString() == roomID).Select(n => n.isBreak).First()) { className = roomSubjects.Where(n => n.Hour == hour && n.fk_RoomID.ToString() == roomID).Select(n => n.Class.ClassName).First(); } int breakHour = GetBreakHourFromClass(item.timesent, className); } else { className = "empty"; } // temp hum co2 vol volpp bright bC dust time devID room seatsb class csv.Append(String.Concat(item.temp, ";", item.humidity, ";", item.co2, ";", item.noise, ";", '0', ";", item.ldr, ";", '0', ";", item.dust, ";", item.timesent.ToString(), ";", '1', ";", item.deviceID, ";", roomNR, ";", '0', ";", className, ";", '0', ";", '0', ";", '0', ";", '0', ";", "\n")); } } using (StreamWriter writer = new StreamWriter(Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + "\\erg.csv")) { writer.WriteLine(csv); } }