public GeneralDet Get(int nu_general_cab, string co_general_det)
{
using (var connection = _connectionFactory.GetConnection)
{
var query = "sps_tbl_general_det";
var parameters = new DynamicParameters();
parameters.Add("@pi_nu_general_cab", nu_general_cab);
parameters.Add("@pi_co_general_det", co_general_det);
parameters.Add("@pi_id_usuario_login", 0);
parameters.Add("@po_error_number", 0, direction: ParameterDirection.Output);
parameters.Add("@po_error_message", "", direction: ParameterDirection.Output);
var generalDet = connection.QuerySingleOrDefault <GeneralDet>(query, param: parameters, commandType: CommandType.StoredProcedure);
if (generalDet == null)
{
GeneralDet generalDetError = new GeneralDet();
generalDetError.error_number = parameters.Get <int>("@po_error_number");
generalDetError.error_message = parameters.Get <string>("@po_error_message");
return(generalDetError);
}
else
{
return(generalDet);
}
}
}
public ResponseQuery Insert(GeneralDet generalDet)
{
ResponseQuery responseQuery = new ResponseQuery();
using (var connection = _connectionFactory.GetConnection)
{
var query = "spi_tbl_general_det";
var parameters = new DynamicParameters();
parameters.Add("@pi_no_general_det", generalDet.no_general_det);
parameters.Add("@pi_id_usuario_login", generalDet.id_usuario_creacion);
parameters.Add("@po_error_number", 0, direction: ParameterDirection.Output);
parameters.Add("@po_error_message", "", direction: ParameterDirection.Output);
connection.Execute(query, param: parameters, commandType: CommandType.StoredProcedure);
responseQuery.error_number = parameters.Get <int>("@po_error_number");
responseQuery.error_message = parameters.Get <string>("@po_error_message");
return(responseQuery);
}
}
public IEnumerable <GeneralDet> GetAll(GeneralDet generalDet)
{
using (var connection = _connectionFactory.GetConnection)
{
var query = "spl_tbl_general_det";
var parameters = new DynamicParameters();
parameters.Add("@pi_nu_general_cab", generalDet.nu_general_cab);
parameters.Add("@pi_co_general_det", generalDet.co_general_det);
parameters.Add("@pi_no_general_det", generalDet.no_general_det);
parameters.Add("@pi_fl_inactivo", generalDet.fl_inactivo);
parameters.Add("@pi_id_usuario_login", generalDet.id_usuario_modificacion);
parameters.Add("@po_error_number", 0, direction: ParameterDirection.Output);
parameters.Add("@po_error_message", "", direction: ParameterDirection.Output);
var generalDets = connection.Query <GeneralDet>(query, param: parameters, commandType: CommandType.StoredProcedure);
var error_number = parameters.Get <int>("@po_error_number");
var error_message = parameters.Get <string>("@po_error_message");
return(generalDets);
}
}
public async Task <ResponseQuery> DeleteAsync(GeneralDet generalDet)
{
ResponseQuery responseQuery = new ResponseQuery();
using (var connection = _connectionFactory.GetConnection)
{
var query = "spd_tbl_general_det";
var parameters = new DynamicParameters();
parameters.Add("@pi_nu_general_cab", generalDet.nu_general_cab);
parameters.Add("@pi_co_general_det", generalDet.co_general_det);
parameters.Add("@pi_id_usuario_login", generalDet.id_usuario_modificacion);
parameters.Add("@po_error_number", 0, direction: ParameterDirection.Output);
parameters.Add("@po_error_message", "", direction: ParameterDirection.Output);
await connection.ExecuteAsync(query, param : parameters, commandType : CommandType.StoredProcedure);
responseQuery.error_number = parameters.Get <int>("@po_error_number");
responseQuery.error_message = parameters.Get <string>("@po_error_message");
return(responseQuery);
}
}
public async Task <IEnumerable <GeneralDet> > GetAllAsync(GeneralDet generalDet)
{
return(await _generalDetRepository.GetAllAsync(generalDet));
}
public async Task <ResponseQuery> DeleteAsync(GeneralDet generalDet)
{
return(await _generalDetRepository.DeleteAsync(generalDet));
}
public IEnumerable <GeneralDet> GetAll(GeneralDet generalDet)
{
return(_generalDetRepository.GetAll(generalDet));
}
public ResponseQuery Delete(GeneralDet generalDet)
{
return(_generalDetRepository.Delete(generalDet));
}
public ResponseQuery Update(GeneralDet generalDet)
{
return(_generalDetRepository.Update(generalDet));
}
public ResponseQuery Insert(GeneralDet generalDet)
{
return(_generalDetRepository.Insert(generalDet));
}
