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