protected void LoadSiteContact()
{
Footer footer = new Footer();
DataSet dsContact = new DataSet();
StringBuilder sb = new StringBuilder();
dsContact = footer.GetAllSiteContact();
foreach (DataTable table in dsContact.Tables)
{
foreach (DataRow row in table.Rows)
{
sb.AppendLine("<img src='" + Global.globalSiteImagesPath + "/" + row["SiteContImage"].ToString() + "' width='78' height='36' />");
sb.AppendLine("<h3>" + row["SiteContTitle"].ToString() + "</h3>");
sb.AppendLine("<p>" + row["SiteContAddress"].ToString() + "</p>");
sb.AppendLine("<h3>Email</h3>");
sb.AppendLine("<p><span>Customer Service:</span> <a href='mailto:" + row["SiteContEmailCus"].ToString() + "'>" + row["SiteContEmailCus"].ToString() + "</a>");
sb.AppendLine("<br />");
sb.AppendLine("<span>Sales:</span> <a href='mailto:" + row["SiteContEmailSal"].ToString() + "'>" + row["SiteContEmailSal"].ToString() + "</a>");
sb.AppendLine("</p>");
break;
}
}
PlaceHolder_SiteContact.Controls.Add(new LiteralControl(sb.ToString()));
sb = null;
}
protected void LoadSiteContact()
{
Footer footer = new Footer();
DataSet dsContact = new DataSet();
DataSet dsSite = new DataSet();
dsContact = footer.GetAllSiteContact();
dsSite = footer.GetSiteInformation();
foreach (DataTable table in dsContact.Tables)
{
foreach (DataRow row in table.Rows)
{
SiteContTitle = row["SiteContTitle"].ToString();
SiteContAddress = row["SiteContAddress"].ToString();
SiteContEmailCus = row["SiteContEmailCus"].ToString();
SiteContEmailSal = row["SiteContEmailSal"].ToString();
}
}
foreach (DataTable table in dsSite.Tables)
{
foreach (DataRow row in table.Rows)
{
SiteConPhone = row["sitephone"].ToString();
SiteCopy = row["sitecopy"].ToString();
SiteURL = row["siteurl"].ToString();
SiteTagLine = row["sitetagline"].ToString();
}
}
}
//--
protected void Page_Load(object sender, EventArgs e)
{
intSite = Convert.ToInt32(HttpContext.Current.Session["SiteId"].ToString());
intCont = Convert.ToInt32(HttpContext.Current.Session["ContentId"].ToString());
Footer footer = new Footer();
DataSet dsContact = new DataSet();
DataSet dsSite = new DataSet();
dsContact = footer.GetAllSiteContact();
dsSite = footer.GetSiteInformation();
foreach (DataTable table in dsContact.Tables)
{
foreach (DataRow row in table.Rows)
{
SiteContTitle = row["SiteContTitle"].ToString();
SiteContAddress = row["SiteContAddress"].ToString();
SiteContEmailCus = row["SiteContEmailCus"].ToString();
SiteContEmailSal = row["SiteContEmailSal"].ToString();
}
}
foreach (DataTable table in dsSite.Tables)
{
foreach (DataRow row in table.Rows)
{
SiteConPhone = row["sitephone"].ToString();
SiteCopy = row["sitecopy"].ToString();
SiteURL = row["siteurl"].ToString();
SiteTagLine = row["sitetagline"].ToString();
}
}
LoadContact();
}
protected void LoadSiteContact()
{
Footer footer = new Footer();
DataSet dsContact = new DataSet();
StringBuilder sb = new StringBuilder();
dsContact = footer.GetAllSiteContact();
string path = "";
foreach (DataTable table in dsContact.Tables)
{
foreach (DataRow row in table.Rows)
{
if(!Regex.IsMatch(row["SiteContImage"].ToString(), @"^(ft|htt)p(s?)://([\w-]+\.)+[\w-]+(/[\w- ./]*)+\.(?:gif|jpg|jpeg|png|GIF|JPEG|JPG|PNG|Gif|Jpg|Jpeg|Png)$"))
{
path = Global.globalSiteImagesPath + "/";
}else{
path = "";
}
Session["siteCustEmail"] = row["SiteContEmailCus"].ToString();
sb.AppendLine("<h4><img title=\""+row["SiteContTitle"].ToString()+"\" src=\"" + path + row["SiteContImage"].ToString() + "\" width=\"91\" height=\"36\" /></h4>");
sb.AppendLine("<div>");
sb.AppendLine("<h3>" + row["SiteContTitle"].ToString() + "</h3>");
sb.AppendLine("<p>" + row["SiteContAddress"].ToString() + "</p>");
sb.AppendLine("<h3>Email</h3>");
sb.AppendLine("<p><span>Customer Service:</span> <a href='mailto:" + row["SiteContEmailCus"].ToString() + "'>" + row["SiteContEmailCus"].ToString() + "</a>");
sb.AppendLine("<br />");
sb.AppendLine("<span>Sales:</span> <a href='mailto:" + row["SiteContEmailSal"].ToString() + "'>" + row["SiteContEmailSal"].ToString() + "</a>");
sb.AppendLine("</p>");
sb.AppendLine("</div>");
//break;
}
}
PlaceHolder_SiteContact.Controls.Add(new LiteralControl(sb.ToString()));
sb = null;
}
