protected void CarregarSetor()
{
DataSet ds = new DataSet();
ds = SetorDB.CountSetor();
foreach (DataRow dr in ds.Tables[0].Rows)
{
lblSetor.Text += "<p/><div class='animated flipInY col-lg-3 col-md-3 col-sm-12 col-xs-12'>" +
"<div class='tile-stats media event'>" +
"<a class='pull-right border-aero profile_thumb'>" +
"<i class='blue fa fa-tasks'></i><span class='left badge bg-blue'>" + dr["count(set_cod)"] + "</span>" +
"</a>" +
"<center><br/><h3><a class='title blue' href='../paginas/ConsultaSetor.aspx'>Setor</a></h3><center><br/>" +
"</div>" +
"</div>";
//lblSetor.Text += "<div class='animated flipInY col-lg-3 col-md-3 col-sm-6 col-xs-12'>" +
// "<div class='tile-stats'>" +
// "<div class='icon'>" +
// "<i class='fa fa-bank'></i>" +
// "</div>" +
// "<div class='count'>" + dr["count(set_cod)"] + "</div>" +
// "<h3><a href='../paginas/ConsultaSetor.aspx'>Setor</a></h3>" +
// "<p></p>" +
// "</div>" +
// "</div>";
}
}
public static void Desativar(int fun, string codigo)
{
Setor set = new Setor();
set.Set_cod = Convert.ToInt32(codigo);
set.Cod_fun = fun;
SetorDB.Excluir(set);
}
protected void CarregarSetor()
{
DataSet ds = new DataSet();
ds = SetorDB.SelectAll();
ddlSetor.DataSource = ds;
ddlSetor.DataTextField = "set_nome";
ddlSetor.DataValueField = "set_cod";
ddlSetor.DataBind();
ddlSetor.Items.Insert(0, "Selecione...");
}
protected void CarregarDrop()
{
DataSet ds = new DataSet();
ds = SetorDB.SelectAllAtivo();
ddlLocal.DataSource = ds;
ddlLocal.DataTextField = "set_nome";
ddlLocal.DataValueField = "set_cod";
ddlLocal.DataBind();
ddlLocal.Items.Insert(0, "Selecione...");;
}
protected void Page_Load(object sender, EventArgs e)
{
FunMod fmp = (FunMod)Session["funcionario"];
if (Session["funcionario"] != null)
{
if (!Page.IsPostBack)
{
DataSet ds1 = new DataSet();
string pagina = "";
int n = 0;
ds1 = FunModDB.SelectMenu(fmp.Funcionario.Fun_cod);
foreach (DataRow dr in ds1.Tables[0].Rows)
{
pagina = dr["mod_pagina"].ToString();
if (pagina == "ExcluirSetor.aspx")
{
n = 1;
}
}
if (n != 1)
{
Response.Redirect("~/paginas/Erro/Erro404.aspx");
}
if (Request.QueryString["par"] != null)
{
if (Request.QueryString["par"].ToString() != "")
{
string valor = Request.QueryString["par"].ToString().Replace(" ", "+");
int n1 = Convert.ToInt32(Funcoes.AESDecodifica(valor));
Setor set = SetorDB.Select(n1);
txbCodigo.Text = Convert.ToString(set.Set_cod);
txbDesc.Text = Convert.ToString(set.Set_descricao);
txbNome.Text = Convert.ToString(set.Set_nome);
txbNomeDepar.Text = set.Departamento.Dep_nome;
}
}
}
}
else
{
Session["info"] = null;
Response.Redirect("~/paginas/Login.aspx");
}
}
protected void CarregarSetor(int fun_cod)
{
Funcionario fun = FuncionarioDB.Select(fun_cod);
DataSet ds = new DataSet();
if (fun.Perfil.Pfl_descricao == "Administrador")
{
ds = SetorDB.SelectAllAdministrador();
}
else
{
ds = SetorDB.SelectAll();
}
ddlSetor.DataSource = ds;
ddlSetor.DataTextField = "set_nome";
ddlSetor.DataValueField = "set_cod";
ddlSetor.DataBind();
ddlSetor.Items.Insert(0, "Selecione...");
}
protected void CarregarSetorInativo()
{
DataSet ds = new DataSet();
ds = SetorDB.CountSetorInativo();
foreach (DataRow dr in ds.Tables[0].Rows)
{
lblSetorInativo.Text += "<div class='animated flipInY col-lg-3 col-md-3 col-sm-6 col-xs-12'>" +
"<div class='tile-stats'>" +
"<div class='icon'>" +
"<i class='fa fa-tasks'></i>" +
"</div>" +
"<div class='count'>" + dr["count(set_cod)"] + "</div>" +
"<h3><a href='../paginas/ConsultaSetor.aspx?par=" +
Funcoes.AESCodifica("Inativo") + "'>Setor</a></h3>" +
"<p></p>" +
"</div>" +
"</div>";
}
}
protected void btnApagar_Click(object sender, EventArgs e)
{
Setor set = new Setor();
set.Set_cod = Convert.ToInt32(txbCodigo.Text);
set.Set_nome = txbNome.Text;
set.Set_descricao = txbDesc.Text;
switch (SetorDB.Excluir(set))
{
case 0:
Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script>sucess();</script>", false);
txbNome.Text = "";
txbDesc.Text = "";
txbCodigo.Text = "";
txbNomeDepar.Text = "";
break;
case -2:
Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script>error();</script>", false);
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
FunMod fmp = (FunMod)Session["funcionario"];
if (Session["funcionario"] != null)
{
if (!Page.IsPostBack)
{
DataSet ds1 = new DataSet();
string pagina = "";
int n = 0;
ds1 = FunModDB.SelectMenu(fmp.Funcionario.Fun_cod);
foreach (DataRow dr in ds1.Tables[0].Rows)
{
pagina = dr["mod_pagina"].ToString();
if (pagina == "ConsultaSetor.aspx")
{
n = 1;
}
}
if (n != 1)
{
Response.Redirect("~/paginas/Erro/Erro404.aspx");
}
string ativo = "";
if (Request.QueryString["par"] != null && Request.QueryString["par"] != "")
{
ativo = "Inativo";
}
else
{
ativo = "Ativo";
}
DataSet ds = new DataSet();
ds = SetorDB.Consulta(ativo);
foreach (DataRow dr in ds.Tables[0].Rows)
{
string atualizar = "";
string desativar = "";
string ativar = "";
if (Convert.ToString(dr["set_ativo"]) != "Inativo")
{
ds = ModuloDB.ModuloUsuario(fmp.Funcionario.Fun_cod);
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
if (dr1["mod_descricao"].Equals("Editar Setor"))
{
atualizar = "<a href='../paginas/AlterarSetor.aspx?str=" + Funcoes.AESCodifica(Convert.ToString(dr["set_cod"])) + "&dto=" + Funcoes.AESCodifica(Convert.ToString(dr["dep_cod"])) + "'>" +
"<button type='button' class='btn btn-primary btn-xs'>" +
" <i class='fa fa-edit'></i> Atualizar" +
"</button>" +
"</a>";
break;
}
}
foreach (DataRow dr2 in ds.Tables[0].Rows)
{
if (dr2["mod_descricao"].Equals("Desativar Setor"))
{
desativar += "<button type='button' class='btn btn-primary btn-xs' data-toggle='modal' data-target='#myModalDesativar'>" +
" <i class='fa fa-trash'></i> Excluir" +
"</button>";
break;
}
}
}
else
{
ds = ModuloDB.ModuloUsuario(fmp.Funcionario.Fun_cod);
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
if (dr1["mod_descricao"].Equals("Editar Departamento"))
{
ativar = "<button type='button' class='btn btn-primary btn-xs' data-toggle='modal' data-target='#myModalAtivar'>" +
" <i class='fa fa-check-circle'></i> Ativar" +
"</button>";
break;
}
}
}
ds = SetorDB.Consulta(ativo);
lbl.Text += "<div class='col-md-4 col-sm-4 col-xs-12 animated fadeInDown'>" +
"<div class='well profile_view'>" +
"<div class='col-sm-12'>" +
"<div class='left col-xs-12'>" +
"<h2>" + dr["set_nome"] + "</h2>" +
"<ul class='list-unstyled'>" +
"<li>Codigo: " + dr["set_cod"] + "</li>" +
"<li>Departamento: " + dr["dep_nome"] + "</li>" +
"<li>Descrição: " + dr["set_descricao"] + "</li>" +
"<li><i class='fa fa-user'></i> Chefe do Setor: " + dr["nome"] + "</li>" +
"<li>Matrícula: " + dr["matricula"] + " </li> " +
"<br /><br />" +
"</ul>" +
"</div>" +
"</div>" +
"<div class='col-xs-12 bottom text-center'>" +
atualizar + desativar + ativar +
"</div>" +
"</div>" +
"</div>" +
"<div class='modal fade' id='myModalDesativar' tabindex='- 1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>" +
"<div class='modal-dialog' role='document'>" +
"<div class='modal-content'>" +
"<div class='modal-header'>" +
"<button type='button' class='close' data-dismiss='modal' aria-label='Close'>" +
"<span aria-hidden='true'>×</span>" +
"</button>" +
"<h3 class='modal-title red' id='myModalLabel'>Aviso!</h3>" +
"</div>" +
"<div class='modal-body'>" +
"<h2 class='text-center'>Tem certeza que deseja Excluir?</h2>" +
"</div>" +
"<div class='divider'></div>" +
"<div class='col-xs-12 bottom text-right'>" +
"<button type='button' class='btn btn-default' data-dismiss='modal'>Não</button>" +
"<button type='button' class='btn btn-danger' onclick='desativar(" + dr["set_cod"] + ", " + fmp.Funcionario.Pessoa.Pes_cod + ")'>Sim</button>" +
"</div>" +
"</div>" +
"</div>" +
"</div>" +
"<div class='modal fade' id='myModalAtivar' tabindex='- 1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>" +
"<div class='modal-dialog' role='document'>" +
"<div class='modal-content'>" +
"<div class='modal-header'>" +
"<button type='button' class='close' data-dismiss='modal' aria-label='Close'>" +
"<span aria-hidden='true'>×</span>" +
"</button>" +
"<h3 class='modal-title red' id='myModalLabel'>Aviso!</h3>" +
"</div>" +
"<div class='modal-body'>" +
"<h2 class='text-center'>Tem certeza que deseja Ativar?</h2>" +
"</div>" +
"<div class='divider'></div>" +
"<div class='col-xs-12 bottom text-right'>" +
"<button type='button' class='btn btn-default' data-dismiss='modal'>Não</button>" +
"<button type='button' class='btn btn-danger' onclick='ativar(" + dr["set_cod"] + ", " + fmp.Funcionario.Pessoa.Pes_cod + ")'>Sim</button>" +
"</div>" +
"</div>" +
"</div>" +
"</div>";
}
if (lbl.Text == "")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script>info();</script>", false);
}
}
}
else
{
Session["info"] = null;
Response.Redirect("~/paginas/Login.aspx");
}
}
public static Funcionario Select(int fun_cod)
{
Funcionario fun = null;
try
{
IDbConnection objConexao;
IDbCommand objComando;
IDataReader objReader;
objConexao = Mapped.Connection();
string sql = "select * from fun_funcionario where fun_cod=?fun_cod;";
objComando = Mapped.Command(sql, objConexao);
objComando.Parameters.Add(Mapped.Parameter("?fun_cod", fun_cod));
objReader = objComando.ExecuteReader();
int pessoa = 0;
int cargo = 0;
int setor = 0;
int perfil = 0;
while (objReader.Read())
{
fun = new Funcionario();
fun.Fun_cod = Convert.ToInt32(objReader["fun_cod"]);
fun.Fun_matricula = Convert.ToString(objReader["fun_matricula"]);
fun.Fun_senha = Convert.ToString(objReader["fun_senha"]);
if (objReader["fun_chefeDepartamento"].Equals(false))
{
fun.Fun_chefeDepartamento = false;
}
else
{
fun.Fun_chefeDepartamento = true;
}
if (objReader["fun_chefeSetor"].Equals(false))
{
fun.Fun_chefeSetor = false;
}
else
{
fun.Fun_chefeSetor = true;
}
if (objReader["fun_primeiroAcesso"].Equals(false))
{
fun.Fun_primeiroAcesso = false;
}
else
{
fun.Fun_primeiroAcesso = true;
}
if (objReader["cod_fun"] == DBNull.Value)
{
fun.Cod_fun = null;
}
else
{
fun.Cod_fun = Convert.ToInt32(objReader["cod_fun"]);
}
pessoa = Convert.ToInt32(objReader["pes_cod"]);
cargo = Convert.ToInt32(objReader["car_cod"]);
setor = Convert.ToInt32(objReader["set_cod"]);
perfil = Convert.ToInt32(objReader["pfl_cod"]);
}
objConexao.Close();
objComando.Dispose();
objConexao.Dispose();
fun.Pessoa = PessoaDB.Select(pessoa);
fun.Cargo = CargoDB.Select(cargo);
fun.Setor = SetorDB.Select(setor);
fun.Perfil = PerfilDB.Select(perfil);
return(fun);
}
catch
{
return(fun = null);
}
}
