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