public void loadCompanies()
{
DBFilter filter = new DBFilter();
DataTable table = ECompany.db.loadDataSet(dbConn, null, filter);
DataView view = new DataView(table);
Companies.DataSource = view;
Companies.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["Login"];
HttpCookie access = Request.Cookies["Access"];
if (cookie == null || access == null || access.Value.Equals("4"))
{
Response.Redirect("index.aspx");
return;
}
string login = cookie.Value;
int hierarchy = 4;
int comp = 0;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbThermalCat"].ToString())){
try {
cn.Open();
SqlCommand cmd = new SqlCommand("SELECT tbUsuario.nome, tbUsuario.sobrenome, tbUsuario.idAcesso, tbUsuario.idAfiliacao, tbAcesso.hierarquia, tbAfiliacao.nome FROM tbUsuario, tbAcesso, tbAfiliacao WHERE tbUsuario.id=@id and tbUsuario.idAcesso=tbAcesso.id and tbAfiliacao.id=tbUsuario.idAfiliacao", cn);
cmd.Parameters.AddWithValue("@id", login);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
string nome = sdr.GetValue(sdr.GetOrdinal("nome")).ToString() + " " + sdr.GetValue(sdr.GetOrdinal("sobrenome")).ToString();
UserName.Text = nome;
UserAccess.Text = sdr.GetValue(sdr.GetOrdinal("hierarquia")).ToString();
Empresa.Text = sdr.GetValue(5).ToString();
StringBuilder reg = new StringBuilder();
reg.Append(@"
<i id='UserForm' class='fa fa-user'> | Usuário</i>
");
if (!sdr.GetValue(sdr.GetOrdinal("idAcesso")).ToString().Equals("4"))
{
StringBuilder strScript = new StringBuilder();
strScript.Append(@"
<button id='AddUser' class='fa fa-plus-circle' data-toggle='tooltip' data-placement='bottom' title='Cadastrar'></button>
<button id='EditUser' class='fa fa-pencil' data-toggle='tooltip' data-placement='bottom' title='Editar'></button>
<button id='DeleteUser' class='fa fa-trash' data-toggle='tooltip' data-placement='bottom' title='Deletar'></button>
");
ltScripts.Text = strScript.ToString();
}
if (sdr.GetValue(sdr.GetOrdinal("idAcesso")).ToString().Equals("1"))
{
reg.Append(@"
<i id='CompanyForm' class='fa fa-building'> | Empresa</i>
<i id='SensorForm' class='fa fa-thermometer'> | Sensor </i>
");
}
RegMenus.Text = reg.ToString();
hierarchy = sdr.GetInt32(sdr.GetOrdinal("idAcesso"));
comp = sdr.GetInt32(sdr.GetOrdinal("idAfiliacao"));
}
} catch (Exception ex) {
Response.Write(ex.Message);
} finally {
cn.Close();
};
try {
cn.Open();
SqlCommand cmd;
if (hierarchy.Equals(1))
{
cmd = new SqlCommand("SELECT * FROM tbAfiliacao", cn);
}
else
{
cmd = new SqlCommand("SELECT * FROM tbAfiliacao WHERE tbAfiliacao.id = @afiliacao", cn);
cmd.Parameters.AddWithValue("@afiliacao", comp);
}
Companies.DataSource = cmd.ExecuteReader();
Companies.DataTextField = "nome";
Companies.DataValueField = "id";
Companies.DataBind();
} catch (Exception ex) {
Response.Write(ex.Message);
} finally {
cn.Close();
};
try {
cn.Open();
SqlCommand cmd;
if (!hierarchy.Equals(1))
{
cmd = new SqlCommand("SELECT * FROM tbAcesso where id>@hierarquia order by id desc", cn);
cmd.Parameters.AddWithValue("@hierarquia", hierarchy);
}
else
{
cmd = new SqlCommand("SELECT * FROM tbAcesso order by id desc", cn);
}
AccessLevel.DataSource = cmd.ExecuteReader();
AccessLevel.DataTextField = "hierarquia";
AccessLevel.DataValueField = "id";
AccessLevel.DataBind();
} catch (Exception ex) {
Response.Write(ex.Message);
} finally {
cn.Close();
};
}
if (AccessLevel.SelectedIndex == -1)
{
AccessLevel.SelectedIndex = 0;
}
if (IsPostBack == false)
{
int id;
if (int.TryParse(Request.QueryString["id"], out id) == false)
{
lblMsg.Text = "Id inválido!";
return;
}
// Cria e abre a conexão com o banco de dados
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbThermalCat"].ToString())) {
conn.Open();
// Cria um comando para selecionar registros da tabela
using (SqlCommand cmd = new SqlCommand("SELECT nomeUsuario, nome, sobrenome, senha, email, idAfiliacao, idAcesso FROM tbUsuario WHERE id = @id", conn)) {
cmd.Parameters.AddWithValue("@id", id);
using (SqlDataReader reader = cmd.ExecuteReader()) {
// Tenta obter o registro
if (reader.Read() == true)
{
Login.Text = reader.GetString(0);
FirstName.Text = reader.GetString(1);
LastName.Text = reader.GetString(2);
Pass.Text = reader.GetString(3);
ConfirmPass.Text = reader.GetString(3);
Email.Text = reader.GetString(4);
Companies.SelectedValue = reader.GetInt32(5).ToString();
AccessLevel.SelectedValue = reader.GetInt32(6).ToString();
}
else
{
lblMsg.Text = "Id não encontrado!";
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["Login"];
HttpCookie access = Request.Cookies["Access"];
if (cookie == null || access == null || !access.Value.Equals("1"))
{
Response.Redirect("index.aspx");
return;
}
string id = cookie.Value;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbThermalCat"].ToString())){
try {
cn.Open();
SqlCommand cmd = new SqlCommand("SELECT tbUsuario.nome, tbUsuario.sobrenome, tbUsuario.idAcesso, tbAcesso.hierarquia, tbAfiliacao.nome FROM tbUsuario, tbAcesso, tbAfiliacao WHERE tbUsuario.id=@id and tbUsuario.idAcesso=tbAcesso.id and tbAfiliacao.id=tbUsuario.idAfiliacao", cn);
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
string nome = sdr.GetValue(sdr.GetOrdinal("nome")).ToString() + " " + sdr.GetValue(sdr.GetOrdinal("sobrenome")).ToString();
UserName.Text = nome;
UserAccess.Text = sdr.GetValue(sdr.GetOrdinal("hierarquia")).ToString();
Empresa.Text = sdr.GetValue(4).ToString();
StringBuilder reg = new StringBuilder();
reg.Append(@"
<i id='UserForm' class='fa fa-user'> | Usuário</i>
");
if (!sdr.GetValue(sdr.GetOrdinal("idAcesso")).ToString().Equals("4"))
{
StringBuilder strScript = new StringBuilder();
strScript.Append(@"
<button id='AddUser' class='fa fa-plus-circle' data-toggle='tooltip' data-placement='bottom' title='Cadastrar'></button>
<button id='EditUser' class='fa fa-pencil' data-toggle='tooltip' data-placement='bottom' title='Editar'></button>
<button id='DeleteUser' class='fa fa-trash' data-toggle='tooltip' data-placement='bottom' title='Deletar'></button>
");
ltScripts.Text = strScript.ToString();
}
if (sdr.GetValue(sdr.GetOrdinal("idAcesso")).ToString().Equals("1"))
{
reg.Append(@"
<i id='CompanyForm' class='fa fa-building'> | Empresa</i>
<i id='SensorForm' class='fa fa-thermometer'> | Sensor </i>
");
}
RegMenus.Text = reg.ToString();
}
} catch (Exception ex) {
Response.Write(ex.Message);
} finally {
cn.Close();
};
try {
cn.Open();
SqlCommand cmd;
cmd = new SqlCommand("SELECT * FROM tbAfiliacao", cn);
Companies.DataSource = cmd.ExecuteReader();
Companies.DataTextField = "nome";
Companies.DataValueField = "id";
Companies.DataBind();
} catch (Exception ex) {
Response.Write(ex.Message);
} finally {
cn.Close();
};
Companies.Items.Insert(0, new ListItem("Selecione uma empresa", "0"));
}
}