private void deleteNusizengimai_Click(object sender, EventArgs e) { try { Nusizengimai gl = new Nusizengimai(); gl.nusizengimai_Id = int.Parse(deleteNusizengimaiNusizId.Text); nusizRep.DeleteNusiz(gl); deleteNusizengimaiNusizId.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Deleted succesfully"); getGalimiNusizengimaiDisplay(); getNusizengimaiDisplay(); }
private void addNusizengimai_Click(object sender, EventArgs e) { try { Nusizengimai nz = new Nusizengimai(); DateTime nusizData = DateTime.Parse(addNusizengimaiNusizData.Text); nz.nusizengimo_Data = nusizData.Date; nz.kliento_Nr = int.Parse(addNusizengimaiKlientoNr.Text); Nusizengimai inserted = nusizRep.InsertNusizengimai(nz); addNusizengimaiNusizData.Clear(); addNusizengimaiKlientoNr.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Succesfully inserted"); getNusizengimaiDisplay(); }
public void UpdateNusizengimai(Nusizengimai nusizengimai) { try { //setting new SqlConnection, providing connectionString cnn = new MySqlConnection(connectionString); //check if user exist MySqlCommand cmd = new MySqlCommand("Update nusizengimai SET NusizData=@NusizData, Kliento_nr=@Kliento_nr WHERE NusizengimaiId=@NusizengimaiId", cnn);//to check if username exist we have to select all items with username cmd.Parameters.AddWithValue("@NusizData", nusizengimai.nusizengimo_Data); cmd.Parameters.AddWithValue("@Kliento_nr", nusizengimai.kliento_Nr); cmd.Parameters.AddWithValue("@NusizengimaiId", nusizengimai.nusizengimai_Id); cnn.Open(); cmd.ExecuteNonQuery(); cnn.Close(); } catch (Exception ex) { Console.WriteLine(ex); } }
public void DeleteNusiz(Nusizengimai nusizengimai) { try { cnn = new MySqlConnection(connectionString); string newSql = (" Delete from galimi_nusiz where galimi_nusiz.NusizengimaiId=@id;"); newSql += ("Delete from nusizengimai where nusizengimai.NusizengimaiId=@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", nusizengimai.nusizengimai_Id); cmd.ExecuteNonQuery(); //execute function cnn.Close(); } catch (Exception exc) { Console.WriteLine(exc); } }
//REGISTER STUDENT public Nusizengimai InsertNusizengimai(Nusizengimai nusizengimai)//provide transportas object when calling this function { try { bool klientasYra = false; //setting new SqlConnection, providing connectionString cnn = new MySqlConnection(connectionString); cnn.Open();//open database //check if rezervacija exist MySqlCommand cmd = new MySqlCommand("Select * from klientas where Kliento_nr=@Kliento_nr", cnn);//to check if username exist we have to select all items with username cmd.Parameters.AddWithValue("@Kliento_nr", nusizengimai.kliento_Nr); MySqlDataReader dataReader = cmd.ExecuteReader();//sends SQLCommand.CommandText to the SQLCommand.Connection and builds SqlDataReader if ((dataReader.Read() == true)) { klientasYra = true; } else { return(null); } dataReader.Close();//close data reader when it finishes work if (klientasYra == true) { MySqlCommand cmd1 = new MySqlCommand("Insert into nusizengimai (NusizData,Kliento_nr) VALUES(@NusizData,@Kliento_nr)", cnn); cmd1.Parameters.AddWithValue("@NusizData", nusizengimai.nusizengimo_Data); cmd1.Parameters.AddWithValue("@Kliento_nr", nusizengimai.kliento_Nr); cmd1.ExecuteNonQuery(); } cnn.Close(); } catch (Exception exc) { Console.WriteLine(exc); } return(nusizengimai);//return }
private void updateNusizengimai_Click(object sender, EventArgs e) { try { Nusizengimai nz = new Nusizengimai(); DateTime nusizData = DateTime.Parse(updateNusizengimaiNusizData.Text); nz.nusizengimo_Data = nusizData.Date; nz.kliento_Nr = int.Parse(updateNusizengimaiKlientoNr.Text); nz.nusizengimai_Id = int.Parse(updateNusizengimaiNusizId.Text); nusizRep.UpdateNusizengimai(nz); updateNusizengimaiNusizData.Clear(); updateNusizengimaiKlientoNr.Clear(); updateNusizengimaiNusizId.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Succesfully updated"); }