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