private void loadprofile() { try { string loginid, usertyp; string username = StringCyper.Decrypt(Request.QueryString["id"], "devnagar"); usertyp = Session["UserType"].ToString(); if (Session["LoginUser"].ToString() != username) { // enable edit loginid = Session["LoginUser"].ToString(); } else { loginid = username; } // uncomment to use project gridview Connection.Open_Connection(con); cmd = new SqlCommand("spContractorGetProfile", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 30).Value = loginid; cmd.Parameters.Add("@UserType", SqlDbType.VarChar, 15).Value = usertyp; cmd.Parameters.Add("@Msg", SqlDbType.NVarChar, 255); cmd.Parameters["@Msg"].Direction = ParameterDirection.Output; SqlDataAdapter ad = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); ad.Fill(dt); if (dt.Rows.Count > 0) { DataRow rw = dt.Rows[0]; if (cmd.Parameters["@Msg"].Value.ToString() == "OK") { string usertype = Session["UserType"].ToString(); imgLogo.Src = "../" + rw["PhotoURL"].ToString(); flag.Attributes.Add("Class", "flag " + rw["CountryID"].ToString()); HiddenContractorID.Value = rw["ContractorID"].ToString(); if (usertype == "Hirer") { lblUsername.Text = rw["HirerName"].ToString() + " " + rw["HirerLastName"].ToString(); } else if (usertype == "Contractor") { lblUsername.Text = rw["FirstName"].ToString() + " " + rw["LastName"].ToString(); lblWorkTitle.Text = rw["JobTitle"].ToString(); // lblDescription.Text = rw["JobDescription"].ToString(); } } } } catch (Exception ex) { ex.ToString(); // ccl.ShowError(ex); } }
private void fill(DataTable dt) { var design = ""; int j = 1; int i = 0; while (i < dt.Rows.Count) { var html = ""; html += "<div class='row'>"; html += "<div class='grid cs-style-4'>"; try { if (string.IsNullOrEmpty(dt.Rows[i].ToString())) { } else { //string username = StringCyper.Encrypt(dt.Rows[i]["UserName"].ToString(), "devnagar"); string username = dt.Rows[i]["UserName"].ToString(); html += " <div class='span3'> "; html += "<div class='team-box thumbnail'>"; html += " <div class='bigbox'>"; html += " <div class='boxgrid captionfull'>"; html += " <a href='Portfolio.aspx?id=" + username + "'>"; html += " <img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' class='attachment-home-post-thumbnail wp-post-image' alt='Your Crews Home' title='Your Crews Home' height='197' width='292'>"; html += " <span style='top: 200px;' class='cover boxcaption'>"; html += " <span class='descr'>Slider Javascript</span>"; html += " <span class='title'>" + dt.Rows[i]["JobTitle"].ToString() + "</span>"; html += " <span class='caption'>House, Banglow</span>"; html += " </span>"; html += " </a>"; html += " </div>"; html += @" <span class='name'><b>"; html += dt.Rows[i]["FirstName"].ToString() + " " + dt.Rows[i]["LastName"].ToString(); html += @"</b></span>"; html += @" <div class='row-fluid nomargin'> <div class='span2'><img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' alt='img' class='boxbottm' /></div>"; html += @" <div class='span8'>Score: "; html += dt.Rows[i]["RatingPoints"].ToString(); html += @"<br /> <a href='#'><i class='icon-circled icon-star nomargin'></i> <i class='icon-circled icon icon-star'></i> <i class='icon-circled icon icon-star-half-empty'></i> <i class='icon-circled icon icon-star-half-empty'></i> <i class='icon-circled icon icon-star-empty'></i> </a> </div> <div class='span2' runat='server' id='varified' visible='false'>"; if (dt.Rows[i]["varified"].ToString() == "Yes") { html += @" <a href='#' class='verify'> <img src='images/verify.png' /> <span> <img class='callout' src='images/callout.gif' /> <strong>My Story</strong><br /> <i id='mystory' runat='server'></i> </span> </a>"; } html += @" </div> </div>"; html += " </div>"; html += "</div>"; html += "</div>"; } ///2 /// i++; if (string.IsNullOrEmpty(dt.Rows[i].ToString())) { } else { string username = dt.Rows[i]["UserName"].ToString(); html += " <div class='span3'> "; html += "<div class='team-box thumbnail'>"; html += " <div class='bigbox'>"; html += " <div class='boxgrid captionfull'>"; html += " <a href='Portfolio.aspx?id=" + username + "'>"; html += " <img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' class='attachment-home-post-thumbnail wp-post-image' alt='Your Crews Home' title='Your Crews Home' height='197' width='292'>"; html += " <span style='top: 200px;' class='cover boxcaption'>"; html += " <span class='descr'>Slider Javascript</span>"; html += " <span class='title'>" + dt.Rows[i]["JobTitle"].ToString() + "</span>"; html += " <span class='caption'>House, Banglow</span>"; html += " </span>"; html += " </a>"; html += " </div>"; html += @" <span class='name'><b>"; html += dt.Rows[i]["FirstName"].ToString() + " " + dt.Rows[i]["LastName"].ToString(); html += @"</b></span>"; html += @" <div class='row-fluid nomargin'> <div class='span2'><img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' alt='img' class='boxbottm' /></div>"; html += @" <div class='span8'>Score: "; html += dt.Rows[i]["RatingPoints"].ToString(); html += @"<br /> <a href='#'><i class='icon-circled icon-star nomargin'></i> <i class='icon-circled icon icon-star'></i> <i class='icon-circled icon icon-star-half-empty'></i> <i class='icon-circled icon icon-star-half-empty'></i> <i class='icon-circled icon icon-star-empty'></i> </a> </div> <div class='span2' runat='server' id='varified' visible='false'>"; if (dt.Rows[i]["varified"].ToString() == "Yes") { html += @" <a href='#' class='verify'> <img src='images/verify.png' /> <span> <img class='callout' src='images/callout.gif' /> <strong>My Story</strong><br /> <i id='mystory' runat='server'></i> </span> </a>"; } html += @" </div> </div>"; html += " </div>"; html += "</div>"; html += "</div>"; } ///3 /// i++; if (string.IsNullOrEmpty(dt.Rows[i].ToString())) { } else { string username = dt.Rows[i]["UserName"].ToString(); html += " <div class='span3'> "; html += "<div class='team-box thumbnail'>"; html += " <div class='bigbox'>"; html += " <div class='boxgrid captionfull'>"; html += " <a href='Portfolio.aspx?id=" + username + "'>"; html += " <img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' class='attachment-home-post-thumbnail wp-post-image' alt='Your Crews Home' title='Your Crews Home' height='197' width='292'>"; html += " <span style='top: 200px;' class='cover boxcaption'>"; html += " <span class='descr'>Slider Javascript</span>"; html += " <span class='title'>" + dt.Rows[i]["JobTitle"].ToString() + "</span>"; html += " <span class='caption'>House, Banglow</span>"; html += " </span>"; html += " </a>"; html += " </div>"; html += @" <span class='name'><b>"; html += dt.Rows[i]["FirstName"].ToString() + " " + dt.Rows[i]["LastName"].ToString(); html += @"</b></span>"; html += @" <div class='row-fluid nomargin'> <div class='span2'><img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' alt='img' class='boxbottm' /></div>"; html += @" <div class='span8'>Score: "; html += dt.Rows[i]["RatingPoints"].ToString(); html += @"<br /> <a href='#'><i class='icon-circled icon-star nomargin'></i> <i class='icon-circled icon icon-star'></i> <i class='icon-circled icon icon-star-half-empty'></i> <i class='icon-circled icon icon-star-half-empty'></i> <i class='icon-circled icon icon-star-empty'></i> </a> </div> <div class='span2' runat='server' id='varified' visible='false'>"; if (dt.Rows[i]["varified"].ToString() == "Yes") { html += @" <a href='#' class='verify'> <img src='images/verify.png' /> <span> <img class='callout' src='images/callout.gif' /> <strong>My Story</strong><br /> <i id='mystory' runat='server'></i> </span> </a>"; } html += @" </div> </div>"; html += " </div>"; html += "</div>"; html += "</div>"; ///4 /// } i++; if (string.IsNullOrEmpty(dt.Rows[i].ToString())) { } else { string username = StringCyper.Encrypt(dt.Rows[i]["UserName"].ToString(), "devnagar"); html += " <div class='span3'> "; html += "<div class='team-box thumbnail'>"; html += " <div class='bigbox'>"; html += " <div class='boxgrid captionfull'>"; html += " <a href='Portfolio.aspx?id=" + username + "'>"; html += " <img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' class='attachment-home-post-thumbnail wp-post-image' alt='Your Crews Home' title='Your Crews Home' height='197' width='292'>"; html += " <span style='top: 200px;' class='cover boxcaption'>"; html += " <span class='descr'>Slider Javascript</span>"; html += " <span class='title'>" + dt.Rows[i]["JobTitle"].ToString() + "</span>"; html += " <span class='caption'>House, Banglow</span>"; html += " </span>"; html += " </a>"; html += " </div>"; html += @" <span class='name'><b>"; html += dt.Rows[i]["FirstName"].ToString() + " " + dt.Rows[i]["LastName"].ToString(); html += @"</b></span>"; html += @" <div class='row-fluid nomargin'> <div class='span2'><img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' alt='img' class='boxbottm' /></div>"; html += @" <div class='span8'>Score: "; html += dt.Rows[i]["RatingPoints"].ToString(); html += @"<br /> <a href='#'><i class='icon-circled icon-star nomargin'></i> <i class='icon-circled icon icon-star'></i> <i class='icon-circled icon icon-star-half-empty'></i> <i class='icon-circled icon icon-star-half-empty'></i> <i class='icon-circled icon icon-star-empty'></i> </a> </div> <div class='span2' runat='server' id='varified' visible='false'>"; if (dt.Rows[i]["varified"].ToString() == "Yes") { html += @" <a href='#' class='verify'> <img src='images/verify.png' /> <span> <img class='callout' src='images/callout.gif' /> <strong>My Story</strong><br /> <i id='mystory' runat='server'></i> </span> </a>"; } html += @" </div> </div>"; html += " </div>"; html += "</div>"; html += "</div>"; } } catch (IndexOutOfRangeException ex) { } html += "</div></div>"; design += html; j++; i++; } if (dt.Rows.Count == 0) { var html = ""; html += "<div class='row'>"; html += "<div class='grid cs-style-4'>"; html += " <div class='span12'> "; html += "<div class='team-box thumbnail'>"; html += " <div class='bigbox'>"; html += "<h2>No Crew Found In Search</h2>"; html += "</div></div></div>"; html += "</div></div>"; design += html; } divProfile.InnerHtml = design; }
private void loadprofile() { using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Conn"])) { try { string loginid, usertyp; if (ccl.isLogedin() == true) { string username = StringCyper.Decrypt(Request.QueryString["id"], "devnagar"); usertyp = ccl.UserType(); if (Session["LoginUser"].ToString() == username) { // Login as Contractor (My Profile) loginid = Session["LoginUser"].ToString(); } else if (usertyp == "Contractor") { loginid = Session["LoginUser"].ToString(); } else { // Hirer loginid = username; if (loginid == "") { Response.Redirect("../ProfileHirer/ProfileHirer.aspx"); } } } else { loginid = StringCyper.Decrypt(Request.QueryString["id"], "devnagar"); if (loginid == "") { Response.Redirect("Default.aspx"); } usertyp = "Contractor"; // Visotor } // uncomment to use project gridview Connection.Open_Connection(con); cmd = new SqlCommand("spContractorGetProfile", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 30).Value = loginid; cmd.Parameters.Add("@UserType", SqlDbType.VarChar, 15).Value = "Contractor"; cmd.Parameters.Add("@Msg", SqlDbType.NVarChar, 255); cmd.Parameters["@Msg"].Direction = ParameterDirection.Output; SqlDataAdapter ad = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); ad.Fill(dt); if (dt.Rows.Count > 0) { DataRow rw = dt.Rows[0]; if (cmd.Parameters["@Msg"].Value.ToString() == "OK") { imgLogo.Src = "../" + rw["PhotoURL"].ToString(); flag.Attributes.Add("Class", "flag " + rw["CountryID"].ToString()); Hiddencontractorid.Value = rw["ContractorID"].ToString(); lblUsername.Text = rw["FirstName"].ToString() + " " + rw["LastName"].ToString(); lblWorkTitle.Text = rw["JobTitle"].ToString(); if (rw["Varified"].ToString() == "Yes") { mystory.InnerText = rw["Story"].ToString(); varified.Visible = true; } lblUsername.Text = rw["FirstName"].ToString() + " " + rw["LastName"].ToString(); lblWorkTitle.Text = rw["JobTitle"].ToString(); lblLocation.Text = rw["Location"].ToString(); lblAddress.Text = rw["Address"].ToString(); lblCityCountry.Text = rw["City"].ToString(); } } } catch (Exception ex) { ex.ToString(); // ccl.ShowError(ex); } } }
public void loadTeam() { Connection.Open_Connection(con); cmd = new SqlCommand("spLoadTeam", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CategoryID", SqlDbType.SmallInt).Value = Convert.ToInt32(Request.QueryString["cid"]); cmd.Parameters.Add("@Limit", SqlDbType.Int).Value = 40; cmd.ExecuteNonQuery(); SqlDataAdapter ad = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); ad.Fill(dt); var design = ""; int j = 1; int i = 0; while (i < dt.Rows.Count) { var html = ""; html += "<div class='row'>"; html += "<div class='grid cs-style-4'>"; try { if (string.IsNullOrEmpty(dt.Rows[i].ToString())) { } else { //string username = StringCyper.Encrypt(dt.Rows[i]["UserName"].ToString(), "devnagar"); string username = dt.Rows[i]["UserName"].ToString(); html += " <div class='span3'> "; html += "<div class='team-box thumbnail'>"; html += " <div class='bigbox'>"; html += " <div class='boxgrid captionfull'>"; html += " <a href='Portfolio.aspx?id=" + username + "'>"; html += " <img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' class='attachment-home-post-thumbnail wp-post-image' alt='Your Crews Home' title='Your Crews Home' height='197' width='292'>"; html += " <span style='top: 200px;' class='cover boxcaption'>"; html += " <span class='descr'>Slider Javascript</span>"; html += " <span class='title'>" + dt.Rows[i]["JobTitle"].ToString() + "</span>"; html += " <span class='caption'>House, Banglow</span>"; html += " </span>"; html += " </a>"; html += " </div>"; html += " <span class='boxbottm'>"; html += " <img src='#' alt='Img' />"; html += " <span class='name'>" + dt.Rows[i]["FirstName"].ToString() + " " + dt.Rows[i]["LastName"].ToString() + "</span>"; html += " <br />"; html += " <ul class='social-network nomargin'>"; html += " <li><a href='#' title='" + dt.Rows[i]["HoursBilled"].ToString() + "'><i class='icon-circled icon-time'></i></a></li>"; html += " <li><a href='#' title='" + dt.Rows[i]["RatingPoints"].ToString() + "'><i class='icon-circled icon-star-half-full'></i></a></li>"; html += " <li><a href='#' title='$-" + dt.Rows[i]["Rate"].ToString() + "'><i class='icon-circled icon-dollar'></i></a></li>"; html += " </ul>"; html += " </span>"; html += " </div>"; html += "</div>"; html += " </div>"; } ///2 /// i++; if (string.IsNullOrEmpty(dt.Rows[i].ToString())) { } else { string username = dt.Rows[i]["UserName"].ToString(); html += " <div class='span3'> "; html += "<div class='team-box thumbnail'>"; html += " <div class='bigbox'>"; html += " <div class='boxgrid captionfull'>"; html += " <a href='Portfolio.aspx?id=" + username + "'>"; html += " <img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' class='attachment-home-post-thumbnail wp-post-image' alt='Your Crews Home' title='Your Crews Home' height='197' width='292'>"; html += " <span style='top: 200px;' class='cover boxcaption'>"; html += " <span class='descr'>Slider Javascript</span>"; html += " <span class='title'>" + dt.Rows[i]["JobTitle"].ToString() + "</span>"; html += " <span class='caption'>House, Banglow</span>"; html += " </span>"; html += " </a>"; html += " </div>"; html += " <span class='boxbottm'>"; html += " <img src='#' alt='Img' />"; html += " <span class='name'>" + dt.Rows[i]["FirstName"].ToString() + " " + dt.Rows[i]["LastName"].ToString() + "</span>"; html += " <br />"; html += " <ul class='social-network nomargin'>"; html += " <li><a href='#' title='" + dt.Rows[i]["HoursBilled"].ToString() + "'><i class='icon-circled icon-time'></i></a></li>"; html += " <li><a href='#' title='" + dt.Rows[i]["RatingPoints"].ToString() + "'><i class='icon-circled icon-star-half-full'></i></a></li>"; html += " <li><a href='#' title='$-" + dt.Rows[i]["Rate"].ToString() + "'><i class='icon-circled icon-dollar'></i></a></li>"; html += " </ul>"; html += " </span>"; html += " </div>"; html += "</div>"; html += " </div>"; } ///3 /// i++; if (string.IsNullOrEmpty(dt.Rows[i].ToString())) { } else { string username = dt.Rows[i]["UserName"].ToString(); html += " <div class='span3'> "; html += "<div class='team-box thumbnail'>"; html += " <div class='bigbox'>"; html += " <div class='boxgrid captionfull'>"; html += " <a href='Portfolio.aspx?id=" + username + "'>"; html += " <img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' class='attachment-home-post-thumbnail wp-post-image' alt='Your Crews Home' title='Your Crews Home' height='197' width='292'>"; html += " <span style='top: 200px;' class='cover boxcaption'>"; html += " <span class='descr'>Slider Javascript</span>"; html += " <span class='title'>" + dt.Rows[i]["JobTitle"].ToString() + "</span>"; html += " <span class='caption'>House, Banglow</span>"; html += " </span>"; html += " </a>"; html += " </div>"; html += " <span class='boxbottm'>"; html += " <img src='#' alt='Img' />"; html += " <span class='name'>" + dt.Rows[i]["FirstName"].ToString() + " " + dt.Rows[i]["LastName"].ToString() + "</span>"; html += " <br />"; html += " <ul class='social-network nomargin'>"; html += " <li><a href='#' title='" + dt.Rows[i]["HoursBilled"].ToString() + "'><i class='icon-circled icon-time'></i></a></li>"; html += " <li><a href='#' title='" + dt.Rows[i]["RatingPoints"].ToString() + "'><i class='icon-circled icon-star-half-full'></i></a></li>"; html += " <li><a href='#' title='$-" + dt.Rows[i]["Rate"].ToString() + "'><i class='icon-circled icon-dollar'></i></a></li>"; html += " </ul>"; html += " </span>"; html += " </div>"; html += "</div>"; html += " </div>"; ///4 /// } i++; if (string.IsNullOrEmpty(dt.Rows[i].ToString())) { } else { string username = StringCyper.Encrypt(dt.Rows[i]["UserName"].ToString(), "devnagar"); html += " <div class='span3'> "; html += "<div class='team-box thumbnail'>"; html += " <div class='bigbox'>"; html += " <div class='boxgrid captionfull'>"; html += " <a href='Portfolio.aspx?id=" + username + "'>"; html += " <img src='" + dt.Rows[i]["PhotoURL"].ToString() + "' class='attachment-home-post-thumbnail wp-post-image' alt='Your Crews Home' title='Your Crews Home' height='197' width='292'>"; html += " <span style='top: 200px;' class='cover boxcaption'>"; html += " <span class='descr'>Slider Javascript</span>"; html += " <span class='title'>" + dt.Rows[i]["JobTitle"].ToString() + "</span>"; html += " <span class='caption'>House, Banglow</span>"; html += " </span>"; html += " </a>"; html += " </div>"; html += " <span class='boxbottm'>"; html += " <img src='#' alt='Img' />"; html += " <span class='name'>" + dt.Rows[i]["FirstName"].ToString() + " " + dt.Rows[i]["LastName"].ToString() + "</span>"; html += " <br />"; html += " <ul class='social-network nomargin'>"; html += " <li><a href='#' title='" + dt.Rows[i]["HoursBilled"].ToString() + "'><i class='icon-circled icon-time'></i></a></li>"; html += " <li><a href='#' title='" + dt.Rows[i]["RatingPoints"].ToString() + "'><i class='icon-circled icon-star-half-full'></i></a></li>"; html += " <li><a href='#' title='$-" + dt.Rows[i]["Rate"].ToString() + "'><i class='icon-circled icon-dollar'></i></a></li>"; html += " </ul>"; html += " </span>"; html += " </div>"; html += "</div>"; html += " </div>"; } } catch (IndexOutOfRangeException ex) { } html += "</div></div>"; design += html; j++; i++; } divProfile.InnerHtml = design; //HtmlGenericControl mydiv = (HtmlGenericControl)contractordesing; //mydiv.InnerHtml = design; Connection.Close_Connection(con); }
private string loadprofile() { using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Conn"])) { string contractorid = "0"; try { ccl = new CommanClass(); string loginid, usertyp; if (ccl.isLogedin() == true) { usertyp = ccl.UserType(); if (usertyp == "Contractor") { loginid = Session["LoginUser"].ToString(); } else { loginid = Session["LoginUser"].ToString(); } } else { loginid = StringCyper.Decrypt(Request.QueryString["id"], "devnagar"); if (loginid == "") { Response.Redirect("Default.aspx"); } usertyp = "Contractor"; // Visotor } // uncomment to use project gridview Connection.Open_Connection(con); cmd = new SqlCommand("spContractorGetProfile", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 30).Value = loginid; cmd.Parameters.Add("@UserType", SqlDbType.VarChar, 15).Value = "Contractor"; cmd.Parameters.Add("@Msg", SqlDbType.NVarChar, 255); cmd.Parameters["@Msg"].Direction = ParameterDirection.Output; SqlDataAdapter ad = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); ad.Fill(dt); if (dt.Rows.Count > 0) { DataRow rw = dt.Rows[0]; if (cmd.Parameters["@Msg"].Value.ToString() == "OK") { HiddenContractorID.Value = rw["Membership"].ToString(); lblTitle.Text = HiddenContractorID.Value + " Contractor Account"; } } dt.Clear(); dt.Dispose(); ad.Dispose(); cmd.Dispose(); Connection.Close_Connection(con); } catch (Exception ex) { ex.ToString(); // ccl.ShowError(ex); } return(contractorid); } }
protected void ibtnSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e) { Response.Redirect("~/ProfileContractor/FindJob.aspx?category=" + StringCyper.Encrypt(ddlCategory.SelectedValue, "devnagar")); }