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