//---------------------------------------------------------------------
private void cbBarber_SelectedIndexChanged(object sender, EventArgs e)
{
Barber sBarber = cbBarber.SelectedItem as Barber;
using (BarberContextFeedback db = new((Owner as Form1).Connection.ConnectionString))
{
var fbQ = from f in db.Feedback
join j in db.Journal on f.VisitId equals j.Id
join c in db.Clients on j.ClientId equals c.Id
join b in db.Barbers on j.BarberId equals b.Id
where j.BarberId == sBarber.Id
select new { f, c };
lAvgRating.Text = ((double)fbQ.Sum(fbq => fbq.f.Rating) / fbQ.Count()).ToString();
lbFeedback.Items.Clear();
foreach (var a in fbQ)
{
StringBuilder sb = new();
sb.Append(("[" + a.f.Rating + "]").PadRight(5));
sb.Append(a.f.Moment.ToString().PadRight(20));
sb.Append(("(" + a.f.Text + ")").PadRight(20));
sb.Append(a.c.ToString());
lbFeedback.Items.Add(sb.ToString());
}
}
}
public Client(Barber barber)
{
Barber = barber;
}
