public static void Update(dtoProcessoPrazoResponsavel ProcessoPrazoResponsavel)
{
using (SqlConnection connection = new SqlConnection(DataAccess.Configuracao.getConnectionString()))
{
string stringSQL = @"UPDATE tbProcessoPrazoResponsavel SET
idProcessoPrazo = @idProcessoPrazo,
idPessoa = @idPessoa
WHERE idProcessoPrazoResponsavel = @idProcessoPrazoResponsavel";
SqlCommand cmdProcessoPrazoResponsavel = new SqlCommand(stringSQL, connection);
ValidaCampos(ref ProcessoPrazoResponsavel);
cmdProcessoPrazoResponsavel.Parameters.Add("idProcessoPrazo", SqlDbType.Int).Value = ProcessoPrazoResponsavel.idProcessoPrazo;
cmdProcessoPrazoResponsavel.Parameters.Add("idPessoa", SqlDbType.Int).Value = ProcessoPrazoResponsavel.idPessoa;
try
{
connection.Open();
cmdProcessoPrazoResponsavel.ExecuteNonQuery();
}
catch
{
throw new ApplicationException("Erro ao atualizar registro");
}
finally
{
connection.Close();
}
}
}
public static void Delete(dtoProcessoPrazoResponsavel ProcessoPrazoResponsavel)
{
using (SqlConnection connection = new SqlConnection(DataAccess.Configuracao.getConnectionString()))
{
string stringSQL = @"DELETE tbProcessoPrazoResponsavel
WHERE idProcessoPrazoResponsavel = @idProcessoPrazoResponsavel";
SqlCommand cmdMenu = new SqlCommand(stringSQL, connection);
cmdMenu.Parameters.Add("idProcessoPrazoResponsavel", SqlDbType.Int).Value = ProcessoPrazoResponsavel.idProcessoPrazoResponsavel;
try
{
connection.Open();
cmdMenu.ExecuteNonQuery();
}
catch
{
throw new ApplicationException("Erro ao excluir registro");
}
finally
{
connection.Close();
}
}
}
public static int Insert(dtoProcessoPrazoResponsavel ProcessoPrazoResponsavel)
{
using (SqlConnection connection = new SqlConnection(DataAccess.Configuracao.getConnectionString()))
{
string stringSQL = @"INSERT INTO tbProcessoPrazoResponsavel(idProcessoPrazo, idPessoa)
VALUES(@idProcessoPrazo, @idPessoa);
SET @idProcessoPrazoResponsavel = SCOPE_IDENTITY()";
SqlCommand cmdProcessoPrazoResponsavel = new SqlCommand(stringSQL, connection);
ValidaCampos(ref ProcessoPrazoResponsavel);
cmdProcessoPrazoResponsavel.Parameters.Add("idProcessoPrazoResponsavel", SqlDbType.Int);
cmdProcessoPrazoResponsavel.Parameters["idProcessoPrazoResponsavel"].Direction = ParameterDirection.Output;
cmdProcessoPrazoResponsavel.Parameters.Add("idProcessoPrazo", SqlDbType.Int).Value = ProcessoPrazoResponsavel.idProcessoPrazo;
cmdProcessoPrazoResponsavel.Parameters.Add("idPessoa", SqlDbType.Int).Value = ProcessoPrazoResponsavel.idPessoa;
try
{
connection.Open();
cmdProcessoPrazoResponsavel.ExecuteNonQuery();
return((int)cmdProcessoPrazoResponsavel.Parameters["idProcessoPrazoResponsavel"].Value);
}
catch
{
throw new ApplicationException("Erro ao inserir registro");
}
finally
{
connection.Close();
}
}
}
private void InserirNovoResponsavel(int idPessoa, int idProcessoPrazo)
{
if (!bllProcessoPrazoResponsavel.Exists(idProcessoPrazo, idPessoa))
{
dtoProcessoPrazoResponsavel processoPrazoResponsavel = new dtoProcessoPrazoResponsavel();
processoPrazoResponsavel.idProcessoPrazo = idProcessoPrazo;
processoPrazoResponsavel.idPessoa = idPessoa;
bllProcessoPrazoResponsavel.Insert(processoPrazoResponsavel);
}
}
private static void PreencheCampos(SqlDataReader drProcessoPrazoResponsavel, ref dtoProcessoPrazoResponsavel ProcessoPrazoResponsavel)
{
if (drProcessoPrazoResponsavel["idProcessoPrazoResponsavel"] != DBNull.Value)
{
ProcessoPrazoResponsavel.idProcessoPrazoResponsavel = Convert.ToInt32(drProcessoPrazoResponsavel["idProcessoPrazoResponsavel"].ToString());
}
if (drProcessoPrazoResponsavel["idProcessoPrazo"] != DBNull.Value)
{
ProcessoPrazoResponsavel.idProcessoPrazo = Convert.ToInt32(drProcessoPrazoResponsavel["idProcessoPrazo"].ToString());
}
if (drProcessoPrazoResponsavel["idPessoa"] != DBNull.Value)
{
ProcessoPrazoResponsavel.idPessoa = Convert.ToInt32(drProcessoPrazoResponsavel["idPessoa"].ToString());
}
}
public static List <dtoProcessoPrazoResponsavel> GetByProcessoPrazo(int idProcessoPrazo)
{
List <dtoProcessoPrazoResponsavel> ProcessoPrazoResponsavels = new List <dtoProcessoPrazoResponsavel>();
if (idProcessoPrazo > 0)
{
using (SqlConnection connection = new SqlConnection(DataAccess.Configuracao.getConnectionString()))
{
StringBuilder sbCondicao = new StringBuilder();
sbCondicao.AppendFormat(@" WHERE (tbProcessoPrazoResponsavel.idProcessoPrazo = {0})", idProcessoPrazo.ToString());
string stringSQL = String.Format("SELECT * FROM tbProcessoPrazoResponsavel {0} ORDER BY idProcessoPrazoResponsavel", sbCondicao.ToString());
SqlCommand cmdProcessoPrazoResponsavel = new SqlCommand(stringSQL, connection);
try
{
connection.Open();
SqlDataReader drProcessoPrazoResponsavel = cmdProcessoPrazoResponsavel.ExecuteReader();
while (drProcessoPrazoResponsavel.Read())
{
dtoProcessoPrazoResponsavel ProcessoPrazoResponsavel = new dtoProcessoPrazoResponsavel();
PreencheCampos(drProcessoPrazoResponsavel, ref ProcessoPrazoResponsavel);
ProcessoPrazoResponsavels.Add(ProcessoPrazoResponsavel);
}
}
catch
{
throw new ApplicationException("Erro ao capturar todos os registros");
}
finally
{
connection.Close();
}
}
}
return(ProcessoPrazoResponsavels);
}
public static List <dtoProcessoPrazoResponsavel> GetAll(string SortExpression)
{
List <dtoProcessoPrazoResponsavel> ProcessoPrazoResponsavels = new List <dtoProcessoPrazoResponsavel>();
using (SqlConnection connection = new SqlConnection(DataAccess.Configuracao.getConnectionString()))
{
string stringSQL = String.Format("SELECT * FROM tbProcessoPrazoResponsavel ORDER BY {0}", (SortExpression.Trim() != String.Empty ? SortExpression.Trim() : "idProcessoPrazoResponsavel"));
SqlCommand cmdProcessoPrazoResponsavel = new SqlCommand(stringSQL, connection);
try
{
connection.Open();
SqlDataReader drProcessoPrazoResponsavel = cmdProcessoPrazoResponsavel.ExecuteReader();
while (drProcessoPrazoResponsavel.Read())
{
dtoProcessoPrazoResponsavel ProcessoPrazoResponsavel = new dtoProcessoPrazoResponsavel();
PreencheCampos(drProcessoPrazoResponsavel, ref ProcessoPrazoResponsavel);
ProcessoPrazoResponsavels.Add(ProcessoPrazoResponsavel);
}
}
catch
{
throw new ApplicationException("Erro ao capturar todos os registros");
}
finally
{
connection.Close();
}
}
return(ProcessoPrazoResponsavels);
}
public static dtoProcessoPrazoResponsavel Get(int idProcessoPrazoResponsavel)
{
dtoProcessoPrazoResponsavel ProcessoPrazoResponsavel = new dtoProcessoPrazoResponsavel();
using (SqlConnection connection = new SqlConnection(DataAccess.Configuracao.getConnectionString()))
{
string stringSQL = @"SELECT *
FROM tbProcessoPrazoResponsavel
WHERE idProcessoPrazoResponsavel = @idProcessoPrazoResponsavel";
SqlCommand cmdMenu = new SqlCommand(stringSQL, connection);
cmdMenu.Parameters.Add("idProcessoPrazoResponsavel", SqlDbType.Int).Value = idProcessoPrazoResponsavel;
try
{
connection.Open();
SqlDataReader drProcessoPrazoResponsavel = cmdMenu.ExecuteReader();
if (drProcessoPrazoResponsavel.Read())
{
PreencheCampos(drProcessoPrazoResponsavel, ref ProcessoPrazoResponsavel);
}
}
catch
{
throw new ApplicationException("Erro ao capturar registro");
}
finally
{
connection.Close();
}
}
return(ProcessoPrazoResponsavel);
}
private static void ValidaCampos(ref dtoProcessoPrazoResponsavel ProcessoPrazoResponsavel)
{
}
