private void GetReportSummary(OrderDeatils objOrdertails)
{
builder = builder + ("<hr style=' margin-top: 10px; margin-bottom: 10px; border-bottom: solid 3px #000;'/>");
builder = builder + ("<table align='center' cellpadding='0' cellspacing='0' style='width: 760px; border: none;'>");
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 120px; padding: 5px;'>Passenger</td>");
builder = builder + ("<td style=' width: 250px; padding: 5px;'>" + ("" + objOrdertails.passenger) + "</td>");
builder = builder + ("<td style=' font-weight: bold; width: 130px; padding: 5px;'>Confirmation #</td>");
builder = builder + ("<td style=' width: 250px; padding: 5px;'>" + objOrdertails.confirmation_no.ToString().Substring(4) + "</td>");
builder = builder + ("</tr>");
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 120px; padding: 5px;'>Phone</td>");
builder = builder + ("<td style=' width: 250px; padding: 5px;'>" + ("" + objOrdertails.acct_address_3) + "</td>");
builder = builder + ("<td style=' font-weight: bold; width: 130px; padding: 5px;'>Trip Date</td>");
builder = builder + ("<td style=' width: 250px; padding: 5px;'>" + objOrdertails.trip_date_time.Date.ToShortDateString().ToString() + "</td>");
builder = builder + ("</tr>");
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 120px; padding: 5px;'>Agent</td>");
builder = builder + ("<td style=' width: 250px; padding: 5px;'>" + ("" + objOrdertails.agent_id) + "</td>");
builder = builder + ("<td style=' font-weight: bold; width: 130px; padding: 5px;'>Trip Time</td>");
builder = builder + ("<td style=' width: 250px; padding: 5px;'>" + objOrdertails.trip_date_time.ToLongTimeString() + "</td>");
builder = builder + ("</tr>");
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 120px; padding: 5px;'> </td>");
builder = builder + ("<td style=' width: 250px; padding: 5px;'>" + " " + "</td>");
builder = builder + ("<td style=' font-weight: bold; width: 130px; padding: 5px;'>Car Type</td>");
builder = builder + ("<td style=' width: 250px; padding: 5px;'>" + ("" + objOrdertails.car_type) + "</td>");
builder = builder + ("<td style=' font-weight: bold; width: 120px; padding: 5px;'>Passengers #</td>");
builder = builder + ("<td style=' width: 250px; padding: 5px;'>" + ("" + objOrdertails.no_passenger) + "</td>");
builder = builder + ("</tr>");
builder = builder + ("</table>");
}
public string GetEmailSubject(OrderDeatils objOrderDetails)
{
string email_subject = "";
string trip_date = objOrderDetails.trip_date_time.ToShortDateString();
string trip_24time = Convert.ToDateTime(objOrderDetails.trip_date_time).ToString("HH:mm");
string trip_12time = objOrderDetails.trip_date_time.ToShortTimeString();
try
{
switch (objOrderDetails.email_type.ToUpper())
{
case "NEW":
email_subject = objOrderDetails.company_name + " New Booking: Passenger " + objOrderDetails.passenger + " " + trip_date + " " + trip_24time + " (" + trip_12time + ") with " + objOrderDetails.vendor_name;
break;
case "MODIFY":
email_subject = objOrderDetails.company_name + " Revised Booking: Passenger " + objOrderDetails.passenger + " " + trip_date + " " + trip_24time + " (" + trip_12time + ") with " + objOrderDetails.vendor_name;
break;
case "CANCEL":
email_subject = objOrderDetails.company_name + " Canceled Booking: Passenger " + objOrderDetails.passenger + " " + trip_date + " " + trip_24time + " (" + trip_12time + ") with " + objOrderDetails.vendor_name;
break;
default:
email_subject = objOrderDetails.company_name + " New Booking: Passenger " + objOrderDetails.passenger + " " + trip_date + " " + trip_24time + " (" + trip_12time + ") with " + objOrderDetails.vendor_name;
break;
}
}
catch (Exception ex)
{
}
return(email_subject);
}
private void GetReportHeader(OrderDeatils objOrdertails)
{
builder = builder + ("<div style='margin-left: auto; margin-right: auto; width: 760px;'>");
builder = builder + ("<div style='height: 20px;'></div>");
builder = builder + ("<table cellpadding='0' cellspacing='0' border='0' style='width: 100%'>");
builder = builder + ("<tr>");
builder = builder + ("<td>");
builder = builder + ("<div style='font-size: 22px; font-weight: bold; text-align: center; margin-bottom: 10px;'>");
builder = builder + ("" + objOrdertails.company_name);
builder = builder + ("</div>");
builder = builder + ("<div style='font-weight: bold; text-align: center; display: block; margin-bottom: 8px;'>");
builder = builder + ("" + objOrdertails.company_address_1);
builder = builder + ("<div style='font-weight: bold; text-align: center; display: block; margin-bottom: 8px;'>");
builder = builder + ("" + objOrdertails.company_address_2);
builder = builder + ("<div style='font-weight: bold; text-align: center; display: block; margin-bottom: 8px;'>");
builder = builder + ("" + objOrdertails.company_phone);
builder = builder + ("</td>");
builder = builder + ("</tr></table>");
builder = builder + ("<div style='height: 20px;'></div>");
builder = builder + ("<table align='center' style='text-align: center; margin-left: 40px; width: 680px; height: 35px; border: solid 1px #000; padding-top: 5px;' class='shadow'>");
builder = builder + ("<tr>");
builder = builder + ("<td style='font-size: 16px; font-weight: bold; margin-left: 0px;'>CONFIRMATION OF </TD>");
builder = builder + ("<td style='font-size: 24px; font-weight: bold; color: red;'>" + ("" + objOrdertails.reservation_type) + "</td>");
builder = builder + ("<td style='font-size: 16px; font-weight: bold;'> RESERVATION</td>");
builder = builder + ("</tr>");;
builder = builder + ("</table>");
builder = builder + ("<div style='clear: both; height: 30px;'></div>");
builder = builder + ("<div style='text-align: center; margin-top: 10px;'>");
builder = builder + ("Thank you for choosing " + objOrdertails.company_name + " for your travel needs. PLEASE REVIEW THE ITINERARY BELOW.");
builder = builder + ("<br />");
builder = builder + ("Please contact us with any questions.");
builder = builder + ("</div>");
}
private void Identifier()
{
DBFunctions objDBFunctions = new DBFunctions();
OrderDeatils objOrderDeatils = new OrderDeatils();
Email objEmail = new Email();
string builder = "";
List <BookingCentraliseEmailMonitor> objBookingCentraliseEmailMonitors = new List <BookingCentraliseEmailMonitor>();
try
{
log.Info("EmailSender Indentifier Started on: " + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
//ParallelOptions parallelOptions = new ParallelOptions();
//parallelOptions.MaxDegreeOfParallelism = ServiceConfig.MaxDegreeOfParallelism == 0 ? (System.Environment.ProcessorCount / 2) : ServiceConfig.MaxDegreeOfParallelism;
//Get Confs,Format,account send flag etc
objBookingCentraliseEmailMonitors = objDBFunction.GetConfirmationNoFormats();
foreach (BookingCentraliseEmailMonitor objBookingCentraliseEmailMonitor in objBookingCentraliseEmailMonitors)
{
//Check email send flag
if (objBookingCentraliseEmailMonitor.acct_send_flag == "N" || (objBookingCentraliseEmailMonitor.vip_send_flag == "N" && objBookingCentraliseEmailMonitor.acct_admin_send_flag == "N"))
{
//update acct_check_ts to checked, but not send email
objDBFunction.Updateistransfer(objBookingCentraliseEmailMonitor.confirmation_no, false, objBookingCentraliseEmailMonitor.booking_centralise_email_monitor_id);
}
else
{
//update acct_check_ts to checked, send email, and status to processing
objDBFunction.Updateistransfer(objBookingCentraliseEmailMonitor.confirmation_no, true, objBookingCentraliseEmailMonitor.booking_centralise_email_monitor_id);
//GetEmailDetails
objOrderDeatils = objDBFunction.GetEmailOrderDetails(objBookingCentraliseEmailMonitor, objBookingCentraliseEmailMonitor.email_type);
objOrderDeatils.email_type = objBookingCentraliseEmailMonitor.email_type;
objOrderDeatils.company = objBookingCentraliseEmailMonitor.company;
//Transfer(Upload) Email
builder = objEmail.GetReportHtml(objOrderDeatils);
objEmail.TransferEmail(objOrderDeatils, builder, objBookingCentraliseEmailMonitor.email_format, objBookingCentraliseEmailMonitor.booking_centralise_email_monitor_id);
//Update status to transferred
objDBFunction.UpdateProcessingStatus(objBookingCentraliseEmailMonitor.confirmation_no, objBookingCentraliseEmailMonitor.booking_centralise_email_monitor_id, "Transferred");
}
//Generate HTML or PDF
}
}
catch (Exception ex)
{
//Update status to transferred
//objDBFunction.UpdateProcessingStatus(objBookingCentraliseEmailMonitor.confirmation_no, objBookingCentraliseEmailMonitor.booking_centralise_email_monitor_id, "Application Error");
}
}
public string GetReportHtml(OrderDeatils objOrdertails)
{
GetHtmlHeader();
GetReportHeader(objOrdertails);
GetReportSummary(objOrdertails);
GetReportItinerary_Farm(objOrdertails);
GetReportTripInstruction(objOrdertails);
return(builder);
}
public void TransferEmail(OrderDeatils objOrderDetails, string builder, string email_format, int booking_centralise_email_monitor_id)
{
WebClient client = new WebClient();
DBFunctions objDBFunctions = new DBFunctions();
string directory = "";
string sSubject = "";
string sSendInfo = "";
//string strFileName_attach = "";
string ftp_name_path = "";
string local_email_path = ConfigurationManager.AppSettings["local_email_path"];
local_email_path = email_format == "HTML" ? local_email_path + ".html" : local_email_path + ".pdf";
try
{
directory = objDBFunctions.GetDirectoryPath(objOrderDetails.company);
sSubject = objDBFunctions.GetEmailSubject(objOrderDetails);
sSendInfo = objDBFunctions.GetEmailAddress(objOrderDetails.confirmation_no);
ftp_name_path = email_format == "HTML" ? directory + "TT_" + objOrderDetails.confirmation_no + ".html" : directory + "TT_" + objOrderDetails.confirmation_no + ".pdf";
sSendInfo = "*****@*****.**";
//email_format = "HTML";
if (email_format == "HTML")
{
//write HTML file to local
File.WriteAllText(local_email_path, builder.ToString());
}
else
{
//write PDF file to local
var htmlToPdf = new NReco.PdfGenerator.HtmlToPdfConverter();
var pdfBytes = htmlToPdf.GeneratePdf(builder);
File.WriteAllBytes(local_email_path, pdfBytes);
}
//FTP Password
//client.Credentials = new NetworkCredential(ftp_username, ftp_password);
client.Credentials = CredentialCache.DefaultCredentials;
//upload file to ftp
client.UploadFile(ftp_name_path, "STOR", local_email_path);
//ftp_name_path = "\\\\cluster-1fs\\Aleph_share\\EmailConf\\FT_1700458258.pdf";
//Insert to Email Table
objDBFunctions.InsertToEmailTable(objOrderDetails.confirmation_no, booking_centralise_email_monitor_id, ftp_name_path, sSendInfo, ftp_name_path, sSubject, objOrderDetails.company);
}
catch (Exception ex)
{
}
}
public IActionResult SummeryPost() // string stripeToken
{
var claimsIdentity = (ClaimsIdentity)User.Identity;
var claim = claimsIdentity.FindFirst(ClaimTypes.NameIdentifier);
ShoppingCartVM.OrderHeader.ApplicationUser = _unitOfWork.ApplicationUser
.GetFirstOrDefailt(c => c.Id == claim.Value, includeProperties: "Company");
ShoppingCartVM.ListCart = _unitOfWork.ShoppingCart.GetAll(c => c.ApplicationUserId == claim.Value, includeProperties: "Product");
ShoppingCartVM.OrderHeader.PaymentStatus = SD.PaymentStatusApproved;
ShoppingCartVM.OrderHeader.OrderStatus = SD.StatusPending;
ShoppingCartVM.OrderHeader.ApplicationUserId = claim.Value;
ShoppingCartVM.OrderHeader.OrderDate = DateTime.Now;
_unitOfWork.OrderHeader.Add(ShoppingCartVM.OrderHeader);
_unitOfWork.Save();
foreach (var item in ShoppingCartVM.ListCart)
{
item.Price = SD.GetPriceBasedOnQuantity(item.Count, item.Product.Price, item.Product.Price50, item.Product.Price100);
OrderDeatils orderDeatils = new OrderDeatils()
{
ProductId = item.ProductId,
OrderId = ShoppingCartVM.OrderHeader.Id,
Price = item.Price,
Count = item.Count
};
ShoppingCartVM.OrderHeader.OrderTotal += orderDeatils.Count * orderDeatils.Price;
_unitOfWork.OrderDetails.Add(orderDeatils);
_unitOfWork.Save();
}
_unitOfWork.ShoppingCart.RemoveRange(ShoppingCartVM.ListCart);
_unitOfWork.Save();
HttpContext.Session.SetInt32(SD.ssShopingCart, 0);
return(RedirectToAction("OrderConfirmation", "Cart", new { id = ShoppingCartVM.OrderHeader.Id }));
}
private void GetReportTripInstruction(OrderDeatils objOrdertails)
{
builder = builder + ("<table align='center' cellpadding='0' cellspacing='0' style='width: 480px;'>");
builder = builder + ("<div style='height: 20px'></div>");
builder = builder + ("</table>");
builder = builder + ("<div style=' text-align: center; text-decoration: underline; font-size: 16px; font-weight: bold; margin-top: 20px; margin-bottom: 20px;'>TRIP INSTRUCTION</div>");
builder = builder + ("<table align='center' cellpadding='0' cellspacing='0' style='width: 760px; border: none;'>");
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 120px; padding: 5px;'>Comments :</td>");
builder = builder + ("<td style=' padding: 5px; font-weight: bold; color: red;'>" + ("" + objOrdertails.comment) + "</td>");
builder = builder + ("</tr>");
builder = builder + ("</table>");
builder = builder + ("<div style='height: 20px'></div>");
builder = builder + ("<table align='center' cellpadding='0' cellspacing='0' style='width: 760px; border: none;'>");
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 120px; padding: 5px;'>Pickup Meet Instructions :</td>");
builder = builder + ("<td style=' padding: 5px; font-weight: bold;'>" + ("" + objOrdertails.pu_meet_instructions) + "</td>");
builder = builder + ("</tr>");
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 120px; padding: 5px;'>Destination Meet Instructions :</td>");
builder = builder + ("<td style=' padding: 5px; font-weight: bold;'>" + ("" + objOrdertails.dest_meet_instructions) + "</td>");
builder = builder + ("</tr>");
builder = builder + ("</table>");
}
private void GetReportItinerary_Farm(OrderDeatils objOrdertails)
{
builder = builder + ("<div style=' text-align: center; text-decoration: underline; font-size: 16px; font-weight: bold; margin-top: 20px; margin-bottom: 20px;'>ITINERARY</div>");
builder = builder + ("<table align='center' cellpadding='0' cellspacing='0' style='width: 760px;'>");
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 60px; padding: 5px;'>Pickup</td>");
builder = builder + ("<td style=' font-size :11px; padding: 5px;'>" + ("" + objOrdertails.pu_address.Trim()) + "</td>");
builder = builder + ("</tr>");
if (objOrdertails.stop_address_2.Trim() != "")
{
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 60px; padding: 5px;'>Stop1</td>");
builder = builder + ("<td style=' font-size :11px; padding: 5px;'>" + ("" + objOrdertails.stop_address_2.Trim()) + "</td>");
builder = builder + ("</tr>");
}
if (objOrdertails.stop_address_3.Trim() != "")
{
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 60px; padding: 5px;'>Stop2</td>");
builder = builder + ("<td style=' font-size :11px; padding: 5px;'>" + ("" + objOrdertails.stop_address_3.Trim()) + "</td>");
builder = builder + ("</tr>");
}
if (objOrdertails.stop_address_4.Trim() != "")
{
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 60px; padding: 5px;'>Stop3</td>");
builder = builder + ("<td style=' font-size :11px; padding: 5px;'>" + ("" + objOrdertails.stop_address_4.Trim()) + "</td>");
builder = builder + ("</tr>");
}
if (objOrdertails.stop_address_5.Trim() != "")
{
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 60px; padding: 5px;'>Stop4</td>");
builder = builder + ("<td style=' font-size :11px; padding: 5px;'>" + ("" + objOrdertails.stop_address_5.Trim()) + "</td>");
builder = builder + ("</tr>");
}
if (objOrdertails.stop_address_6.Trim() != "")
{
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 60px; padding: 5px;'>Stop5</td>");
builder = builder + ("<td style=' font-size :11px; padding: 5px;'>" + ("" + objOrdertails.stop_address_6.Trim()) + "</td>");
builder = builder + ("</tr>");
}
if (objOrdertails.stop_address_7.Trim() != "")
{
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 60px; padding: 5px;'>Stop6</td>");
builder = builder + ("<td style=' font-size :11px; padding: 5px;'>" + ("" + objOrdertails.stop_address_7.Trim()) + "</td>");
builder = builder + ("</tr>");
}
if (objOrdertails.stop_address_8.Trim() != "")
{
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 60px; padding: 5px;'>Stop7</td>");
builder = builder + ("<td style=' font-size :11px; padding: 5px;'>" + ("" + objOrdertails.stop_address_8.Trim()) + "</td>");
builder = builder + ("</tr>");
}
if (objOrdertails.stop_address_9.Trim() != "")
{
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 60px; padding: 5px;'>Stop8</td>");
builder = builder + ("<td style=' font-size :11px; padding: 5px;'>" + ("" + objOrdertails.stop_address_9.Trim()) + "</td>");
builder = builder + ("</tr>");
}
builder = builder + ("<tr>");
builder = builder + ("<td style=' font-weight: bold; width: 60px; padding: 5px;'>Destination</td>");
builder = builder + ("<td style=' font-size :11px; padding: 5px;'>" + ("" + objOrdertails.dest_address) + "</td>");
builder = builder + ("</tr>");
builder = builder + ("</table>");
builder = builder + ("<td valign='top'>");
builder = builder + ("<table cellpadding='0' cellspacing='0' style='width: 280px; border: none'>");
builder = builder + ("</table>");
builder = builder + ("</td>");
}
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);
}
