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