private void button1_Click(object sender, EventArgs e) { using (var db = new tccfinalContext()) { var query1 = db.Orcamentos.Where(ru => ru.AnoId = AnoId).tolist(); } }
void carregarDadosGrid() { using (var db = new tccfinalContext()) { //Database query direto na DataSource dgvServicos.DataSource = db.Servico.Select(x => new { Id = x.CodOrca, Nome = x.CodServico, Dataorcamento = x.ValorServiço, ValorOrcamento = x.DescServ, }).ToList(); //Configuracoes de DataGridView dgvServicos.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvServicos.AutoGenerateColumns = false; dgvServicos.ReadOnly = true; //Customizando as colunas dgvServicos.Columns["Id"].Visible = true; dgvServicos.Columns["Nome"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvServicos.Columns["Dataorcamento"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvServicos.Columns["ValorOrcamento"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } }
void carregarDadosGrid() { using (var db = new tccfinalContext()) { //Database query direto na DataSource dgvClientes.DataSource = db.Cliente.Select(x => new { Id = x.CodCliente, Nome = x.NomeCliente, TipoPessoa = x.TipoPessoaNavigation.TipoPessoa1, UF = x.UfNavigation.Estado1, Avaliacao = x.AvaliacaoClienteNavigation.Avaliacao1, CPF_CNPJ = x.CpfCnpj, TelefoneFixo = x.TelFixo, Celular = x.TelCel, Email = x.EmailCliete, Cidade = x.Cidade, CEP = x.CepCliente, Endereço = x.EnderecoCliente, }).ToList(); //Configuracoes de DataGridView dgvClientes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvClientes.AutoGenerateColumns = false; dgvClientes.ReadOnly = true; //Customizando as colunas dgvClientes.Columns["Id"].Visible = false; dgvClientes.Columns["Nome"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvClientes.Columns["TipoPessoa"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvClientes.Columns["Avaliacao"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvClientes.Columns["UF"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvClientes.Columns["CPF_CNPJ"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvClientes.Columns["TelefoneFixo"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvClientes.Columns["Celular"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvClientes.Columns["Email"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvClientes.Columns["Cidade"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvClientes.Columns["CEP"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvClientes.Columns["Endereço"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } }
private void button1_Click(object sender, EventArgs e) { using (var db = new tccfinalContext()) { var a = db.User.FirstOrDefault(x => x.Login == textBox1.Text); var b = db.User.FirstOrDefault(x => x.Senha == textBox2.Text); if (a != null && b != null) { this.Hide(); Form f = new Form2(); f.Closed += (s, args) => this.Close(); f.Show(); } else { MessageBox.Show("Usuário não encontrado!"); } } }
void carregarDadosGrid() { using (var db = new tccfinalContext()) { //Database query direto na DataSource dgvOrcamentos.DataSource = db.Orcamentos.Select(x => new { Id = x.CodOrca, Cliente = x.ClienteNavigation.NomeCliente, CPF_CNPJ = x.ClienteNavigation.CpfCnpj, DataOrçamento = x.DataOrca, ValorOrcamento = x.ValorOrca, MetodoPagamento = x.MetodoPagNavigation.MPag, DataEntrega = x.DataEntrega, Status = x.StatusOrcaNavigation.Status1, AnoId = x.AnoId, MesId = x.MesId, DiaId = x.DiaId, }).ToList(); //Configuracoes de DataGridView dgvOrcamentos.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvOrcamentos.AutoGenerateColumns = false; dgvOrcamentos.ReadOnly = true; //Customizando as colunas dgvOrcamentos.Columns["Id"].Visible = false; dgvOrcamentos.Columns["Dataorçamento"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvOrcamentos.Columns["ValorOrcamento"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvOrcamentos.Columns["Cliente"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvOrcamentos.Columns["DataEntrega"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvOrcamentos.Columns["Status"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvOrcamentos.Columns["AnoId"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvOrcamentos.Columns["MesId"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvOrcamentos.Columns["DiaId"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvOrcamentos.Columns["MetodoPagamento"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvOrcamentos.Columns["CPF_CNPJ"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } }