private void GetUsers(Package package) { List <User> users = new List <User>(); using (DBContext context = new DBContext()) { users = context.Users.ToList(); package.Data = User.ToJsonList(users); string json = package.ToJson(); byte[] data = Encoding.Unicode.GetBytes(json); TcpClient.GetStream().Write(data, 0, data.Length); } }
private void GetTeams(Package package) { List <Team> teams = new List <Team>(); byte[] data; using (DBContext context = new DBContext()) { teams = context.Teams.Include(t => t.employees).ToList(); package.Data = Team.ToJsonList(teams); string json = package.ToJson(); data = Encoding.Unicode.GetBytes(json); TcpClient.GetStream().Write(data, 0, data.Length); } }
private void GetUserInfo(Package package) { string[] args = package.Data.Split('@'); List <Log> logs = new List <Log>(); using (DBContext context = new DBContext()) { int id_emp = int.Parse(args[0]); DateTime startDate = DateTime.Parse(args[1]); DateTime endDate = DateTime.Parse(args[2]); logs = context.Logs.Where(l => l.id_employee == id_emp && l.datetime >= startDate && l.datetime <= endDate).ToList(); package.Data = Log.ToJsonList(logs); string json = package.ToJson(); byte[] data = Encoding.Unicode.GetBytes(json); TcpClient.GetStream().Write(data, 0, data.Length); } }
private void GetLogsTeam(Package package) { List <Log> logs = new List <Log>(); byte[] data; int id = int.Parse(package.Data.Split('@')[0]); DateTime start = DateTime.Parse(package.Data.Split('@')[1]); DateTime end = DateTime.Parse(package.Data.Split('@')[2]).AddDays(0); using (DBContext context = new DBContext()) { logs = context.Logs.Include(t => t.employee.team).Where(l => l.employee.team.id_teams == id && l.datetime > start && l.datetime < end ).ToList(); package.Data = Log.ToJsonList(logs); string json = package.ToJson(); data = Encoding.Unicode.GetBytes(json); TcpClient.GetStream().Write(data, 0, data.Length); } }