public static bool alteraSenhaUsudac(CL_EsqueciSenha objEsqueciSenha, string con)
{
//connString = "Server=diretivasistemas.ddns.com.br;Port=5432;User Id=postgres;Password=Pgadmin12345;Database=11157076000141";
connString = "Server=postgres-diretiva.ddns.net;Port=5432;User Id=postgres;Password=Diretiva!@#;Database=Diretiva";
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
string bd = Conn.Database;
Conn = new NpgsqlConnection(connString);
Conn.Open();
NpgsqlTransaction transaction = Conn.BeginTransaction();
string sql = "UPDATE usudac set u_senha=@u_nova WHERE u_email=@u_email AND u_senha=@u_antiga";
try
{
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn, transaction);
comand.Parameters.AddWithValue("u_nova", objEsqueciSenha.u_esqSenhaNov);
comand.Parameters.AddWithValue("u_antiga", objEsqueciSenha.u_esqSenhaAnt);
comand.Parameters.AddWithValue("u_email", objEsqueciSenha.u_esqEmail);
comand.ExecuteScalar();
transaction.Commit();
Conn.ChangeDatabase(bd);
transaction = Conn.BeginTransaction();
comand = new NpgsqlCommand(sql, Conn, transaction);
comand.Parameters.AddWithValue("u_nova", objEsqueciSenha.u_esqSenhaNov);
comand.Parameters.AddWithValue("u_antiga", objEsqueciSenha.u_esqSenhaAnt);
comand.Parameters.AddWithValue("u_email", objEsqueciSenha.u_esqEmail);
comand.ExecuteScalar();
transaction.Commit();
return(true);
}
catch (Exception ex)
{
ex.ToString();
transaction.Rollback();
return(false);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static bool alteraSenhaUsudac(CL_EsqueciSenha objEsqueciSenha, string con)
{
return(DB_Usudac.alteraSenhaUsudac(objEsqueciSenha, con));
}
