public static void BuscarClientes()
{
using (Models.DB_A4F04A_CREDITMICITTContext db = new Models.DB_A4F04A_CREDITMICITTContext())
{
//var buscarclientes = new BuscarClientes();
//buscarclientes = db.Clientes.Where
//List<Models.Clientes> lst = (from d in db.Clientes.
// select d).ToList();
//foreach (Models.Clientes cli in lst) */
var context = new DB_A4F04A_CREDITMICITTContext();
var LISTA = context.BuscarClientes.FromSql($"BuscarClientes").ToList();
LS = LISTA;
foreach (var LIS in LISTA)
{
IDCLI = LIS.ID_CLIENTE;
NOM = LIS.NOMBRE_CLI;
APES = LIS.APELLIDO1_CLI + " " + LIS.APELLIDO2_CLI;
TEL = LIS.TELEFONO_CLI;
IDCRE = LIS.ID_CREDITO.ToString();
CED = LIS.CEDULA_CLI;
}
}
}
public static void ClientesCampanna(string ced, string nom, string tel, string dir, string cred, string dist)
{
using (Models.DB_A4F04A_CREDITMICITTContext db = new Models.DB_A4F04A_CREDITMICITTContext())
{
var context = new DB_A4F04A_CREDITMICITTContext();
var LISTA = context.Campanna.FromSql($"Campanna {ced},{nom},{tel},{dir},{Int32.Parse(cred)},{Int32.Parse(dist)}").ToList();
LSC = LISTA;
}
}