public List <ParametroHorario> Search(ParametroHorario obj) { List <ParametroHorario> lstRet = new List <ParametroHorario>(); using (SqlConnection oConnection = new SqlConnection(Conexao.DefaultConnection)) { oConnection.Open(); using (SqlCommand oCommand = oConnection.CreateCommand()) { oCommand.CommandText = Conexao.Owner + "usp_ParametroHorario_Search"; oCommand.CommandType = CommandType.StoredProcedure; #region --- Parâmetros --- oCommand.Parameters.Clear(); oCommand.Parameters.Add(new SqlParameter() { ParameterName = "@pho_Id", Direction = ParameterDirection.Input, Value = obj.ParametroHorarioId }); oCommand.Parameters.Add(new SqlParameter() { ParameterName = "@pho_Horario", Direction = ParameterDirection.Input, Value = obj.Horario }); #endregion try { SqlDataReader oDr = oCommand.ExecuteReader(); while (oDr.Read()) { ParametroHorario item = new ParametroHorario { ParametroHorarioId = Convert.ToInt64(oDr["pho_Id"]), Horario = oDr["pho_Nome"].ToString(), }; lstRet.Add(item); } } catch (SqlException ex) when(ex.Server == ".\\SQLEXPRESS") { Console.WriteLine("SQL Provider Error: " + ex.Message); } catch (Exception ex) when(ex.InnerException.ToString() == "Parameter Error") { Console.WriteLine("SQL Provider Error: " + ex.Message); } } oConnection.Close(); } return(lstRet); }
public bool Update(ParametroHorario obj) { return(_parametroHorarioRepository.Update(obj)); }
public List <ParametroHorario> Search(ParametroHorario obj) { return(_parametroHorarioRepository.Search(obj)); }
public long?Insert(ParametroHorario obj) { return(_parametroHorarioRepository.Insert(obj)); }
public ParametroHorario Find(ParametroHorario obj) { return(_parametroHorarioRepository.Find(obj)); }
public bool Delete(ParametroHorario obj) { return(_parametroHorarioRepository.Delete(obj)); }
public long?Insert(ParametroHorario obj) { throw new NotImplementedException(); }
public ParametroHorario Find(ParametroHorario obj) { throw new NotImplementedException(); }
public bool Delete(ParametroHorario obj) { throw new NotImplementedException(); }