// Reads the input files
// Fills the TABLES with DATA from the files
private void Fill_tables(MySqlConnection connection)
{
// Add data to RoomTable
Console.WriteLine("We now add records to RoomTable\n");
using (StreamReader SR = new StreamReader("Room.txt"))
{
String S = SR.ReadLine();
// Loop through the file reading lines
while (S != null)
{
String[] SArray = S.Split(','); // Room.txt contains tab-delimited fields.
int M = Convert.ToInt32(SArray[1]);
int Rm = Convert.ToInt32(SArray[0]);
String SqlString = "Insert Into RoomTable (Room, Capacity, Smart) Values(" +
"'" + Rm.ToString() + "', " + M.ToString() + ", '" + SArray[2] + "')";
//Console.WriteLine(SqlString);
// Run the command
MySqlCommand Command2 = new MySqlCommand(SqlString, connection);
Command2.ExecuteNonQuery();
S = SR.ReadLine();
} // end of while
} // end of using for StreamReader
// Add data to OfficeTable
Console.WriteLine("We now add records to OfficeTable\n");
using (StreamReader SR = new StreamReader("Office.txt"))
{
String S = SR.ReadLine();
// Loop through the file reading lines
while (S != null)
{
String[] SArray = S.Split(','); // Room.txt contains tab-delimited fields.
int M = Convert.ToInt32(SArray[1]);
String SqlString = "Insert Into OfficeTable (Teacher , Office) Values(" +
"'" + SArray[0] + "', " + M.ToString() + ")";
//Console.WriteLine(SqlString);
// Run the command
MySqlCommand Command2 = new MySqlCommand(SqlString, connection);
Command2.ExecuteNonQuery();
S = SR.ReadLine();
} // end of while
} // end of using for StreamReader
// Add data to ClassTable
Console.WriteLine("We now add records to ClassTable\n");
using (StreamReader SR = new StreamReader("Class.txt"))
{
// Ints to Convert strings to ints
int M0;
int M1;
int M3;
int M6;
String S = SR.ReadLine();
while (S != null)
{
// Show the string in the console
//Console.WriteLine(S);
// THIS WAS FOR THE ORIGINAL INPUT FILE FOR CLASSES
// If the line does not have Section 1 - ADD IT
//if ( (S.IndexOf('-')) == -1 )
//{
// S = S.Insert((S.IndexOf(',')), "-1");
//}
// This split was also for the original input, but still works
// Split the String and Commas AND Dashes
String[] SArray = S.Split(new Char[] { ',', '-' }, StringSplitOptions.RemoveEmptyEntries); // Room.txt contains tab-delimited fields.
// Convert some stings to ints
// Check if any of the INTS are passed in as NULL
{
if (SArray[0] != "null")
{
M0 = Convert.ToInt32(SArray[0]);
}
else
{
M0 = -1;
}
if (SArray[1] != "null")
{
M1 = Convert.ToInt32(SArray[1]);
}
else
{
M1 = -1;
}
if (SArray[3] != "null")
{
M3 = Convert.ToInt32(SArray[3]);
}
else
{
M3 = -1;
}
if (SArray[6] != "null")
{
M6 = Convert.ToInt32(SArray[6]);
}
else
{
M6 = -1;
}
}
// If the file has NULL for primary keys - it will display a message box
// Except for the "Section"... because the new input file has "section" as null
// despite the fact that it MUST be part of the primary key
// because there are classes with the same Number
// Create the command String
String SqlString = "Insert Into ClassTable (Class, Section, Teacher, Room, Time, Days, Enrollment) Values(" +
(M0 == -1 ? "NULL" : M0.ToString()) + ", " +
(M1 == -1 ? "1" : M1.ToString()) + ", " +
(SArray[2] == "null" ? "NULL" : "'" + SArray[2] + "'") + ", " +
(M3 == -1 ? "NULL" : M3.ToString()) + ", " +
(SArray[4] == "null" ? "NULL" : "'" + SArray[4] + "'") + ", " +
(SArray[5] == "null" ? "NULL" : "'" + SArray[5] + "'") + ", " +
(M6 == -1 ? "NULL" : M6.ToString()) + ")";
// Output the command to console
//Console.WriteLine(SqlString);
// Make the command and RUN IT
MySqlCommand Command2 = new MySqlCommand(SqlString, connection);
Command2.ExecuteNonQuery();
// Get a new Line
S = SR.ReadLine();
} // end of while
} // end of using for StreamReader
}
public void CalculatePerformance(double pressure, double temperature, double velocity, double commandedThrottle)
{
if (Tt7 == 0)
{
mainThrottle = commandedThrottle;
}
else
{
mainThrottle = Math.Min(commandedThrottle * 1.5, 1.0);
abThrottle = Math.Max(commandedThrottle - 0.667, 0);
}
p0 = pressure * 1000; //freestream
t0 = temperature;
gamma_c = CalculateGamma(t0, 0);
Cp_c = CalculateCp(t0, 0);
Cv_c = Cp_c / gamma_c;
R_c = Cv_c * (gamma_c - 1);
M0 = velocity / Math.Sqrt(gamma_c * R_c * t0);
T1 = t0 * (1 + 0.5 * (gamma_c - 1) * M0 * M0); //inlet
P1 = p0 * Math.Pow(T1 / t0, gamma_c / (gamma_c - 1)) * TPR;
double prat3 = CPR;
double prat2 = FPR;
double k = FPR / CPR;
double p = Math.Pow(k, (gamma_c - 1) / eta_c / gamma_c);
for (int i = 0; i < 20; i++) //use iteration to calculate CPR
{
P2 = prat2 * P1;
P3 = prat3 * P1;
T2 = T1 * Math.Pow(prat2, (gamma_c - 1) / gamma_c / eta_c); //fan
T3 = T1 * Math.Pow(prat3, (gamma_c - 1) / gamma_c / eta_c); //compressor
T4 = (Tt4 - T3) * mainThrottle + T3; //burner
P4 = P3;
ff = Cp_c * (T4 - T3) / (Cp_c * (T4 - T3) + h_f); //fuel fraction
Cp_t = CalculateCp(T4, ff);
T5 = T4 * TTR; //turbine
double x = prat3;
prat3 = (1 + ff) * Cp_t * (T4 - T5) / T1 / Cp_c + 1 + BPR;
prat3 /= 1 + BPR * p;
prat3 = Math.Pow(prat3, eta_c * gamma_c / (gamma_c - 1));
prat2 = k * prat3;
if (Math.Abs(x - prat3) < 0.01)
{
break;
}
}
gamma_t = CalculateGamma(T5, ff);//gas parameters
Cp_t = CalculateCp(T5, ff);
Cv_t = Cp_t / gamma_t;
R_t = Cv_t * (gamma_t - 1);
P5 = P4 * Math.Pow((1 - 1 / eta_t * (1 - TTR)), gamma_t / (gamma_t - 1));
if (exhaustMixer && BPR > 0) //exhaust mixer
{
double Cp6 = (Cp_c * BPR + Cp_t) / (1 + BPR); //Cp of mixed flow -- kind of
T6 = T5 * Cp_t / Cp6 * (1 + BPR * Cp_c * T2 / Cp_t / T5) / (1 + BPR);
P6 = (P5 + BPR * 0.98 * P2) / (1 + BPR);
ff /= (1 + ff + BPR);
gamma_t = CalculateGamma(T6, ff);//gas parameters
Cp_t = CalculateCp(T6, ff);
Cv_t = Cp_t / gamma_t;
R_t = Cv_t * (gamma_t - 1);
}
else
{
T6 = T5;
P6 = P5;
}
if (Tt7 > 0)
{
T7 = (Tt7 - T6) * abThrottle * 3 + T6;//afterburner
}
else
{
T7 = T6;
}
P7 = P6; //rayleigh loss?
ff_ab = ff + Cp_t * (T7 - T6) / (Cp_t * (T7 - T6) + h_f); //fuel fraction
gamma_ab = CalculateGamma(T7, ff_ab); //gas parameters
Cp_ab = CalculateCp(T7, ff_ab);
Cv_ab = Cp_ab / gamma_ab;
R_ab = Cv_ab * (gamma_ab - 1);
//Nozzle code is from NASA
double P8 = P7;
double T8 = T7;
double p8, V8, A8;
double epr = P8 / P1;
double etr = T8 / T1;
double area8max = .75 * Math.Sqrt(etr) / epr;//ratio of nozzle area to ref area
A8 = area8max * Aref;
if (exhaustMixer && BPR > 0)
{
A8 *= (1 + BPR);
}
double eair = P8 * Math.Sqrt(gamma_ab / R_ab / T8) *
Math.Pow((.5 + .5 * gamma_ab), .5 * (1 + gamma_ab) / (1 - gamma_ab));//corrected mass flow per area
mdot = eair * A8;
double npr = P8 / p0;
double fac1 = (gamma_ab - 1.0) / gamma_ab;
V8 = Math.Sqrt(2.0 * R_c / fac1 * T8 * eta_n * (1.0 - Math.Pow(1.0 / npr, fac1))); //exit velocity
p8 = (npr <= 1.893) ? p0 : .52828 * P8;
thrust = V8 * mdot + (p8 - p0) * A8;
if (BPR > 0 && FPR > 1 && exhaustMixer == false)
{
fac1 = (gamma_c - 1) / gamma_c; //fan thrust from NASA
double snpr = P2 / p0;
double ues = Math.Sqrt(2.0 * R_c / fac1 * T2 * eta_n * (1.0 - Math.Pow(1.0 / snpr, fac1)));
double pfexit = (snpr <= 1.893) ? p0 : .52828 * P2; //exit pressure of fan
thrust += BPR * ues * mdot / (1 + ff_ab) + (pfexit - p0) * BPR * Aref;
}
double netthrust = thrust - mdot / (1 + ff_ab) * (1 + (exhaustMixer ? 0 : BPR)) * (velocity);//ram drag
Isp = thrust / (mdot * ff_ab * 9.81);
debugstring = "";
debugstring += "TTR:\t" + TTR.ToString("F3") + "\r\n";
debugstring += "CPR:\t" + prat3.ToString("F3") + "\r\n";
debugstring += "M0:\t" + M0.ToString("F3") + "\r\n";
debugstring += "p0: " + p0.ToString("F2") + "\tt0: " + t0.ToString("F2") + "\r\n";
debugstring += "P1: " + P1.ToString("F2") + "\tT1: " + T1.ToString("F2") + "\r\n";
debugstring += "P2: " + P2.ToString("F2") + "\tT2: " + T2.ToString("F2") + "\r\n";
debugstring += "P3: " + P3.ToString("F2") + "\tT3: " + T3.ToString("F2") + "\r\n";
debugstring += "P4: " + P4.ToString("F2") + "\tT4: " + T4.ToString("F2") + "\r\n";
debugstring += "P5: " + P5.ToString("F2") + "\tT5: " + T5.ToString("F2") + "\r\n";
debugstring += "P6: " + P6.ToString("F2") + "\tT6: " + T6.ToString("F2") + "\r\n";
debugstring += "P7: " + P7.ToString("F2") + "\tT7: " + T7.ToString("F2") + "\r\n";
debugstring += "EPR: " + epr.ToString("F2") + "\tETR: " + etr.ToString("F2") + "\r\n";
debugstring += "FF: " + ff.ToString("P") + "\t";
debugstring += "FF_AB: " + ff_ab.ToString("P") + "\r\n";
debugstring += "V8: " + V8.ToString("F2") + "\tA8: " + A8.ToString("F2") + "\r\n";
debugstring += "Thrust: " + (thrust / 1000).ToString("F1") + "\tmdot: " + mdot.ToString("F2") + "\r\n";
debugstring += "NetThrust: " + (netthrust / 1000).ToString("F1") + "\tSFC: " + (3600 / Isp).ToString("F3") + "\r\n";
//Debug.Log(debugstring);
}
