public Stadisticts EventStadistics(int EventId)
{
using (CAPA_INVContext context = new CAPA_INVContext())
{
Stadisticts stats = new Stadisticts();
int TicketCounts = context.TicketCounts.Where(r => (r.Ticket.InventoryEventKey == EventId)).Count();
int MoTags = context.MOTagHeaders.Where(r => (r.Ticket.InventoryEventKey == EventId)).Count();
int VoidCleanBlanks = context.TicketCounts.Where(r => (r.Ticket.InventoryEventKey == EventId) && (r.VoidTag == true) && (r.CounterInitials == null)).Count();
stats.TicketCounts = TicketCounts;
stats.MOTags = MoTags;
stats.TicketBlank = context.TicketCounts.Where(r => (r.BlankTag == true) && (r.Ticket.InventoryEventKey == EventId)).Count();
stats.TicketVerified = context.TicketCounts.Where(r => (r.Verified == true) && (r.Ticket.InventoryEventKey == EventId)).Count();
stats.TicketVoid = context.TicketCounts.Where(r => (r.VoidTag == true) && (r.Ticket.InventoryEventKey == EventId)).Count();
int TicketCounted = context.TicketCounts.Where(r => (((r.CounterInitials != null)) && (r.Ticket.InventoryEventKey == EventId))).Count();
int MoTagCounted = context.MOTagHeaders.Where(r => (r.CounterInitials != null) && (r.Ticket.InventoryEventKey == EventId)).Count();
stats.MOTagsCounted = MoTagCounted;
stats.TicketCounted = TicketCounted + VoidCleanBlanks;
if (stats.TotalTickets > 0)
{
stats.TicketCountedPorcentage = (stats.TotalTicketsCounted * 100) / stats.TotalTickets;
}
//Where(r => (r.TicketKey == Ticket_Id && r.Ticket.cat_TicketTypeKey == 1)).ToList();
//return List;
return(stats);
}
}
private void LoadStadistics()
{
Stadisticts stats = x.LoadStadistics();
if (l_TicketCounts.Text != stats.TicketCounts.ToString())
{
l_TicketCounts.Text = stats.TicketCounts.ToString();
}
if (l_TicketCounted.Text != stats.TicketCounted.ToString())
{
l_TicketCounted.Text = stats.TicketCounted.ToString();
}
if (l_TicketBlanks.Text != stats.TicketBlank.ToString())
{
l_TicketBlanks.Text = stats.TicketBlank.ToString();
}
if (l_TicketVerified.Text != stats.TicketVerified.ToString())
{
l_TicketVerified.Text = stats.TicketVerified.ToString();
}
if (l_TicketVoid.Text != stats.TicketVoid.ToString())
{
l_TicketVoid.Text = stats.TicketVoid.ToString();
}
if (l_MOTags.Text != stats.MOTags.ToString())
{
l_MOTags.Text = stats.MOTags.ToString();
}
if (l_MOTagsCounted.Text != stats.MOTagsCounted.ToString())
{
l_MOTagsCounted.Text = stats.MOTagsCounted.ToString();
}
int Porcentage = stats.TicketCountedPorcentage;
if (pb_CountedTickets.Value != Porcentage || l_CountedTags.Text != stats.TicketCounted.ToString())
{
l_CountedTags.Text = stats.TicketCounted.ToString();
pb_CountedTickets.Value = Porcentage;
gb_CountedTikets.Text = "Inventory Event Progress " + Porcentage.ToString() + "% : " + stats.TotalTicketsCounted.ToString() + "/" + stats.TotalTickets.ToString();
}
}
