Exemple #1
0
        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];
 }