private static void UpdateFlightSearchBatch(DatabaseHandlerMain db, FlightSearchBatch f, SqlCommand command)
{
try
{
var searchConditionUpdateQuery = "Exec [Report].[usp_FlightSearchBatchUpdate] @BatchID ,@FROM, @TO";
searchConditionUpdateQuery += ",@SeachStayDuration, @SeachPeriodFrom ,@SeachPeriodTo ,@PreferredAirlineCode ,@TotalAdult";
searchConditionUpdateQuery += ",@TotalChild ,@TotalInfant ,@CabinClass ,@IsGetCorporateFare ,@IsActive";
command.CommandText = searchConditionUpdateQuery;
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("BatchID", f.BatchID));
command.Parameters.Add(new SqlParameter("FROM", f.FROM ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("TO", f.TO ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("SeachStayDuration", f.SeachStayDuration ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("SeachPeriodFrom", f.SeachPeriodFrom ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("SeachPeriodTo", f.SeachPeriodTo ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("PreferredAirlineCode", f.PreferredAirlineCode ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("TotalAdult", f.TotalAdult ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("TotalChild", f.TotalChild ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("TotalInfant", f.TotalInfant ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("CabinClass", f.CabinClass ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("IsGetCorporateFare", f.IsGetCorporateFare ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("IsActive", f.IsActive));
db.UpdateDataByStoredProcedure(command);
}
catch (Exception ex)
{
throw ex;
}
}
private static void InsertFlightSearchResult(DatabaseHandlerMain db, FlightSearchResult searchresult, SqlCommand command)
{
try
{
var searchResultInsertQuery = "Exec [Report].[usp_FlightSearchResultInsert] @BatchID,@OutboundDepartureDate,@InboundDepartureDate,@AirlineCode,@TotalPrice,@ResBookDesignCode";
command.CommandText = searchResultInsertQuery;
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("BatchID", searchresult.BatchID ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("OutboundDepartureDate", searchresult.OutboundDepartureDate ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("InboundDepartureDate", searchresult.InboundDepartureDate ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("AirlineCode", searchresult.AirlineCode ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("TotalPrice", searchresult.TotalPrice ?? (object)DBNull.Value));
command.Parameters.Add(new SqlParameter("ResBookDesignCode", searchresult.ResBookDesignCode ?? (object)DBNull.Value));
db.UpdateDataByStoredProcedure(command);
}
catch (Exception ex)
{
throw ex;
}
}