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