public List <BookingCentraliseEmailMonitor> GetConfirmationNoFormats()
{
List <BookingCentraliseEmailMonitor> objBookingCentraliseEmailMonitors = new List <BookingCentraliseEmailMonitor>();
string sqlStr = @"booking_centralise_email_get";
SqlCommand cmd = new SqlCommand(sqlStr, _Context);
cmd.CommandType = CommandType.StoredProcedure;
try
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
BookingCentraliseEmailMonitor objBookingCentraliseEmailMonitor = new BookingCentraliseEmailMonitor();
if (reader["booking_centralise_email_monitor_id"] != DBNull.Value)
{
objBookingCentraliseEmailMonitor.booking_centralise_email_monitor_id = Convert.ToInt32(reader["booking_centralise_email_monitor_id"]);
}
if (reader["confirmation_no"] != DBNull.Value && reader["confirmation_no"].ToString().Trim() != "")
{
objBookingCentraliseEmailMonitor.confirmation_no = reader["confirmation_no"].ToString().Trim();
}
if (reader["company"] != DBNull.Value && reader["company"].ToString().Trim() != "")
{
objBookingCentraliseEmailMonitor.company = reader["company"].ToString().Trim();
}
if (reader["email_type"] != DBNull.Value && reader["email_type"].ToString().Trim() != "")
{
objBookingCentraliseEmailMonitor.email_type = reader["email_type"].ToString().Trim();
}
if (reader["acct_send_flag"] != DBNull.Value && reader["acct_send_flag"].ToString().Trim() != "")
{
objBookingCentraliseEmailMonitor.acct_send_flag = reader["acct_send_flag"].ToString().Trim();
}
if (reader["email_format"] != DBNull.Value && reader["email_format"].ToString().Trim() != "")
{
objBookingCentraliseEmailMonitor.email_format = reader["email_format"].ToString().Trim();
}
if (reader["vip_send_flag"] != DBNull.Value && reader["vip_send_flag"].ToString().Trim() != "")
{
objBookingCentraliseEmailMonitor.vip_send_flag = reader["vip_send_flag"].ToString().Trim();
}
if (reader["acct_admin_send_flag"] != DBNull.Value && reader["acct_admin_send_flag"].ToString().Trim() != "")
{
objBookingCentraliseEmailMonitor.acct_admin_send_flag = reader["acct_admin_send_flag"].ToString().Trim();
}
objBookingCentraliseEmailMonitors.Add(objBookingCentraliseEmailMonitor);
}
}
}
catch (Exception ex)
{
//UpdateProcessingStatus(objBookingCentraliseEmailMonitor.confirmation_no, objBookingCentraliseEmailMonitor.booking_centralise_email_monitor_id, "Application Error");
}
return(objBookingCentraliseEmailMonitors);
}
public OrderDeatils GetEmailOrderDetails(BookingCentraliseEmailMonitor objBookingCentraliseEmailMonitor, string email_type)
{
OrderDeatils objOrderDetails = new OrderDeatils();
string sqlStr = @"booking_centralise_email_orderdetail_get";
SqlCommand cmd = new SqlCommand(sqlStr, _Context);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@conf", objBookingCentraliseEmailMonitor.confirmation_no);
cmd.Parameters.AddWithValue("@email_type", email_type);
try
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader["confirmation_no"] != DBNull.Value && reader["confirmation_no"].ToString().Trim() != "")
{
objOrderDetails.confirmation_no = reader["confirmation_no"].ToString().Trim();
}
if (reader["acct_ID"] != DBNull.Value && reader["acct_ID"].ToString().Trim() != "")
{
objOrderDetails.acct_ID = reader["acct_ID"].ToString().Trim();
}
if (reader["passenger_name"] != DBNull.Value && reader["passenger_name"].ToString().Trim() != "")
{
objOrderDetails.passenger = reader["passenger_name"].ToString().Trim();
}
if (reader["company_name"] != DBNull.Value && reader["company_name"].ToString().Trim() != "")
{
objOrderDetails.company_name = reader["company_name"].ToString().Trim();
}
if (reader["company_address_1"] != DBNull.Value && reader["company_address_1"].ToString().Trim() != "")
{
objOrderDetails.company_address_1 = reader["company_address_1"].ToString().Trim();
}
if (reader["company_address_2"] != DBNull.Value && reader["company_address_2"].ToString().Trim() != "")
{
objOrderDetails.company_address_2 = reader["company_address_2"].ToString().Trim();
}
if (reader["company_phone"] != DBNull.Value && reader["company_phone"].ToString().Trim() != "")
{
objOrderDetails.company_phone = reader["company_phone"].ToString().Trim();
}
if (reader["acct_address_3"] != DBNull.Value && reader["acct_address_3"].ToString().Trim() != "")
{
objOrderDetails.acct_address_3 = reader["acct_address_3"].ToString().Trim();
}
if (reader["trip_date_time"] != DBNull.Value)
{
objOrderDetails.trip_date_time = Convert.ToDateTime(reader["trip_date_time"]);
}
if (reader["AgentID"] != DBNull.Value && reader["AgentID"].ToString().Trim() != "")
{
objOrderDetails.agent_id = reader["AgentID"].ToString().Trim();
}
if (reader["car_type"] != DBNull.Value && reader["car_type"].ToString().Trim() != "")
{
objOrderDetails.car_type = reader["car_type"].ToString().Trim();
}
if (reader["field_14"] != DBNull.Value && reader["field_14"].ToString().Trim() != "")
{
objOrderDetails.no_passenger = reader["field_14"].ToString().Trim();
}
if (reader["field_11"] != DBNull.Value && reader["field_11"].ToString().Trim() != "")
{
objOrderDetails.reservation_type = reader["field_11"].ToString().Trim();
}
if (reader["pu_address"] != DBNull.Value && reader["pu_address"].ToString().Trim() != "")
{
objOrderDetails.pu_address = reader["pu_address"].ToString().Trim();
}
if (reader["dest_address"] != DBNull.Value && reader["dest_address"].ToString().Trim() != "")
{
objOrderDetails.dest_address = reader["dest_address"].ToString().Trim();
}
if (reader["stop_address_1"] != DBNull.Value && reader["stop_address_1"].ToString().Trim() != "")
{
objOrderDetails.stop_address_1 = reader["stop_address_1"].ToString().Trim();
}
if (reader["stop_address_2"] != DBNull.Value && reader["stop_address_2"].ToString().Trim() != "")
{
objOrderDetails.stop_address_2 = reader["stop_address_2"].ToString().Trim();
}
if (reader["stop_address_3"] != DBNull.Value && reader["stop_address_3"].ToString().Trim() != "")
{
objOrderDetails.stop_address_3 = reader["stop_address_3"].ToString().Trim();
}
if (reader["stop_address_4"] != DBNull.Value && reader["stop_address_4"].ToString().Trim() != "")
{
objOrderDetails.stop_address_4 = reader["stop_address_4"].ToString().Trim();
}
if (reader["stop_address_5"] != DBNull.Value && reader["stop_address_5"].ToString().Trim() != "")
{
objOrderDetails.stop_address_5 = reader["stop_address_5"].ToString().Trim();
}
if (reader["stop_address_6"] != DBNull.Value && reader["stop_address_6"].ToString().Trim() != "")
{
objOrderDetails.stop_address_6 = reader["stop_address_6"].ToString().Trim();
}
if (reader["stop_address_7"] != DBNull.Value && reader["stop_address_7"].ToString().Trim() != "")
{
objOrderDetails.stop_address_7 = reader["stop_address_7"].ToString().Trim();
}
if (reader["stop_address_8"] != DBNull.Value && reader["stop_address_8"].ToString().Trim() != "")
{
objOrderDetails.stop_address_8 = reader["stop_address_8"].ToString().Trim();
}
if (reader["stop_address_9"] != DBNull.Value && reader["stop_address_9"].ToString().Trim() != "")
{
objOrderDetails.stop_address_9 = reader["stop_address_9"].ToString().Trim();
}
if (reader["comment"] != DBNull.Value && reader["comment"].ToString().Trim() != "")
{
objOrderDetails.comment = reader["comment"].ToString().Trim();
}
if (reader["field_8"] != DBNull.Value && reader["field_8"].ToString().Trim() != "")
{
objOrderDetails.pu_meet_instructions = reader["field_8"].ToString().Trim();
}
if (reader["field_9"] != DBNull.Value && reader["field_9"].ToString().Trim() != "")
{
objOrderDetails.dest_meet_instructions = reader["field_9"].ToString().Trim();
}
if (reader["field_15"] != DBNull.Value && reader["field_15"].ToString().Trim() != "")
{
objOrderDetails.vendor_name = reader["field_15"].ToString().Trim();
}
}
}
}
catch (Exception ex)
{
UpdateProcessingStatus(objBookingCentraliseEmailMonitor.confirmation_no, objBookingCentraliseEmailMonitor.booking_centralise_email_monitor_id, "Application Error");
}
return(objOrderDetails);
}
