//Method to Update data in Database from application
public bool Update(airlineInfoClass c)
{
//create a default return type and set its default value to false
bool isSuccess = false;
//create sql connection
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//Sql object to update data in database
string sql = "UPDATE passenger_info SET Name=@Name, Email=@Email, DepartureFrom=@DepartureFrom, DestinationTo=@DestinationTo, PhoneReserve=@PhoneReserve, PassengerNo=@PassengerNo, PassportNo=@PassportNo, LuggageNo=@LuggageNo, TicketClass=@TicketClass, TripType=@TripType WHERE ReservationID=@ReservationID";
//create sql command to insert data in this query
SqlCommand cmd = new SqlCommand(sql, conn);
//create Parameters to add value
cmd.Parameters.AddWithValue("@Name", c.Name);
cmd.Parameters.AddWithValue("@Email", c.Email);
cmd.Parameters.AddWithValue("@DepartureFrom", c.DepartureFrom);
cmd.Parameters.AddWithValue("@DestinationTo", c.DestinationTo);
cmd.Parameters.AddWithValue("@PhoneReserve", c.PhoneReserve);
cmd.Parameters.AddWithValue("@PassengerNo", c.PassengerNumber);
cmd.Parameters.AddWithValue("@PassportNo", c.PassportNo);
cmd.Parameters.AddWithValue("@LuggageNo", c.LuggageNo);
cmd.Parameters.AddWithValue("@TicketClass", c.TicketClass);
cmd.Parameters.AddWithValue("@TripType", c.TripType);
cmd.Parameters.AddWithValue("@ReservationID", c.ReservationID);
//open database connection
conn.Open();
//create integer value
int rows = cmd.ExecuteNonQuery();
//if query runs successfully, then value of rows > 0 else value of rows = 0
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
//Method for Inserting Data into database from application
public bool Insert(airlineInfoClass c)
{
//Create a default return type and setting value to false
bool isSuccess = false;
//1.Connect database
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//2. Create an SQL query to insert data
string sql = "INSERT INTO passenger_info (Name, Email, DepartureFrom, DestinationTo, PhoneReserve, PassengerNo, PassportNo, LuggageNo, TicketClass, TripType) VALUES (@Name, @Email, @DepartureFrom, @DestinationTo, @PhoneReserve, @PassengerNumber, @PassportNo, @LuggageNo, @TicketClass, @TripType)";
//Create SQL command using sql and conn
SqlCommand cmd = new SqlCommand(sql, conn);
//Create parameters to add data
cmd.Parameters.AddWithValue("@Name", c.Name);
cmd.Parameters.AddWithValue("@Email", c.Email);
cmd.Parameters.AddWithValue("@DepartureFrom", c.DepartureFrom);
cmd.Parameters.AddWithValue("@DestinationTo", c.DestinationTo);
cmd.Parameters.AddWithValue("@PhoneReserve", c.PhoneReserve);
cmd.Parameters.AddWithValue("@PassengerNumber", c.PassengerNumber);
cmd.Parameters.AddWithValue("@PassportNo", c.PassportNo);
cmd.Parameters.AddWithValue("@LuggageNo", c.LuggageNo);
cmd.Parameters.AddWithValue("@TicketClass", c.TicketClass);
cmd.Parameters.AddWithValue("@TripType", c.TripType);
//open connection
conn.Open();
int rows = cmd.ExecuteNonQuery();
//If query is successful, value of rows > zero else value will be zero
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
//method to delete data from Database
public bool Delete(airlineInfoClass c)
{
//create default return value and set value to false
bool isSuccess = false;
//create SQL Connection
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//Sql object to delete data
string sql = "DELETE FROM passenger_info WHERE ReservationID=@ReservationID";
//SQL command
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@ReservationID", c.ReservationID);
//open sql connection
conn.Open();
int rows = cmd.ExecuteNonQuery();
//if the query runs successfully, then value of rows > 0 else values = 0
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(isSuccess);
}