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