public void CalculateFinalResult()
{
FinalResult newResult = new FinalResult();
newResult.InterArrivalTime = interArrivalTiemInputed;
foreach (var finalResult in getAllFinalTableInfo())
{
newResult.ArrivalTime = finalResult.ArrivalTime + newResult.InterArrivalTime;
}
newResult.ServiceTime = serviceTimeInputed;
int previousServiceEndTiem = 0;
foreach (var finalResult in getAllFinalTableInfo())
{
previousServiceEndTiem = finalResult.ServiceEndTime;
}
if (previousServiceEndTiem <= newResult.ArrivalTime)
{
newResult.ServiceStartTime = newResult.ArrivalTime;
}
else
{
newResult.ServiceStartTime = previousServiceEndTiem;
}
newResult.ServiceEndTime = newResult.ServiceStartTime + newResult.ServiceTime;
int initialQueue = 0;
if (newResult.ServiceStartTime > newResult.ArrivalTime)
{
newResult.Queue = newResult.ServiceStartTime - newResult.ArrivalTime;
}
else
{
newResult.Queue = initialQueue;
}
newResult.TimeSpends = newResult.ServiceEndTime - newResult.ArrivalTime;
int initialIdleTime = 0;
if (previousServiceEndTiem < newResult.ArrivalTime)
{
newResult.IdleTime = newResult.ArrivalTime - previousServiceEndTiem;
}
else
{
newResult.IdleTime = initialIdleTime;
}
SaveFinalTableData(newResult);
}
public void SaveFinalTableData(FinalResult finalResult)
{
string query = "Insert into tbl_TotalSimulation values(" + arrivalRD + "," + finalResult.InterArrivalTime + "," + finalResult.ArrivalTime + "," + serviceRD + "," + finalResult.ServiceTime + "," + finalResult.ServiceStartTime + "," + finalResult.ServiceEndTime + "," + finalResult.Queue + "," + finalResult.TimeSpends + "," + finalResult.IdleTime + ")";
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = query;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}