public static bool insertTransit(Model.Transit transit)
{
cnn = new MySqlConnection(connectionString);
try
{
cnn.Open();
Console.WriteLine("updateTransStatus Connection Open ! ");
MySqlCommand cmd = cnn.CreateCommand();
cmd.CommandText = "INSERT INTO `transit_system`.`transit` (`StudentName`, `parent_id`, `Package`, `TransitTime`) VALUES ('"+transit.StudentName+"', '"+transit.ParentId+"', '"+transit.Package+"', '"+transit.TransitTime+"');";
cmd.ExecuteNonQuery();
Console.WriteLine("updateTransStatus Complete ! ");
}
catch (Exception ex)
{
Console.WriteLine("Can not open connection ! ");
Console.WriteLine(ex.Message); //shows what error actually occurs
}
finally
{
cnn.Close();
Console.WriteLine("updateTransStatus Connection Closed ! ");
}
return false;
}
// add new transit based on input
private void addTransit()
{
String package;
String parentId = Sqlutil.UserSql.getUserId(Login.userEmailGlobal);
String studentName = textBox1.Text;
String transitTime = dateTimePicker1.Text;
if (radioButton1.Checked)
{
package = radioButton1.Text;
}
else if (radioButton2.Checked)
{
package = radioButton2.Text;
}
else if (radioButton3.Checked)
{
package = radioButton3.Text;
}
else if (radioButton4.Checked)
{
package = radioButton4.Text;
}
else if (radioButton5.Checked)
{
package = radioButton5.Text;
}
else
{
package = radioButton6.Text;
}
Model.Transit transit = new Model.Transit();
transit.StudentName = studentName;
transit.Package = package;
transit.ParentId = parentId;
transit.TransitTime = transitTime;
Sqlutil.TransitSql.insertTransit(transit);
}
