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 }