private void Boletas_Load(object sender, EventArgs e)
        {
            limpiar();
            this.rutaLocal = Application.StartupPath;
            InnerDatabaseManager comercialDBM = new InnerDatabaseManager();

            this.conexionComercial = comercialDBM.createConnectionFromIniComercialFile(this.rutaLocal);

            try
            {
                this.conexionComercial.Open();
                command = new SqlCommand("SELECT CIDCLIENTEPROVEEDOR, " +
                                         "CCODIGOCLIENTE, " +
                                         "CRAZONSOCIAL " +
                                         "FROM admClientes " +
                                         "WHERE CESTATUS = 1 " +
                                         "ORDER BY CIDCLIENTEPROVEEDOR ASC", this.conexionComercial);
                dataAdapter = new SqlDataAdapter(command);
                dataAdapter.Fill(dataTable);
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }

            this.dgvClientes.AutoGenerateColumns = false;
            this.dgvClientes.DataSource          = dataTable;

            this.cmbCanalizacion.Items.Insert(0, "Canal completo");
            this.cmbCanalizacion.Items.Insert(0, "Cortes - Obrador");
        }
        private void ReporteVentas_Load(object sender, EventArgs e)
        {
            this.rutaLocal = Application.StartupPath;
            InnerDatabaseManager databaseManager = new InnerDatabaseManager();

            this.conexion = databaseManager.createConnectionFromIniFile(this.rutaLocal);
        }
Exemple #3
0
        public MenuCRUD()
        {
            InitializeComponent();

            string rutaLocal = Application.StartupPath;

            InnerDatabaseManager dbManager = new InnerDatabaseManager();

            this.conexion = dbManager.createConnectionFromIniFile(rutaLocal);
            this.conexion.Open();
        }
Exemple #4
0
        private void LogIn_Load(object sender, EventArgs e)
        {
            this.rutaLocal = Application.StartupPath;
            InnerDatabaseManager dbManager = new InnerDatabaseManager();

            this.conexion = dbManager.createConnectionFromIniFile(this.rutaLocal);

            try
            {
                this.conexion.Open();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }