//REGISTER STUDENT
public TransportoMarke InsertMarke(TransportoMarke marke)//provide transportas object when calling this function
{
try
{
//setting new SqlConnection, providing connectionString
cnn = new MySqlConnection(connectionString);
cnn.Open();//open database
//check if user exist
MySqlCommand cmd = new MySqlCommand("Select * from tmarke where Markes_pav=@Markes_pav", cnn);//to check if username exist we have to select all items with username
cmd.Parameters.AddWithValue("@Markes_pav", marke.markes_Pav);
MySqlDataReader dataReader = cmd.ExecuteReader();
if ((dataReader.Read() == true))
{
Console.WriteLine("Transport with that Marke already exists");
return(null);
}
else
{
Console.WriteLine("Transport Marke is free so you can register");
}
dataReader.Close();//close data reader when it finishes work
MySqlCommand cmd1 = new MySqlCommand("Insert into tmarke (Markes_pav) VALUES(@Markes_pav)", cnn);
cmd1.Parameters.AddWithValue("@Markes_pav", marke.markes_Pav);
cmd1.ExecuteNonQuery();
cnn.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(marke);//return
}
private void updateMarke_Click(object sender, EventArgs e)
{
try
{
TransportoMarke tm = new TransportoMarke();
tm.markes_Id = int.Parse(updateMarkesId.Text);
tm.markes_Pav = updateMarkesPav.Text;
markesRepository.UpdateMarke(tm);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
getMarkeDisplay();
}
private void DeleteMarke_Click(object sender, EventArgs e)
{
try
{
TransportoMarke gl = new TransportoMarke();
gl.markes_Id = int.Parse(DeleteMarkeMarkesId.Text);
markesRepository.DeleteMarke(gl);
DeleteMarkeMarkesId.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
MessageBox.Show("Deleted succesfully");
getMarkeDisplay();
}
public void UpdateMarke(TransportoMarke marke)
{
try
{
//setting new SqlConnection, providing connectionString
cnn = new MySqlConnection(connectionString);
//check if user exist
MySqlCommand cmd = new MySqlCommand("Update tmarke SET Markes_pav=@Markes_pav WHERE MarkesId=@MarkesId", cnn);//to check if username exist we have to select all items with username
cmd.Parameters.AddWithValue("@Markes_pav", marke.markes_Pav);
cmd.Parameters.AddWithValue("@MarkesId", marke.markes_Id);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public void DeleteMarke(TransportoMarke marke)
{
try
{
cnn = new MySqlConnection(connectionString);
string newSql = "DELETE FROM tmarke WHERE tmarke.MarkesId=@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", marke.markes_Id);
cmd.ExecuteNonQuery(); //execute function
cnn.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
}
private void addMarke_Click(object sender, EventArgs e)
{
try
{
TransportoMarke tm = new TransportoMarke();
tm.markes_Pav = addMarkesPav.Text;
TransportoMarke insertedMarke = markesRepository.InsertMarke(tm);
if (insertedMarke.markes_Pav != null && insertedMarke.markes_Pav != "")
{
MessageBox.Show("Marke succesfully inserted");
}
else
{
MessageBox.Show("Something went wrong");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
getMarkeDisplay();
}
