private void deleteTransTest_Click(object sender, EventArgs e)
{
try
{
TransportoTestai gl = new TransportoTestai();
gl.test_Id = int.Parse(deleteTransTestTestId.Text);
transTestRep.DeleteTransTest(gl);
deleteTransTestTestId.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
MessageBox.Show("Deleted succesfully");
getTransTest();
getGalimiTestDisplay();
}
private void addTransTest_Click(object sender, EventArgs e)
{
try
{
TransportoTestai test = new TransportoTestai();
DateTime testoData = DateTime.Parse(addTransTestData.Text);
test.test_Data = testoData.Date;
test.trans_Id = int.Parse(addTransTestTransId.Text);
TransportoTestai insertedTest = transTestRep.InsertTransTest(test);
addTransTestData.Clear();
addTransTestTransId.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
MessageBox.Show("Succesfully inserted");
getTransTest();
}
//REGISTER STUDENT
public TransportoTestai InsertTransTest(TransportoTestai transTestai)//provide transportas object when calling this function
{
try
{
//setting new SqlConnection, providing connectionString
cnn = new MySqlConnection(connectionString);
cnn.Open();//open database
MySqlCommand cmd1 = new MySqlCommand("Insert into trans_test (Test_data,Trans_Id) VALUES(@Test_data,@Trans_Id)", cnn);
cmd1.Parameters.AddWithValue("@Test_data", transTestai.test_Data);
cmd1.Parameters.AddWithValue("@Trans_Id", transTestai.trans_Id);
cmd1.ExecuteNonQuery();
cnn.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(transTestai);//return
}
public void DeleteTransTest(TransportoTestai transTestai)
{
try
{
cnn = new MySqlConnection(connectionString);
string newSql = ("Delete from galimi_test where galimi_test.TestId=@id; ");
newSql += ("Delete from trans_test where trans_test.TestId=@id");
cnn.Open(); //open connection. we use the Open method of the cnn variable to open a connection to the database.
MySqlCommand cmd = new MySqlCommand(newSql, cnn); //select all from newTestTable
cmd.Parameters.AddWithValue("@id", transTestai.test_Id);
cmd.ExecuteNonQuery(); //execute function
cnn.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
}
public void UpdateTransTest(TransportoTestai transTestai)
{
try
{
//setting new SqlConnection, providing connectionString
cnn = new MySqlConnection(connectionString);
//check if user exist
MySqlCommand cmd = new MySqlCommand("Update trans_test SET Test_data=@Test_data, Trans_Id=@Trans_Id WHERE TestId=@TestId", cnn);//to check if username exist we have to select all items with username
cmd.Parameters.AddWithValue("@Test_data", transTestai.test_Data);
cmd.Parameters.AddWithValue("@Trans_Id", transTestai.trans_Id);
cmd.Parameters.AddWithValue("@TestId", transTestai.test_Id);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
private void updateButton_Click(object sender, EventArgs e)
{
try
{
TransportoTestai test = new TransportoTestai();
DateTime testoData = DateTime.Parse(updateTransTestData.Text);
test.test_Data = testoData.Date;
test.trans_Id = int.Parse(updateTransTestTransId.Text);
test.test_Id = int.Parse(updateTransTestTestId.Text);
transTestRep.UpdateTransTest(test);
updateTransTestData.Clear();
updateTransTestTransId.Clear();
updateTransTestTestId.Clear();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
MessageBox.Show("Succesfully updated");
getTransTest();
}
