public static EmployeeTypesCM GetEmployeeTypeContentManager()
{
var e = new EmployeeTypesCM();
e.EmployeeTypes.Add(new Models.EmployeeType("Susanne", level: Models.SupportLevel.Level1st, hourlyWage: 100000, successRate: 1, durationFactor: 1));
e.EmployeeTypes.Add(new Models.EmployeeType("Peter", level: Models.SupportLevel.Level2nd, hourlyWage: 100000, successRate: 1, durationFactor: 1));
return(e);
}
public int Run()
{
init();
if (UseDatabase)
{
ConnectDb();
}
else if (TruncateFirst || DropAndCreateFirst || ClearTablesForMarker)
{
Print("You cannot do any data operations without --usedb");
return(1);
}
EmployeeTypesCM employeeTypesCM = new EmployeeTypesCM();
employeeTypesCM.Load(EmployeeTypesFilename);
WorkshiftsCM workshifts = new WorkshiftsCM(employeeTypesCM);
workshifts.Load(WorkshiftsFilename);
TicketGenerationPlan ticketGenerationPlan = new TicketGenerationPlan();
ticketGenerationPlan.Load(TicketGenerationPlan);
Print("All files loaded");
Print(string.Format("Total tickets: {0}", ticketGenerationPlan.TotalTickets));
if (Days == null)
{
Days = ticketGenerationPlan.NumberOfDays;
Print("Found {0} days in ticket plan", Days);
}
int run = 0;
if (UseDatabase)
{
if (DropAndCreateFirst)
{
DropTables(true);
CreateTables();
}
if (TruncateFirst)
{
TruncateTables();
}
if (ClearTablesForMarker)
{
Print("Deleted old datapoints (if exists) ({0})", DeleteDatapointsForMarker(Name));
Print("Deleted old summary (if exists) ({0})", DeleteSummariesForMarker(Name));
}
var getRunNumberCmd = new MySqlCommand(string.Format("select ifnull(max(run),0) as max from datapoints where marker=@Marker", Statics.TableSummaries), conn);
getRunNumberCmd.Parameters.Add("@Marker", MySqlDbType.VarChar).Value = Name;
using (var getRunNumberCmdReader = getRunNumberCmd.ExecuteReader())
{
getRunNumberCmdReader.Read();
run = getRunNumberCmdReader.GetInt32("max") + 1;
}
Print("Run number {0}", run);
}
SimulationManager sm = new SimulationManager(Name, run, workshifts, ticketGenerationPlan, Days.Value);
if (UseDatabase)
{
sm.NewDatapoint += Sm_NewDatapoint;
}
if (Debug)
{
sm.LogEvent += Print;
}
sm.Run();
if (UseDatabase)
{
Print("Inserting {0} datapoints into db if connected", datapoints.Count);
int inserts = 0;
if (datapoints.Count > 0)
{
inserts += InternalMySqlHelper.GetBulkInsert(conn, "datapoints", datapoints.ToArray()).ExecuteNonQuery();
}
Print("Inserts: {0}", inserts);
}
List <TicketEntity> tickets = ticketGenerationPlan.Tickets;
SimulationSummary ss = new SimulationSummary(
Name,
run,
tickets.Where(t => t.Solved).Count(),
tickets.Where(t => t.Deployed).Count(),
tickets.Where(t => t.Started).Count(),
tickets.Count(),
tickets.Where(t => !t.Solved && t.Difficulty == Models.SupportLevel.Level1st).Count(),
tickets.Where(t => !t.Solved && t.Difficulty == Models.SupportLevel.Level2nd).Count(),
tickets.Where(t => t.Solved).Any() ? tickets.Where(t => t.Solved).Average(i => i.Duration) : 0,
sm.Accounting.TotalExpenses,
sm.Accounting.TotalWorkingHours,
sm.Accounting.TotalWorkingHours != 0? sm.Accounting.TotalExpenses / sm.Accounting.TotalWorkingHours : 0,
tickets.Where(t => !t.Solved).Count()
);
if (UseDatabase)
{
var summaryInsert = InternalMySqlHelper.GetInsert(conn, TablePrefix + Statics.TableSummaries, ss);
Print("Insert summary ({0})", summaryInsert.ExecuteNonQuery());
}
Print("Solved tickets: {0}/{1}", ss.SolvedTickets, ss.TotalTickets);
Print("Deployed tickets: {0} ", ss.DeployedTickets);
Print("Started tickets: {0} ", ss.StartedTickets);
Print("Open 1st level tickets: {0} ", ss.Open1stLevelTickets);
Print("Open 2nd level tickets: {0} ", ss.Open2ndLevelTickets);
Print("Average Duration: {0} ", ss.AverageTicketSolveDuration);
Print("Total Costs: {0:C} ", ss.TotalCosts);
Print("Total Costs: {0:#,##0} h ", ss.TotalCosts);
Print("Average hourly wage: {0:C}", ss.AverageHourlyWage);
return(0);
}
