private void DeletePakrovimas_Click(object sender, EventArgs e)
{
try
{
Pakrovimas gl = new Pakrovimas();
gl.pakrovimo_Nr = int.Parse(DeletePakrovimasPakrovNr.Text);
pakrovimasRep.DeletePakrovimas(gl);
DeletePakrovimasPakrovNr.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
MessageBox.Show("Deleted succesfully");
getPakrovimasDisplay();
}
private void addPakrovimas_Click(object sender, EventArgs e)
{
try
{
Pakrovimas pakrovimas = new Pakrovimas();
pakrovimas.pakrovimo_Dydis = int.Parse(addPakrovimasPakrovDydis.Text);
pakrovimas.transporto_Id = int.Parse(addPakrovimasTransId.Text);
Pakrovimas insertedPakrovimas = pakrovimasRep.InsertPakrovimas(pakrovimas);
addPakrovimasPakrovDydis.Clear();
addPakrovimasTransId.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
getPakrovimasDisplay();
MessageBox.Show("Succesfully inserted");
}
public void DeletePakrovimas(Pakrovimas pakrovimas)
{
try
{
cnn = new MySqlConnection(connectionString);
string newSql = ("Delete from pakrovimas where pakrovimas.pakrovimoNr=@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", pakrovimas.pakrovimo_Nr);
cmd.ExecuteNonQuery(); //execute function
cnn.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
}
public void UpdatePakrovimas(Pakrovimas pakrovimas)
{
try
{
//setting new SqlConnection, providing connectionString
cnn = new MySqlConnection(connectionString);
//check if user exist
MySqlCommand cmd = new MySqlCommand("Update pakrovimas SET PakrovimoDydis=@PakrovimoDydis, Trans_Id=@Trans_Id WHERE pakrovimoNr=@pakrovimoNr", cnn);//to check if username exist we have to select all items with username
cmd.Parameters.AddWithValue("@PakrovimoDydis", pakrovimas.pakrovimo_Dydis);
cmd.Parameters.AddWithValue("@Trans_Id", pakrovimas.transporto_Id);
cmd.Parameters.AddWithValue("@pakrovimoNr", pakrovimas.pakrovimo_Nr);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
private void updatePakrovimas_Click(object sender, EventArgs e)
{
try
{
Pakrovimas pakrovimas = new Pakrovimas();
pakrovimas.pakrovimo_Dydis = int.Parse(updatePakrovimasPakrovDyd.Text);
pakrovimas.transporto_Id = int.Parse(updatePakrovimasTransId.Text);
pakrovimas.pakrovimo_Nr = int.Parse(updatePakrovimasPakrId.Text);
pakrovimasRep.UpdatePakrovimas(pakrovimas);
updatePakrovimasPakrovDyd.Clear();
updatePakrovimasTransId.Clear();
updatePakrovimasPakrId.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
getPakrovimasDisplay();
MessageBox.Show("Succesfully updated");
}
//REGISTER STUDENT
public Pakrovimas InsertPakrovimas(Pakrovimas pakrovimas)//provide transportas object when calling this function
{
try
{
Console.WriteLine("TransId: " + pakrovimas.transporto_Id + " PakrovDydis: " + pakrovimas.pakrovimo_Dydis);
//setting new SqlConnection, providing connectionString
cnn = new MySqlConnection(connectionString);
MySqlCommand cmd = new MySqlCommand("Insert into pakrovimas(PakrovimoDydis,Trans_Id) VALUES(@PakrovimoDydis,@Trans_Id)", cnn);
cmd.Parameters.AddWithValue("@PakrovimoDydis", pakrovimas.pakrovimo_Dydis);
cmd.Parameters.AddWithValue("@Trans_Id", pakrovimas.transporto_Id);
cnn.Open();//open database
cmd.ExecuteNonQuery();
cnn.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(pakrovimas);//return
}
