private void deleteDraudTiek_Click(object sender, EventArgs e)
{
try
{
DraudimoTiekejai gl = new DraudimoTiekejai();
gl.tiekejo_Id = int.Parse(deleteDraudTiekTiekId.Text);
draudTiekRep.DeleteDraudTiek(gl);
deleteDraudTiekTiekId.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
MessageBox.Show("Deleted succesfully");
getDraudimasTiekDisplay();
getDraudimasDisplay();
}
public void UpdateDraudimoTiekejai(DraudimoTiekejai draudimoTiekejai)
{
try
{
//setting new SqlConnection, providing connectionString
cnn = new MySqlConnection(connectionString);
//check if user exist
MySqlCommand cmd = new MySqlCommand("Update draudimoTiekejai SET pavadinimas=@pavadinimas WHERE tiekId=@tiekId", cnn);//to check if username exist we have to select all items with username
cmd.Parameters.AddWithValue("@pavadinimas", draudimoTiekejai.pavadinimas);
cmd.Parameters.AddWithValue("@tiekId", draudimoTiekejai.tiekejo_Id);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
private void updateDraudTIek_Click(object sender, EventArgs e)
{
try
{
DraudimoTiekejai dt = new DraudimoTiekejai();
dt.pavadinimas = updateDraudTiekPav.Text;
dt.tiekejo_Id = int.Parse(updateTiekDraudTiekId.Text);
draudTiekRep.UpdateDraudimoTiekejai(dt);
updateDraudTiekPav.Clear();
updateTiekDraudTiekId.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
getDraudimasTiekDisplay();
MessageBox.Show("Succesfully updated");
}
public void DeleteDraudTiek(DraudimoTiekejai draudimoTiekejai)
{
try
{
cnn = new MySqlConnection(connectionString);
string newSql = ("Delete from draudimas where draudimas.tiekId=@id; ");
newSql += ("Delete from draudimoTiekejai where draudimoTiekejai.tiekId=@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", draudimoTiekejai.tiekejo_Id);
cmd.ExecuteNonQuery(); //execute function
cnn.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
}
private void addDraudTIek_Click(object sender, EventArgs e)
{
try
{
DraudimoTiekejai dt = new DraudimoTiekejai();
dt.pavadinimas = addDraudTiekPav.Text;
DraudimoTiekejai insertedDt = draudTiekRep.InsertDraudimoTiekejai(dt);
if (insertedDt.pavadinimas != null && insertedDt.pavadinimas != "")
{
MessageBox.Show("Succesfully inserted");
}
addDraudTiekPav.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
getDraudimasTiekDisplay();
}
//REGISTER STUDENT
public DraudimoTiekejai InsertDraudimoTiekejai(DraudimoTiekejai draudimoTiekejai)//provide transportas object when calling this function
{
try
{
//setting new SqlConnection, providing connectionString
cnn = new MySqlConnection(connectionString);
cnn.Open();//open database
//check if transportas exist
MySqlCommand cmd = new MySqlCommand("Select * from draudimoTiekejai where pavadinimas=@pavadinimas", cnn);
cmd.Parameters.AddWithValue("@pavadinimas", draudimoTiekejai.pavadinimas);
MySqlDataReader dataReader = cmd.ExecuteReader();//sends SQLCommand.CommandText to the SQLCommand.Connection and builds SqlDataReader
if ((dataReader.Read() == true))
{
Console.WriteLine("Tiekejo toks yra");
return(null);
}
else
{
Console.WriteLine("Tiekejo nera. Galima pridet");
}
dataReader.Close();//close data reader when it finishes work
MySqlCommand cmd2 = new MySqlCommand("Insert into draudimoTiekejai (pavadinimas) VALUES(@pavadinimas)", cnn);
cmd2.Parameters.AddWithValue("@pavadinimas", draudimoTiekejai.pavadinimas);
cmd2.ExecuteNonQuery();
cnn.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(draudimoTiekejai);//return
}
