protected void Page_Load(object sender, EventArgs e)
{
try
{
int id = 0;
if (Request.QueryString["product"].Length > 0)
{
id = Convert.ToInt32(Request.QueryString["product"]);
}
string strConn = null;
strConn = GetConnection.GetConnectionStringByName();
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("select DataSheetUrl,TitlePr,InfoPr from chproduct where ID=@ID", conn);
SqlDataReader sdr;
try
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ID", id);
cmd.Connection = conn;
conn.Open();
sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
while (sdr.Read())
{
if (sdr["DataSheetUrl"].ToString() == "-1")
{
dataSheetDowloadLink.Visible = false;
}
else
{
dataSheetDowloadLink.Visible = true;
dataSheetDowloadLink.Text = "download datasheet";
dataSheetDowloadLink.NavigateUrl = "DataSheet/" + sdr["DataSheetUrl"].ToString();
}
lblTitle.Text = sdr["TitlePr"].ToString();
ltrContent.Text = sdr["InfoPr"].ToString();
}
}
}
catch (Exception ex)
{
ltrContent.Text = ex.Message;
}
}
catch
{
Response.Redirect("ugc.aspx");
}
}
protected string TextLiteral()
{
string str = "";
string strConn = null;
strConn = GetConnection.GetConnectionStringByName();
SqlConnection conn = new SqlConnection(strConn);
try
{
string query = "select * from tbl_Image where AlbumID=@AlbumID";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader sdr;
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@AlbumID", Request.QueryString["AlbumID"].ToString());
conn.Open();
sdr = cmd.ExecuteReader();
string name_temp;
if (sdr.HasRows)
{
while (sdr.Read())
{
name_temp = sdr["ImageName"].ToString();
string thumb = sdr["Thumb"].ToString();
string temp_image_url = sdr["ImageUrl"].ToString();
if (temp_image_url == "")
{
temp_image_url = "/image/";
}
string[] array = new string[2];
str += "<div style='width:200px;height:170px;overflow:hidden;float:left;border:#CCC double thick; border-radius:10px;margin-left:65px;margin-bottom:50px'> <a class=\"vlightbox1\" href='" + temp_image_url + "' style='' title='" + name_temp + "'> <img src='" + thumb + "' style='opacity: 1;' /> </a></div>";
}
}
}
catch (Exception ex)
{
string stri = ex.Message;
Response.Redirect("AlbumFarsi.aspx");
}
finally
{
conn.Close();
}
return(str);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request.QueryString["ChemixId"] == "")
{
Response.Redirect("www.chemixco.com");
}
else
{
string strConn = null;
strConn = GetConnection.GetConnectionStringByName();
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("Select PageContent from chcms where Id=@Id", conn);
SqlDataReader sdr;
try
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Id", Request.QueryString["ChemixId"]);
cmd.Connection = conn;
conn.Open();
sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
while (sdr.Read())
{
ltrContent.Text = sdr["PageContent"].ToString();
}
}
}
catch (Exception ex)
{
}
finally
{
cmd.Dispose();
conn.Close();
}
}
}
catch
{
Response.Redirect("www.chemixco.com");
}
}
public string SelectDescription()
{
string str = null;
string strConn = null;
strConn = GetConnection.GetConnectionStringByName();
SqlConnection conn = new SqlConnection(strConn);
try
{
string query = "SELECT [Desc] FROM [dbo].[About] Where elanguage=2";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader sdr;
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
conn.Open();
sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
while (sdr.Read())
{
str = Server.HtmlDecode(sdr["Desc"].ToString());
}
}
}
catch (Exception ex)
{
string st = ex.Message;
}
finally
{
conn.Close();
}
return(str);
}
