//REGISTER STUDENT
public TransportoGrazinimas InsertTransGrazinimas(TransportoGrazinimas transportoGrazinimas)//provide transportas object when calling this function
{
try
{
bool nuomaYra = false;
//setting new SqlConnection, providing connectionString
cnn = new MySqlConnection(connectionString);
cnn.Open();//open database
//check if rezervacija exist
MySqlCommand cmd = new MySqlCommand("Select * from nuoma where Nuomos_nr=@Nuomos_nr", cnn);//to check if username exist we have to select all items with username
cmd.Parameters.AddWithValue("@Nuomos_nr", transportoGrazinimas.nuomos_Nr);
MySqlDataReader dataReader = cmd.ExecuteReader();//sends SQLCommand.CommandText to the SQLCommand.Connection and builds SqlDataReader
if ((dataReader.Read() == true))
{
nuomaYra = true;
}
else
{
return(null);
}
dataReader.Close();//close data reader when it finishes work
if (nuomaYra == true)
{
MySqlCommand cmd1 = new MySqlCommand("Insert into trans_grazinimas (Grazinimo_data,Grazinimo_laikas) VALUES(@Grazinimo_data,@Grazinimo_laikas)", cnn);
cmd1.Parameters.AddWithValue("@Grazinimo_data", transportoGrazinimas.grazinimo_Data);
cmd1.Parameters.AddWithValue("@Grazinimo_laikas", transportoGrazinimas.grazinimo_Laikas);
cmd1.ExecuteNonQuery();
}
cnn.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(transportoGrazinimas);//return
}
public void UpdateTransGrazinimas(TransportoGrazinimas transportoGrazinimas)
{
try
{
//setting new SqlConnection, providing connectionString
cnn = new MySqlConnection(connectionString);
cnn.Open();//open database
//check if user exist
MySqlCommand cmd = new MySqlCommand("Update trans_grazinimas SET Grazinimo_data=@Grazinimo_data, Grazinimo_laikas=@Grazinimo_laikas,Nuomos_nr=@Nuomos_nr WHERE Graz_nr=@Graz_nr", cnn);//to check if username exist we have to select all items with username
cmd.Parameters.AddWithValue("@Grazinimo_data", transportoGrazinimas.grazinimo_Data);
cmd.Parameters.AddWithValue("@Grazinimo_laikas", transportoGrazinimas.grazinimo_Laikas);
cmd.Parameters.AddWithValue("@Nuomos_nr", transportoGrazinimas.nuomos_Nr);
cmd.Parameters.AddWithValue("@Graz_nr", transportoGrazinimas.graz_Nr);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
