protected void fillActivityList()
{
List <PackageActivityEnquiry> actList = null;
if (Session["activityList"] != null)
{
actList = (List <PackageActivityEnquiry>)Session["activityList"];
string htmlString = "";
if (actList.Count > 0)
{
for (int i = 0; i < actList.Count; i++)
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam("activity a, packageitineraryactivity b ", " " +
" a.activityname, a.adultprice ", " " +
" a.activityid=b.activityid and b.packageitinerary_activityid='" + actList[i].iActivityId.ToString() + "'");
foreach (DataRow dr in dt.Rows)
{
htmlString += "<h6> " + dr["activityname"].ToString() + ": </h6> <h6>" + dr["adultprice"].ToString() + " Per Person</h6>";
break;
}
}
divDisplayActivity.InnerHtml = htmlString;
divActivity.Visible = true;
}
else
{
divActivity.Visible = false;
}
}
else
{
divActivity.Visible = false;
}
}
private void BindGrid(string sortExpression = null)
{
DataTable dt = new DataTable();
string searchQry = "";
if (txtSearch.Text != null && txtSearch.Text.ToString() != "")
{
searchQry = " and (p.packagetitle like '%" + txtSearch.Text.ToString().Trim() + "%' or " +
" a.packagecategoryname like '%" + txtSearch.Text.ToString().Trim() + "%' ) ";
}
dt = dbCommon.DisplayDataParam(" package p, packagecategory a ", " " +
" p.packagetitle,p.validfrom,p.validto, a.packagecategoryname, p.packageid ",
" p.packagecategoryid=a.packagecategoryid and p.deleteflg=0 " + searchQry + " order by p.packageid desc");
if (sortExpression != null)
{
DataView dv = dt.AsDataView();
this.SortDirection = this.SortDirection == "ASC" ? "DESC" : "ASC";
dv.Sort = sortExpression + " " + this.SortDirection;
grdAddPackage.DataSource = dv;
}
else
{
grdAddPackage.DataSource = dt;
}
grdAddPackage.DataBind();
}
private void BindGrid(string sortExpression = null)
{
if (ddActivityName.SelectedValue != "0")
{
DataTable dt = new DataTable();
string searchQry = "";
if (txtSearch.Text != null && txtSearch.Text.ToString() != "")
{
searchQry = " and ( " +
" b.question like '%" + txtSearch.Text.ToString().Trim() + "%' or " +
" b.answer like '%" + txtSearch.Text.ToString().Trim() + "%' ) ";
}
dt = dbCommon.DisplayDataParam(" faqs b, activity a ", " b.* ",
" 0=0 and a.deleteflg = 0 " +
" and a.activityid='" + ddActivityName.SelectedValue.ToString() + "' " +
" and b.activityid=a.activityid " + searchQry + " order by faqid desc ");
if (sortExpression != null)
{
DataView dv = dt.AsDataView();
this.SortDirection = this.SortDirection == "ASC" ? "DESC" : "ASC";
dv.Sort = sortExpression + " " + this.SortDirection;
grdActivityFAQ.DataSource = dv;
}
else
{
grdActivityFAQ.DataSource = dt;
}
grdActivityFAQ.DataBind();
}
}
private void BindGrid(string sortExpression = null)
{
DataTable dt = new DataTable();
string searchQry = "";
if (txtSearch.Text != null && txtSearch.Text.ToString() != "")
{
searchQry = " and ( " +
"c.countryname like '%" + txtSearch.Text.ToString().Trim() + "%' " +
" or b.cityname like '%" + txtSearch.Text.ToString().Trim() + "%' or " +
" a.areaname like '%" + txtSearch.Text.ToString().Trim() + "%') ";
}
dt = dbCommon.DisplayDataParam(" area a,city b, Country c", " a.*, b.cityname, c.countryname ", " " +
" a.cityid=b.cityid and b.countryid=c.countryid " + searchQry + " order by a.areaid desc ");
if (sortExpression != null)
{
DataView dv = dt.AsDataView();
this.SortDirection = this.SortDirection == "ASC" ? "DESC" : "ASC";
dv.Sort = sortExpression + " " + this.SortDirection;
grdArea.DataSource = dv;
}
else
{
grdArea.DataSource = dt;
}
grdArea.DataBind();
}
protected void checkEmailId(string type)
{
DataTable dt = new DataTable();
if (type.ToString().Equals("email"))
{
dt = dbCommon.DisplayDataParam(" user_details a left join " +
" contact b on a.userid=b.userid ", "" +
" a.user_fname, a.user_lname, b.primaryphone ", "" +
" a.emailid='" + txtemail.Text.ToString().Trim().ToLower() + "' ");
}
else
{
dt = dbCommon.DisplayDataParam(" user_details a " +
" left join contact b on a.userid=b.userid ", " " +
" a.emailid,a.user_fname, a.user_lname, b.primaryphone ", "" +
" a.userid='" + Session["LoginUserId"].ToString() + "' ");
}
if (dt.Rows.Count > 0)
{
if (type.ToString().Equals("userid"))
{
txtemail.Text = dt.Rows[0]["emailid"].ToString();
}
txtphnno.Text = dt.Rows[0]["primaryphone"].ToString();
txtfname.Text = dt.Rows[0]["user_fname"].ToString() + " " + dt.Rows[0]["user_lname"].ToString();
txtfname.Enabled = false;
txtfname.CssClass = "form-control";
//txtlname.Enabled = false;
//txtlname.CssClass = "form-control";
txtemail.Enabled = false;
txtemail.CssClass = "form-control";
if (string.IsNullOrEmpty(dt.Rows[0]["primaryphone"].ToString()))
{
txtphnno.Enabled = true;
txtphnno.Focus();
}
else
{
txtphnno.Enabled = false;
txtphnno.CssClass = "form-control";
}
if (txtphnno.Enabled == true)
{
txtphnno.Focus();
}
}
else
{
txtfname.Focus();
txtfname.Enabled = true;
//txtlname.Enabled = true;
txtemail.Enabled = true;
txtphnno.Enabled = true;
}
}
protected void BindGridCustomPackage()
{
grdcustomPackage.DataSource = dbCommon.DisplayDataParam("custompackage a " +
" left join city b on b.cityid = a.destinationcityid ", "" +
" b.cityname, a.custompackageid, " +
" CONCAT(SUBSTRING('JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC ', " +
" (a.travelmonth * 4) - 3, 3), '-', a.travelyear) As 'tDate', " +
" a.budget, a.description, a.createdate, a.replydate ", "" +
" a.userid='" + Session["LoginUserId"].ToString() + "'");
grdcustomPackage.DataBind();
}
public void ActivityImage()
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam("activityimage", " activityimagesrc " +
"", " 0=0 and activityId='" + dbCommon.GetUpdateId("activityId") + "'");
rImage.DataSource = dt;
rImage.DataBind();
rImageThumb.DataSource = dt;
rImageThumb.DataBind();
}
protected void Fill_Designation()
{
DataTable dtActCat = new DataTable();
dtActCat = dbCommon.DisplayDataParam("designation", "designationid,designation", " 0 = 0 and designationid not in('1','4') ");
dddesignation.Items.Clear();
dddesignation.Items.Add(new ListItem("Select Designation", "Select Designation"));
foreach (DataRow drActCat in dtActCat.Rows)
{
dddesignation.Items.Add(new ListItem(drActCat["designation"].ToString(), drActCat["designationid"].ToString()));
}
}
protected void Fill_Combo()
{
DataTable dtCountry = new DataTable();
dtCountry = dbCommon.DisplayDataParam("country", "countryid,countryname", " 0 = 0");
ddCountry.Items.Clear();
ddCountry.Items.Add(new ListItem("SELECT", "0"));
foreach (DataRow drActCat in dtCountry.Rows)
{
ddCountry.Items.Add(new ListItem(drActCat["countryname"].ToString(),
drActCat["countryid"].ToString()));
}
}
private void FetchData()
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam("about_us", "*", " 0=0 ");
if (dt.Rows.Count > 0)
{
btnSubmit.Text = "Update";
txtPhone.Text = dt.Rows[0]["phone1"].ToString();
txtPhone2.Text = dt.Rows[0]["phone2"].ToString();
txtEmail.Text = dt.Rows[0]["email_id"].ToString();
txtAddress1.Text = dt.Rows[0]["address_line1"].ToString();
txtAddress2.Text = dt.Rows[0]["address_line2"].ToString();
txtAddress3.Text = dt.Rows[0]["address_line3"].ToString();
txtTitle.Text = dt.Rows[0]["title"].ToString();
txtDescriptionMain.Text = dt.Rows[0]["description_main"].ToString();
txtDescActivity.Text = dt.Rows[0]["description_activity"].ToString();
txtDescPackage.Text = dt.Rows[0]["description_package"].ToString();
txtDescFooter.Text = dt.Rows[0]["description_footer"].ToString();
txtTiming.Text = dt.Rows[0]["office_hours"].ToString();
txtFacebook.Text = dt.Rows[0]["facebook_link"].ToString();
txtInstagram.Text = dt.Rows[0]["insta_link"].ToString();
txtGmail.Text = dt.Rows[0]["google_link"].ToString();
txtTwitter.Text = dt.Rows[0]["twitter_link"].ToString();
txtYoutube.Text = dt.Rows[0]["youtube_link"].ToString();
}
}
public void checkitemdata()
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam("user_details", "userid,usertype,user_fname,user_lname", " emailid='" + txtEmailID.Text.ToString().Trim().ToLower() + "'");
if (dt.Rows.Count >= 1)
{
if (dt.Rows[0]["usertype"].ToString() == "GUEST")
{
lblEmailIdEx.Text = "";
lblEmailIdEx.Visible = false;
ViewState["UserType"] = "GUEST";
}
else
{
txtFirstName.Text = "";
txtLastName.Text = "";
lblEmailIdEx.Text = "* This Email id already exist.";
lblEmailIdEx.Visible = true;
}
}
else
{
ViewState["UserType"] = "NEW";
lblEmailIdEx.Text = "";
lblEmailIdEx.Visible = false;
}
}
protected void Fill_Combo()
{
DataTable dtPackCat = new DataTable();
dtPackCat = dbCommon.DisplayDataParam("package", " packageid,packagetitle ", " 0 = 0 and deleteflg=0 order by packagetitle ");
cmbPackage.Items.Clear();
cmbPackage.Items.Add(new ListItem("SELECT", "0"));
foreach (DataRow drPackCat in dtPackCat.Rows)
{
cmbPackage.Items.Add(new ListItem(drPackCat["packagetitle"].ToString(), drPackCat["packageid"].ToString()));
}
if (dbCommon.IsEmptyUpdateId("imageAddId"))
{
cmbPackage.SelectedValue = dbCommon.GetUpdateId("imageAddId");
fillData();
}
}
private void BindGrid()
{
grduserActivation.DataSource = dbCommon.DisplayDataParam(" user_details ", "" +
"userid,user_fname,user_lname,emailid,deactivedate,usertype, " +
" Case(activeflag) when 1 then 'De-Active' when 0 then 'Active' end as status", " " +
" designationid=4 ");
grduserActivation.DataBind();
}
protected void Fill_Combo()
{
DataTable dtPackCat = new DataTable();
dtPackCat = dbCommon.DisplayDataParam("package", " packageid,packagetitle ", " 0 = 0 and deleteflg=0 order by packagetitle ");
ddPackageName.Items.Clear();
ddPackageName.Items.Add(new ListItem("Select Package Name", "0"));
foreach (DataRow drPackCat in dtPackCat.Rows)
{
ddPackageName.Items.Add(new ListItem(drPackCat["packagetitle"].ToString(), drPackCat["packageid"].ToString()));
}
if (dbCommon.IsEmptyUpdateId("imageAddId"))
{
ddPackageName.SelectedValue = dbCommon.GetUpdateId("imageAddId");
}
DataTable dtArea = new DataTable();
dtArea = dbCommon.DisplayDataParam("area", " * ", " 0 = 0 order by areaname");
ddPackageArea.Items.Clear();
ddPackageArea.Items.Add(new ListItem("Select Area", "0"));
foreach (DataRow drArea in dtArea.Rows)
{
ddPackageArea.Items.Add(new ListItem(drArea["areaname"].ToString(), drArea["areaid"].ToString()));
}
}
private void BindGrid(string sortExpression = null)
{
DataTable dt = new DataTable();
string searchQry = "";
if (txtSearch.Text != null && txtSearch.Text.ToString() != "")
{
searchQry = " and (a.activityname like '%" + txtSearch.Text.ToString().Trim() + "%' or " +
" b.activitytypename like '%" + txtSearch.Text.ToString().Trim() + "%' or " +
" a.streetname like '%" + txtSearch.Text.ToString().Trim() + "%' or " +
" c.areaname like '%" + txtSearch.Text.ToString().Trim() + "%' or " +
" d.cityname like '%" + txtSearch.Text.ToString().Trim() + "%' or " +
" e.countryname like '%" + txtSearch.Text.ToString().Trim() + "%' ) ";
}
dt = dbCommon.DisplayDataParam(" activity a, activitytype b, area c, city d, country e ", " " +
" a.activityid, a.activityname,b.activitytypename," +
" a.streetname , c.areaname , d.cityname, e.countryname ",
" b.activitytypeid=a.activitytypeid and c.areaid=a.areaid and d.cityid=c.cityid " +
" and e.countryid=d.countryid " +
" and a.deleteflg = 0 " + searchQry + " order by a.activityid desc");
if (sortExpression != null)
{
DataView dv = dt.AsDataView();
this.SortDirection = this.SortDirection == "ASC" ? "DESC" : "ASC";
dv.Sort = sortExpression + " " + this.SortDirection;
grdAddActvity.DataSource = dv;
}
else
{
grdAddActvity.DataSource = dt;
}
grdAddActvity.DataBind();
}
public void fillPackages()
{
DataTable dtPackCat = new DataTable();
dtPackCat = dbCommon.DisplayDataParam(" packagecategory ", " packagecategoryid, packagecategoryname ", " " +
"0 = 0 order by packagecategoryname ");
cmbPackageType.Items.Clear();
cmbPackageType.Items.Add(new ListItem("Select Package Type", "0"));
foreach (DataRow drPackCat in dtPackCat.Rows)
{
cmbPackageType.Items.Add(new ListItem(drPackCat["packagecategoryname"].ToString(),
drPackCat["packagecategoryid"].ToString()));
}
}
public void fillActivity()
{
DataTable dtPackCat = new DataTable();
dtPackCat = dbCommon.DisplayDataParam(" activitytype ", " activitytypeid, activitytypename ", " " +
"0 = 0 order by activitytypename ");
cmbActivityType.Items.Clear();
cmbActivityType.Items.Add(new ListItem("SELECT", "0"));
foreach (DataRow drPackCat in dtPackCat.Rows)
{
cmbActivityType.Items.Add(new ListItem(drPackCat["activitytypename"].ToString(),
drPackCat["activitytypeid"].ToString()));
}
}
private void BindGrid()
{
try
{
grdPackageInquiry.DataSource = DBCommon.DisplayDataParam("bookpackage b left join package p on b.packageid=p.packageid ", " " +
" b.bookpackageid,b.totalpayment,b.discountamount,b.enquirytime,b.packagedate,(ISNULL(b.adultmember,0)+ISNULL(b.childmember,0)+ISNULL(b.studentmember,0)+ ISNULL(b.seniormember,0)+ISNULL(b.infantmember,0)) as adultmember," +
" p.packagetitle as name,Case(b.view_status) when 1 then 'Read' when 0 then 'UnRead' end as status", "" +
"0 = 0 order by b.enquirytime");
grdPackageInquiry.DataBind();
}
catch (Exception ex)
{
}
}
private void BindGrid(string sortExpression = null)
{
DataTable dt = new DataTable();
string searchQry = "";
if (txtSearch.Text != null && txtSearch.Text.ToString() != "")
{
searchQry = " and countryname like '%" + txtSearch.Text.ToString().Trim() + "%'";
}
dt = dbCommon.DisplayDataParam("Country", "*", " 0=0 " + searchQry + " order by countryid desc ");
if (sortExpression != null)
{
DataView dv = dt.AsDataView();
this.SortDirection = this.SortDirection == "ASC" ? "DESC" : "ASC";
dv.Sort = sortExpression + " " + this.SortDirection;
grdCountry.DataSource = dv;
}
else
{
grdCountry.DataSource = dt;
}
grdCountry.DataBind();
}
private void FetchData()
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam("about_us", "*", " 0=0 ");
if (dt.Rows.Count > 0)
{
lblaboutus.Text = dt.Rows[0]["title"].ToString();
lblmaindesc.Text = dt.Rows[0]["description_main"].ToString();
lblactivitydesc.Text = dt.Rows[0]["description_activity"].ToString();
lblpackagedesc.Text = dt.Rows[0]["description_package"].ToString();
lblmaindesc.Attributes["style"] = "color:#fff";
}
}
private void BindGrid()
{
try
{
grdUserDetail.DataSource = dbCommon.DisplayDataParam(" user_details a " +
" left join address b on a.userid = b.userid " +
" left join contact c on c.userid = a.userid " +
" left join city ct on ct.cityid = b.cityid ", "" +
" a.userid,profileimg,streetname,suburb,ct.cityname,postalcode,primaryphone,secondaryphone,emailid", "" +
" a.userid=" + ViewState["userid"]);
grdUserDetail.DataBind();
grdCustomPackage.DataSource = dbCommon.DisplayDataParam("custompackage cp " +
" left join city ct on ct.cityid = cp.destinationcityid ", "" +
" ct.cityname as dest,cp.* ", "" +
" cp.userid=" + ViewState["userid"]);
grdCustomPackage.DataBind();
grdPackageInquiry.DataSource = dbCommon.DisplayDataParam("bookpackage b left join package p on b.packageid=p.packageid ", " " +
" b.bookpackageid,b.totalpayment,b.discountamount,b.enquirytime,b.packagedate,(ISNULL(b.adultmember,0)+ISNULL(b.childmember,0)+ISNULL(b.studentmember,0)+ ISNULL(b.seniormember,0)+ISNULL(b.infantmember,0)) as adultmember," +
" p.packagetitle as name,Case(b.view_status) when 1 then 'Read' when 0 then 'UnRead' end as status", "" +
" userid=" + ViewState["userid"]);
grdPackageInquiry.DataBind();
grdActivityInquiry.DataSource = dbCommon.DisplayDataParam("bookactivity b " +
" left join activity a on b.activityid=a.activityid", " " +
" b.totalpayment,b.bookactivityid,b.activitydate," +
" b.booktime,(ISNULL(b.adultmember, 0) + ISNULL(b.childmember, 0) + ISNULL(b.seniorcitizenmember, 0) + ISNULL(b.studentmember, 0) + ISNULL(b.infentmember, 0)) as adultmember," +
" a.activityname as name,Case(b.view_status) when 1 then 'Read' when 0 then 'UnRead' end as status ", "" +
"userid=" + ViewState["userid"]);
grdActivityInquiry.DataBind();
}
catch (Exception ex)
{
}
}
public void SentMail(string userID, string PassCode)
{
try
{
DataTable dt = new DataTable();
string Name = "", email = "";
dt = dbCommon.DisplayDataParam(" user_details ", " user_fname, user_lname, emailid ", "userid='" + userID + "'");
foreach (DataRow dr in dt.Rows)
{
Name = dr["user_fname"].ToString() + " " + dr["user_lname"].ToString();
email = dr["emailid"].ToString();
break;
}
MailMessage mm = new MailMessage("*****@*****.**", email);
mm.Subject = "Forget Password - Passcode";
string body = "Hello " + Name + " ,";
body += "Your Passcode is" + PassCode;
body += "<br /><br />Thanks";
mm.Body = body;
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "password");
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
smtp.Send(mm);
divRegistration.Visible = false;
divpasscode.Visible = true;
}
catch (Exception ex)
{
Console.WriteLine("Error in sending email: " + ex.Message);
}
}
protected void BindImages()
{
if (ddActivity.SelectedValue.ToString() != "0")
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam("Activityimage", " * ",
" 0=0 and activityid='" + ddActivity.SelectedValue.ToString() + "'");
StringBuilder html = new StringBuilder();
string folderPath = "/Images/Activity/";
foreach (DataRow dr in dt.Rows)
{
html.Append("<div class='superbox-list'>");
html.Append("<a href='ActivityImage.aspx?" +
"did=" + dr["activityimageid"].ToString() + "' class='btn btn-sm btn-success'>Delete</a>");
html.Append("<img src=" +
"'" + folderPath + dr["activityimagesrc"].ToString() + "' " +
"data-img='" + folderPath + dr["activityimagesrc"].ToString() + "' " +
"style='width:200px;height:200px;' alt='' class='superbox-img' />");
html.Append("</div>");
}
divImageDisplay.InnerHtml = html.ToString();
}
}
protected void displayCustomePackage()
{
liDescription1.Visible = true;
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam("custompackage a " +
" left join city b on a.destinationcityid = b.cityid", " a.*,b.cityname ", "" +
" a.custompackageid='" + dbCommon.GetUpdateId("editId") + "' and a.userid='" + Session["LoginUserId"].ToString() + "'");
lbltourtitle.Text = "Custom Package";
lblCity.InnerText = dt.Rows[0]["cityname"].ToString();
lblTravelDate.InnerText = DateTime.Parse("01-" + dt.Rows[0]["travelmonth"].ToString() + "-2019").ToString("MMM") + " - " + dt.Rows[0]["travelyear"].ToString();
lblMembers.InnerText = "Adult - " + dt.Rows[0]["adultmember"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["childmember"].ToString()) && dt.Rows[0]["childmember"].ToString() != "0")
{
lblMembers.InnerText += ", " + "Child - " + dt.Rows[0]["childmember"].ToString();
}
lblAmount.InnerText = dt.Rows[0]["budget"].ToString();
lblDescription.InnerText = dt.Rows[0]["description"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["reply_description"].ToString()))
{
lblReplay.Visible = true;
lblReplay.InnerText = dt.Rows[0]["reply_description"].ToString();
}
}
private void BindGrid()
{
try
{
grdActivityInquiry.DataSource = DBCommon.DisplayDataParam("bookactivity b " +
" left join activity a on b.activityid=a.activityid", " " +
" b.totalpayment,b.bookactivityid,b.activitydate," +
" b.booktime,(ISNULL(b.adultmember, 0) + ISNULL(b.childmember, 0) + ISNULL(b.seniorcitizenmember, 0) + ISNULL(b.studentmember, 0) + ISNULL(b.infentmember, 0)) as adultmember," +
" a.activityname as name,Case(b.view_status) when 1 then 'Read' when 0 then 'UnRead' end as status", "" +
" 0 = 0 order by b.booktime ");
grdActivityInquiry.DataBind();
}
catch (Exception ex)
{
}
}
public static List <string> SearchDestination(string prefixText)
{
DBConnectionClass dbClass = new DBConnectionClass();
List <string> locations = new List <string>();
DataTable dt = new DataTable();
dt = dbClass.DisplayDataParam(" area a, city b, country c ", " " +
" TOP 10 a.areaname,b.cityname,c.countryname ", " a.cityid=b.cityid and b.countryid=c.countryid " +
" and (a.areaname like '%" + prefixText + "%' " +
" or b.cityname like '%" + prefixText + "%' " +
" or c.countryname like '%" + prefixText + "%')" +
" order by a.areaname, b.cityname, c.countryname ");
foreach (DataRow dr in dt.Rows)
{
locations.Add(dr["areaname"].ToString() + ", " + dr["cityname"].ToString() + ", " + dr["countryname"].ToString());
}
return(locations);
}
private void FetchData()
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam("companyprofile", "*", " 0=0 ");
if (dt.Rows.Count > 0)
{
btnSubmit.Text = "Update";
txtcompanyname.Text = dt.Rows[0]["companyname"].ToString();
txtAddress1.Text = dt.Rows[0]["addressline1"].ToString();
txtAddress2.Text = dt.Rows[0]["addressline2"].ToString();
txtAddress3.Text = dt.Rows[0]["addressline3"].ToString();
txtPhone1.Text = dt.Rows[0]["phone_no1"].ToString();
txtPhone2.Text = dt.Rows[0]["phone_no2"].ToString();
txtEmail.Text = dt.Rows[0]["email"].ToString();
txtfax.Text = dt.Rows[0]["fax"].ToString();
txtgstno.Text = dt.Rows[0]["gstno"].ToString();
byte[] bytes;
try
{
bytes = (byte[])dt.Rows[0]["logo"];
Session["imageupdate"] = bytes;
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
displayImg.ImageUrl = "data:image/png;base64," + base64String;
}
catch (Exception)
{
bytes = null;
}
txtwebsite.Text = dt.Rows[0]["website"].ToString();
if (dt.Rows[0]["company_reg_date"].ToString() != "")
{
txtcompanyregdate.Text = DateTime.Parse(dt.Rows[0]["company_reg_date"].ToString()).ToString("yyyy-MM-dd");
}
txtcontactperson.Text = dt.Rows[0]["contact_person"].ToString();
}
}
public void TourDetailsDisplay()
{
RsToWord rsTo = new RsToWord();
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam("package a", "a.packagetitle,a.adultmembers,a.adultprice,a.childprice," +
" a.studentprice,a.seniorcitizenprice," +
" a.validfrom,a.validto,a.description,a.packagedatetype,a.infentprice, a.discounttype, " +
" a.discount, a.totaldays, a.totalnights ",
" a.packageid= " + dbCommon.GetUpdateId("packageId"));
foreach (DataRow dr in dt.Rows)
{
lbltourdays.Text = dr["totaldays"].ToString() + " Days " + dr["totalnights"].ToString() + " Nights";
lbltourtitle.Text = dr["packagetitle"].ToString();
lblAdultPrice.Text = dr["adultprice"].ToString();
lblPerson.InnerText = " Adult Rate " + rsTo.ConvertNumbertoWords(Convert.ToInt64(dr["adultmembers"].ToString())) + " Person";
if (Convert.ToDouble(dr["childprice"].ToString()) == 0)
{
liChildPrice.Visible = false; lblChildPrice.Text = "0";
}
else
{
liChildPrice.Visible = true; lblChildPrice.Text = dr["childprice"].ToString();
}
if (Convert.ToDouble(dr["studentprice"].ToString()) == 0)
{
liStudentPrice.Visible = false; lblStudentPrice.Text = "0";
}
else
{
liStudentPrice.Visible = true; lblStudentPrice.Text = dr["studentprice"].ToString();
}
if (Convert.ToDouble(dr["seniorcitizenprice"].ToString()) == 0)
{
liSenior.Visible = false; lblSenior.Text = "0";
}
else
{
liSenior.Visible = true; lblSenior.Text = dr["seniorcitizenprice"].ToString();
}
if (Convert.ToDouble(dr["infentprice"].ToString()) == 0)
{
liInfent.Visible = false; lblInfant.Text = "0";
}
else
{
liInfent.Visible = true; lblInfant.Text = dr["infentprice"].ToString();
}
lbltourfrom.Text = DateTime.Parse(dr["validfrom"].ToString()).ToString("dd-MMM-yyyy");
lbltourto.Text = DateTime.Parse(dr["validto"].ToString()).ToString("dd-MMM-yyyy");;
lbltourdescription.Text = dr["description"].ToString();
switch (dr["discounttype"].ToString())
{
case "0":
liDiscount.Visible = false;
lblDiscount.Text = "0";
break;
case "1":
liDiscount.Visible = true;
lblDiscount.Text = dr["discount"].ToString() + " %";
break;
case "2":
liDiscount.Visible = true;
lblDiscount.Text = dr["discount"].ToString() + " NZD";
break;
default:
liDiscount.Visible = false;
lblDiscount.Text = "0";
break;
}
}
}
public void fillDetails()
{
if (Session["AboutUs"] == null)
{
List <AboutUsList> AboutUs = new List <AboutUsList>();
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam(" about_us ", " * ", " 0 = 0");
AboutUs.Add(new AboutUsList(dt.Rows[0]["phone1"].ToString(), dt.Rows[0]["address_line1"].ToString(),
dt.Rows[0]["address_line2"].ToString(), dt.Rows[0]["address_line3"].ToString(), dt.Rows[0]["phone2"].ToString(),
dt.Rows[0]["description_footer"].ToString(), dt.Rows[0]["facebook_link"].ToString(),
dt.Rows[0]["insta_link"].ToString(), dt.Rows[0]["youtube_link"].ToString(), dt.Rows[0]["google_link"].ToString(),
dt.Rows[0]["twitter_link"].ToString(), dt.Rows[0]["email_id"].ToString()));
Session["AboutUs"] = AboutUs;
}
List <AboutUsList> AboutUs1 = (List <AboutUsList>)Session["AboutUs"];
lblPhone1.Text = AboutUs1[0].phoneHead.ToString();
lblContPhone.InnerHtml = AboutUs1[0].phoneHead.ToString() + ", " +
"" + AboutUs1[0].phoneFoot.ToString();;
lblContAddress.InnerHtml = AboutUs1[0].address1.ToString() + ", <br />" +
"" + AboutUs1[0].address2.ToString() + ", <br />" +
"" + AboutUs1[0].address3.ToString();
linkEmailId.Text = AboutUs1[0].emailId.ToString();
linkEmailId.NavigateUrl = "mailto:" + AboutUs1[0].emailId.ToString();
linkContEmailId.Text = AboutUs1[0].emailId.ToString();
linkContEmailId.NavigateUrl = "mailto:" + AboutUs1[0].emailId.ToString();
lblDescriptionFooter.InnerHtml = Regex.Replace(AboutUs1[0].descriptionFoot.ToString(), "<.*?>", String.Empty);
if (string.IsNullOrEmpty(AboutUs1[0].linkFB.ToString()))
{
liFacebook.Visible = false;
}
else
{
hyperFacebook.NavigateUrl = AboutUs1[0].linkFB.ToString();
}
if (string.IsNullOrEmpty(AboutUs1[0].linkYoutube.ToString()))
{
liYoutube.Visible = false;
}
else
{
hyperYoutube.NavigateUrl = AboutUs1[0].linkYoutube.ToString();
}
if (string.IsNullOrEmpty(AboutUs1[0].linkGoogle.ToString()))
{
liGoogle.Visible = false;
}
else
{
hyperGoogle.NavigateUrl = AboutUs1[0].linkGoogle.ToString();
}
if (string.IsNullOrEmpty(AboutUs1[0].linkInsta.ToString()))
{
liInsta.Visible = false;
}
else
{
hyperInsta.NavigateUrl = AboutUs1[0].linkInsta.ToString();
}
if (string.IsNullOrEmpty(AboutUs1[0].linkTwitter.ToString()))
{
liTwitter.Visible = false;
}
else
{
hyperTwitter.NavigateUrl = AboutUs1[0].linkTwitter.ToString();
}
}
