public static List <Empresa> GetAllBusinessByParametersLike(EmpresaFilters filters) { var param = new List <SPParameter> { new SPParameter("Razon_Social", filters.RazonSocial ?? (object)DBNull.Value), new SPParameter("Cuit", filters.Cuit ?? (object)DBNull.Value), new SPParameter("Email", filters.Email ?? (object)DBNull.Value) }; var sp = new StoreProcedure(DataBaseConst.Empresa.SPGetAllBusinessByParametersLike, param); return(sp.ExecuteReader <Empresa>()); }
private void LblBuscar_Click(object sender, EventArgs e) { try { #region Validations var filtersSetted = false; var exceptionMessage = string.Empty; if (!TypesHelper.IsEmpty(TxtRazonSocial.Text)) { filtersSetted = true; } if (!TypesHelper.IsEmpty(TxtCuit.Text)) { filtersSetted = true; if (!TypesHelper.IsCUITValid(TxtCuit.Text)) { exceptionMessage += Environment.NewLine + "El cuit no es un cuit válido."; } } if (!TypesHelper.IsEmpty(TxtEmail.Text)) { filtersSetted = true; } if (!filtersSetted) { exceptionMessage = "No se puede realizar la busqueda ya que no se informó ningún filtro"; } if (!TypesHelper.IsEmpty(exceptionMessage)) { throw new Exception(exceptionMessage); } #endregion var filters = new EmpresaFilters { RazonSocial = (!TypesHelper.IsEmpty(TxtRazonSocial.Text)) ? TxtRazonSocial.Text : null, Cuit = (!TypesHelper.IsEmpty(TxtCuit.Text)) ? TxtCuit.Text : null, Email = (!TypesHelper.IsEmpty(TxtEmail.Text)) ? TxtEmail.Text : null }; var empresas = (ChkBusquedaExacta.Checked) ? EmpresaPersistance.GetAllBusinessByParameters(filters) : EmpresaPersistance.GetAllBusinessByParametersLike(filters); if (empresas == null || empresas.Count == 0) { throw new Exception("No se encontraron empresas según los filtros informados."); } RefreshSources(empresas); } catch (Exception ex) { MessageBox.Show(ex.Message, "Atención"); } }