public static ClientesDTO GetOneById(ClientesDTO oneMedicamento) { string query = "Select * from Table_Catalogo_Clientes where Id_Cliente = @Id_Cliente"; Helpers h = new Helpers(); return(h.GetAllParametized(query, oneMedicamento)[0]); }
public string GetClienteMorales(string search) { List<string> lSearch = search.Split(new char[] { ' ' }).ToList(); var oneCliente = new ClientesDTO(); oneCliente.Nombre = "%" + search.Trim() + "%"; string query = "Select * from Table_Catalogo_Clientes where Nombre like @Nombre and Activo = 1 or RFC like @Nombre and Activo = 1"; Helpers h = new Helpers(); var lMed = h.GetAllParametized(query, oneCliente); string json = JsonConvert.SerializeObject(lMed); return json; }
public static ClientesDTO GetOneByName(ClientesDTO oneMedicamento) { string query = "Select * from Table_Catalogo_Clientes where Nombre = @Nombre"; Helpers h = new Helpers(); return h.GetAllParametized(query, oneMedicamento)[0]; }