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)); }