public void Desarquivar(Int32 _IdDocumento) { using (SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBGesDoc"].ConnectionString)) { try { objConn.Open(); UsuarioDAL uDAL = new UsuarioDAL(); SqlCommand cmd_1 = new SqlCommand("DELETE FROM tbArquivamentosInternos WHERE idDocumento = " + _IdDocumento, objConn); SqlCommand cmd_2 = new SqlCommand("DELETE FROM tbArquivamentosExternos WHERE idDocumento = " + _IdDocumento, objConn); SqlCommand cmd_3 = new SqlCommand("UPDATE tbDocumentos SET arquivado = '0' WHERE idDocumento = " + _IdDocumento, objConn); cmd_1.ExecuteNonQuery(); cmd_2.ExecuteNonQuery(); cmd_3.ExecuteNonQuery(); } catch (Exception) { throw; } finally { objConn.Close(); } } }
public void Autenticar(string _Email, string _Senha) { using (SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBGesDoc"].ConnectionString)) { try { objConn.Open(); SqlCommand cmd = new SqlCommand("SELECT IDUsuario,IDProcesso,DSEmail,DSNivelAcesso FROM TB_Usuario WHERE DSEmail = @DSEmail AND DSSenha = @DSSenha AND BTAtivo = 1", objConn); cmd.Parameters.Add("@DSEmail", SqlDbType.VarChar, 60).Value = _Email; cmd.Parameters.Add("@DSSenha", SqlDbType.VarChar, 15).Value = _Senha; SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { UsuarioDAL uDAL = new UsuarioDAL(); HttpContext.Current.Session["sesIdUsuario"] = dr["IDUsuario"]; HttpContext.Current.Session["sesIdProcesso"] = dr["IDProcesso"]; HttpContext.Current.Session["sesEmail"] = dr["DSEmail"]; HttpContext.Current.Session["sesNivelAcesso"] = dr["DSNivelAcesso"]; HttpContext.Current.Response.Redirect("Home/Default.aspx"); } else { HttpContext.Current.Response.Write("<script language='JavaScript'>alert('E-mail ou senha incorretos');history.go(-1);</script>"); } } catch (Exception) { throw; } finally { objConn.Close(); } } }
public void Receber(Int32 _IdDocumento) { using (SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBGesDoc"].ConnectionString)) { try { objConn.Open(); UsuarioDAL uDAL = new UsuarioDAL(); SqlCommand cmd = new SqlCommand("UPDATE tbMovimentacoes Set recebido='Sim',recebidoPor='" + uDAL.ObterDadosPorId(Convert.ToInt32(HttpContext.Current.Session["sesIdUsuario"])).DSNome + "',dataHoraRecebimento='" + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString() + "' WHERE idDocumento = " + _IdDocumento + " And recebido = 'Não'", objConn); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { objConn.Close(); } } }