public string GetCompanyFromRole(string role, bool dummy)
{
string ret = "";
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.AuthConn();
SqlCommand cmdI = new SqlCommand("SELECT * FROM Company WHERE RoleLink ='" + role + "'", con);
cmdI.Connection.Open();
SqlDataReader drI = cmdI.ExecuteReader();
if (drI.HasRows)
{
while (drI.Read())
{
ret = drI["RoleLink"].ToString();
}
}
drI.Close();
con.Close();
drI.Dispose();
con.Dispose();
return(ret);
}
public void GetClientId(string UserName)
{
string ClientId = "";
MembershipUser user = Membership.GetUser(UserName);
Guid guid = (Guid)user.ProviderUserKey;
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.AuthConn();
SqlCommand cmdI = new SqlCommand("SELECT ClientId FROM Users WHERE UserId='" + guid + "'", con);
cmdI.Connection.Open();
SqlDataReader drI = cmdI.ExecuteReader();
if (drI.HasRows)
{
while (drI.Read())
{
ClientId = drI["ClientId"].ToString();
}
}
drI.Close();
con.Close();
drI.Dispose();
con.Dispose();
HttpContext.Current.Session["ClientId"] = ClientId;
}
public int GetCompanyFromRole(string role)
{
int ret = 0;
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.AuthConn();
SqlCommand cmdI = new SqlCommand("SELECT * FROM Company WHERE RoleLink ='" + role + "'", con);
cmdI.Connection.Open();
SqlDataReader drI = cmdI.ExecuteReader();
if (drI.HasRows)
{
while (drI.Read())
{
ret = Convert.ToInt32(drI["CompanyID"]);
}
}
drI.Close();
con.Close();
drI.Dispose();
con.Dispose();
return(ret);
}
public string GetUsername(int id)
{
string ret = "";
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.AuthConn();
SqlCommand cmdI = new SqlCommand("SELECT aU.UserName FROM Users U INNER JOIN aspnet_Users aU ON U.UserId = aU.UserId WHERE U.UsersId = " + id, con);
cmdI.Connection.Open();
SqlDataReader drI = cmdI.ExecuteReader();
if (drI.HasRows)
{
while (drI.Read())
{
ret = drI["UserName"].ToString();
}
}
drI.Close();
con.Close();
drI.Dispose();
con.Dispose();
return ret;
}
public string InsertUserSchool(Guid UserId, int ClientId)
{
string strReturn = "";
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.AuthConn();
SqlCommand cmdI = new SqlCommand("INSERT INTO Users VALUES ('" + UserId + "'," + ClientId + ")", con);
cmdI.Connection.Open();
cmdI.ExecuteNonQuery();
con.Close();
con.Dispose();
return strReturn;
}