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");
}
