コード例 #1
0
    private void GenerateCars(string FileNo)
    {
        BACarResult objCarResult = new BACarResult();
        DataSet     objDs        = objCarResult.GetCarResult("", "", "", "", 0, FileNo, "");

        if (objDs.Tables[2].Rows.Count > 0)
        {
            gvCarBookings.DataSource = objDs.Tables[2];
            gvCarBookings.DataBind();
        }
    }
コード例 #2
0
    private void CarRentals()
    {
        try
        {
            if (Session["CarResult"] != null)
            {
                BACarResult objCarResult = new BACarResult();
                DataSet     objDs        = objCarResult.GetCarResult("", "", "", "", Convert.ToInt32(Session["CarResult"]), "", "");

                if (objDs.Tables[0].Rows.Count > 0)
                {
                    rptCars.DataSource = objDs;
                    rptCars.DataBind();
                }
            }
        }
        catch (Exception ex)
        {
            lblMsg.Text = objBOUtiltiy.ShowMessage("danger", "System Error", ex.Message);
        }
    }
コード例 #3
0
    private void PrintHotelTicket(int RequestId)
    {
        try
        {
            BACarResult objCarResult = new BACarResult();
            DataSet     objds        = objCarResult.GetCarResult("", "", "", "", RequestId, "", "");

            StringBuilder str          = new StringBuilder();
            string        BookingRefNo = string.Empty;
            string        FileNo       = string.Empty;
            if (objds.Tables[0].Rows.Count > 0)
            {
                string IssueDate      = _objBOUtiltiy.ReverseConvertDateFormat(System.DateTime.Now.ToShortDateString(), "yyyy-MM-dd");
                string CheckinDate    = objds.Tables[0].Rows[0]["pickdateandtime"].ToString();
                string Pickuploaction = objds.Tables[0].Rows[0]["pickuplocation"].ToString();
                string dropLocation   = objds.Tables[0].Rows[0]["droplocation"].ToString();
                string CheckOutDate   = objds.Tables[0].Rows[0]["droptimeanddate"].ToString();
                string CarModel       = objds.Tables[0].Rows[0]["CarModel"].ToString();

                BookingRefNo = objds.Tables[0].Rows[0]["FileNo"].ToString();

                FileNo = objds.Tables[0].Rows[0]["OrderNo"].ToString();

                str.Append("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'><html xmlns='http://www.w3.org/1999/xhtml'><head><title> </title></head>");
                str.Append("<body>");


                str.Append("<table>");
                str.Append("<tr>");
                str.Append("<td style='width: 500px;'>");
                str.Append("<img src='http://swglive.dinoosystech.com/pdfimages/logo_ukzn.png' />");
                str.Append("</td>");
                str.Append("<td align='right' valign='top'>");
                str.Append("UKZN <br/> Durban");
                str.Append("</td>");
                str.Append("</tr>");
                str.Append("<tr>");
                str.Append("<td colspan='2' align='center' style='padding: 14px;  font-size: 26px;  color: #121213;  font-weight: bold;'>");
                str.Append("Car Rental Confirmation");
                str.Append("</td>");
                str.Append("</tr>");
                str.Append("</table>");

                str.Append("<br />");

                str.Append("<table>");

                str.Append("<tr><td align='left' style='font-weight: bold;'>Order No : </td><td style='width: 482px;font-size:10px;'>" + FileNo + "</td>");
                str.Append("<td align='left' style='font-weight: bold;'></td>File No<td align='left' style='font-size:10px;'>" + BookingRefNo + "</td></tr>");

                str.Append("<tr><td align='left' style='font-weight: bold;'>Booking Ref no : </td><td style='width: 482px;font-size:10px;'>REF00125</td>");
                str.Append("<td align='left' style='font-weight: bold;'>Car Model : </td><td align='left' style='font-size:10px;'>" + CarModel + " </td></tr>");



                str.Append("<tr>");
                str.Append("<td align='left' style='font-weight: bold;font-size:10px;'>Date of Issue : </td><td align='left' style='font-size:10px;'>" + IssueDate + "</td></tr>");

                str.Append("<td align='left' style='font-weight: bold;font-size:10px;'>Pickup Date & Time : </td><td align='left' style='width: 482px;font-size:10px;'>" + CheckinDate + "</td>");
                str.Append("<td align='left' style='font-weight: bold;font-size:10px;'>Pickup location:</td><td align='left' style='font-size:10px;'>" + Pickuploaction + "</td></tr>");

                str.Append("<td align='left' style='font-weight: bold;font-size:10px;'>Drop Date & Timet :</td><td align='left' style='width: 482px;' style='font-size:10px;'>" + CheckOutDate + "</td>");
                str.Append("<td align='left' style='font-weight: bold;font-size:10px;'>Drop Location:	</td><td align='left' style='font-size:10px;'>"+ dropLocation + "</td></tr>");

                str.Append("<td></td><td></td></tr>");
                str.Append("</table>");

                str.Append("<br />");



                str.Append("</body></html>");
            }
            #region SendingMail
            int MailPersonId   = Convert.ToInt32(Session["loginId"]);
            int RoleId         = Convert.ToInt32(Session["role_id"]);
            int CompanyId      = Convert.ToInt32(Session["CompanyId"]);
            int MailCategoryId = 2;

            DataSet objDsEmailConfigue = _objBOUtiltiy.GetEmailCofigue(MailPersonId, RoleId, CompanyId, MailCategoryId);
            if (objDsEmailConfigue.Tables[0].Rows.Count > 0)
            {
                string Subject         = string.Empty;
                string TravellerEmail  = string.Empty;
                string DisplayNameFrom = string.Empty;
                string strName         = string.Empty;
                string RefNo           = string.Empty;

                TravellerEmail = objds.Tables[0].Rows[0]["GuestEmail"].ToString();

                strName         = objds.Tables[0].Rows[0]["GuestFirstName"].ToString() + " " + objds.Tables[0].Rows[0]["GuestLastName"].ToString();
                RefNo           = objds.Tables[0].Rows[0]["HotelRequestId"].ToString();
                DisplayNameFrom = objDsEmailConfigue.Tables[0].Rows[0]["DisplayNameFrom"].ToString();
                Subject         = objds.Tables[0].Rows[0]["CompanyName"].ToString() + " Hotel Booking Confirmation With File No : " + FileNo;
                string SmtpHost = objDsEmailConfigue.Tables[0].Rows[0]["SmtpHost"].ToString();
                int    SmtpPort = Convert.ToInt32(objDsEmailConfigue.Tables[0].Rows[0]["SmtpPort"].ToString());// 25;
                string MailFrom = objDsEmailConfigue.Tables[0].Rows[0]["MailFrom"].ToString();

                string FromPassword  = objDsEmailConfigue.Tables[0].Rows[0]["EmailPassword"].ToString();
                string MailTo        = TravellerEmail;
                string DisplayNameTo = strName;
                string MailCc        = objDsEmailConfigue.Tables[0].Rows[0]["Mailcc"].ToString();
                string DisplayNameCc = "";
                string MailBcc       = "";

                string MailText = "Dear " + strName + "<br/>" + str.ToString();
                Utilitys.Email.SendEmail(SmtpHost, SmtpPort, MailFrom, DisplayNameFrom, FromPassword, MailTo.TrimEnd(','), DisplayNameTo, MailCc,
                                         DisplayNameCc, MailBcc, Subject, MailText, "");
            }
            else
            {
                lblMsg.Text = _objBOUtiltiy.ShowMessage("danger", "Info", "Email details not found");
            }
            #endregion SendingMail
            Text2PDFnew(str.ToString(), "Car" + RequestId);
        }
        catch (Exception ex)
        {
            lblMsg.Text = _objBOUtiltiy.ShowMessage("danger", "Error", ex.Message);
        }
    }