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