private void btnFilter_Click(object sender, EventArgs e) { try { if (mcbFilterBy.SelectedIndex == 0) { idprod = int.Parse(txtFilterProd.Text); nameprod = null; } if (mcbFilterBy.SelectedIndex == 1) { nameprod = txtFilterProd.Text; idprod = 0; } ProdDAO pdao = new ProdDAO();; var bindinglist6 = pdao.Filter(idacc, idprod, nameprod); var source6 = new BindingSource(bindinglist6, null); dgvItemMenu.DataSource = source6; dgvItemMenu.Columns.Remove("ItemMenus"); dgvItemMenu.Columns.Remove("ItemAccs"); dgvItemMenu.Columns[0].HeaderText = "Product ID"; dgvItemMenu.Columns[1].HeaderText = "Name"; dgvItemMenu.Columns[2].HeaderText = "Description"; dgvItemMenu.Columns[3].HeaderText = "Unit Price"; } catch (FormatException) { ProdDAO pdao = new ProdDAO(); if (idacc == 0) { } else { var bindinglist7 = pdao.FindProdsByAccount(idacc); var source7 = new BindingSource(bindinglist7, null); dgvItemMenu.DataSource = source7; dgvItemMenu.Columns.Remove("ItemMenus"); dgvItemMenu.Columns.Remove("ItemAccs"); dgvItemMenu.Columns[0].HeaderText = "Product ID"; dgvItemMenu.Columns[1].HeaderText = "Name"; dgvItemMenu.Columns[2].HeaderText = "Description"; dgvItemMenu.Columns[3].HeaderText = "Unit Price"; } } }
private void frmCashier_Load(object sender, EventArgs e) { this.Text = Strings.Cashier; lblBack.Text = Strings.Back; txtEnterAccount.Focus(); panelAddAcc.Visible = false; panelAddTicket.Visible = false; lblTitle.Visible = true; lblTitle2.Visible = true; lblTitle3.Visible = false; lbltitle4.Visible = false; ProdDAO pdao = new ProdDAO(); idacc = 0; var bindinglist = pdao.FindProdsByAccount(idacc); var source = new BindingSource(bindinglist, null); dgvItemMenu.DataSource = source; dgvItemMenu.Columns.Remove("ItemMenus"); dgvItemMenu.Columns.Remove("ItemAccs"); dgvItemMenu.Columns[0].HeaderText = "Product ID"; dgvItemMenu.Columns[1].HeaderText = "Name"; dgvItemMenu.Columns[2].HeaderText = "Description"; dgvItemMenu.Columns[3].HeaderText = "Unit Price"; cpfcli = ""; ClientDAO cdao = new ClientDAO(); var bindingList2 = new BindingList <Client>(cdao.FindCpf(cpfcli)); var source2 = new BindingSource(bindingList2, null); dgvClients.DataSource = source2; dgvClients.Columns.Remove("Accounts"); dgvClients.Columns[0].HeaderText = "Client ID"; dgvClients.Columns[1].HeaderText = "CPF"; dgvClients.Columns[2].HeaderText = "Full Name"; dgvClients.Columns[3].HeaderText = "Birth Date"; dgvClients.Columns[4].HeaderText = "RG"; dgvClients.Columns[5].HeaderText = "Sex"; dgvClients.Columns[6].HeaderText = "Cell Phone"; }
private void btnSearch_Click(object sender, EventArgs e) { try { ProdDAO pdao = new ProdDAO(); idacc = int.Parse(txtEnterAccount.Text); var bindinglist3 = pdao.FindProdsByAccount(idacc); var source3 = new BindingSource(bindinglist3, null); dgvItemMenu.DataSource = source3; dgvItemMenu.Columns.Remove("ItemMenus"); dgvItemMenu.Columns.Remove("ItemAccs"); dgvItemMenu.Columns[0].HeaderText = "Product ID"; dgvItemMenu.Columns[1].HeaderText = "Name"; dgvItemMenu.Columns[2].HeaderText = "Description"; dgvItemMenu.Columns[3].HeaderText = "Unit Price"; EntitiesContext context = new EntitiesContext(); var busca = from p in context.Products join ia in context.ItemAccs on p.Id equals ia.ProductId join a in context.Accounts on ia.AccountId equals a.Id join c in context.Clients on a.ClientId equals c.Id where ia.AccountId == idacc select new { productid = p.Id, productname = p.Name, qnt = ia.Qnt }; var source9 = new BindingSource(busca.ToList(), null); dgvAccount.DataSource = source9; dgvAccount.Columns[0].HeaderText = "Product ID"; dgvAccount.Columns[1].HeaderText = "Product Name"; dgvAccount.Columns[2].HeaderText = "Amount"; //INFORMAÇÕES SOBRE O CLIENTE var infocli = from c in context.Clients join a in context.Accounts on c.Id equals a.ClientId join t in context.Tickets on a.TicketId equals t.Id where a.Id == idacc select new { client = c.Name, ticket = t.Name }; foreach (var c in infocli) { lblData1.Text = idacc.ToString(); lblbData2.Text = c.client; lblData3.Text = c.ticket; } } catch (FormatException) { if (MetroMessageBox.Show(this, "This account does not exist. Would you like to open a new account?", "Account Not Found", MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { panelAddAcc.Visible = true; } } catch (NullReferenceException) { if (MetroMessageBox.Show(this, "This account does not exist. Would you like to open a new account?", "Account Not Found", MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { panelAddAcc.Visible = true; } } }