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 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);
}
}
}
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);
}
}
