public ENTResponse DeleteSolicitudAutoridad(ENTAutoridad oENTAutoridad, string sConnectionString, int iAlternativeTimeOut)
{
SqlConnection Connection = new SqlConnection(sConnectionString);
SqlCommand Command;
SqlDataAdapter DataAdapter;
SqlParameter Parameter;
ENTResponse oENTResponse = new ENTResponse();
Command = new SqlCommand("spAutoridadSolicitud_del", Connection);
Command.CommandType = CommandType.StoredProcedure;
if (iAlternativeTimeOut > 0) { Command.CommandTimeout = iAlternativeTimeOut; }
Parameter = new SqlParameter("SolicitudId", SqlDbType.Int);
Parameter.Value = oENTAutoridad.SolicitudId;
Command.Parameters.Add(Parameter);
Parameter = new SqlParameter("AutoridadId", SqlDbType.Int);
Parameter.Value = oENTAutoridad.AutoridadId;
Command.Parameters.Add(Parameter);
oENTResponse.dsResponse = new DataSet();
DataAdapter = new SqlDataAdapter(Command);
try
{
Connection.Open();
DataAdapter.Fill(oENTResponse.dsResponse);
Connection.Close();
}
catch (SqlException ex) { oENTResponse.ExceptionRaised(ex.Message); }
catch (Exception ex) { oENTResponse.ExceptionRaised(ex.Message); }
finally
{
if (Connection.State == ConnectionState.Open) { Connection.Close(); }
}
return oENTResponse;
}