/// <summary> /// получить список мусорок оператора /// </summary> /// <param name="id">id оператора</param> public List <trashObj> GetTrashOperator(int id) { using (var db = new Trash.db.Trash()) { var oper = db.t_operators.FirstOrDefault(x => x.id == id); if (oper == null) { return(new List <trashObj>()); } return(oper.t_oper_trash.Select(x => x.t_trash).Select(x => new trashObj() { id = x.id, res = x.t_status.Select(y => new Res() { id = y.id, ownerId = y.owner_id, tipId = y.tip_id, val = y.val_status }).ToList(), x = x.x, y = x.y }).ToList()); } }
/// <summary> /// получить список типов /// </summary> /// <returns></returns> public List <t_tip> GetTypes() { using (var db = new Trash.db.Trash()) { return(db.t_tip.ToList()); } }
public LiderTrash Lider(int id) { using (var db = new Trash.db.Trash()) { return(db.t_user_trash.Join( db.t_users, x => x.user_id, y => y.user_id, (x, y) => new { id = x.id, fio = y.fio, val = y.t_user_trash.Sum(z => (int)z.val_user) }) .Where(x => x.id == id) .Select(x => new LiderTrash() { fio = x.fio, val = x.val }) .FirstOrDefault()); } }
/// <summary> /// Получить список мусорок /// </summary> public List <trashObj> GetTrash() { using (var db = new Trash.db.Trash()){ return(db.t_trash.ToList().Select(x => new trashObj() { id = x.id, res = x.t_status.Select(y => new Res() { id = y.id, ownerId = y.owner_id, tipId = y.tip_id, val = y.val_status }).ToList(), x = x.x, y = x.y }).ToList()); } }
/// <summary> /// Получить список мусорок по фильтру /// </summary> /// <param name="fltr">список типов лопустимого мусора</param> public List <trashObj> GetTrashFilter(List <int> fltr) { using (var db = new Trash.db.Trash()) { var result = db.t_trash.ToList(); var r = result.Where(x => x.t_res.Any(y => fltr.Any(z => z == (int)y.tip_id))); return(r.Select(x => new trashObj() { id = x.id, res = x.t_status.Select(y => new Res() { id = y.id, ownerId = y.owner_id, tipId = y.tip_id, val = y.val_status }).ToList(), x = x.x, y = x.y }).ToList()); } }