private void btnFinalizeAcc_Click(object sender, EventArgs e)
{
if (MetroMessageBox.Show(this, "Are you sure you want to finalize this Account?", "Finalize Account", MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
EntitiesContext context = new EntitiesContext();
AccountDAO adao = new AccountDAO();
ItemAccDAO iadao = new ItemAccDAO();
ProdDAO pdao = new ProdDAO();
var busca = from ia in context.ItemAccs
join p in context.Products on ia.ProductId equals p.Id
where ia.AccountId == idacc
select new
{
Qnt = ia.Qnt,
Price = p.PriceUni
};
decimal total = 0;
foreach (var i in busca)
{
total = total + (i.Qnt * i.Price);
}
global.final = total;
frmFinalizeAcc facc = new frmFinalizeAcc();
facc.Show();
}
}
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;
}
}
}
