public void AddProductsToTabbedPanel()
{
int i = 1;
using (Coffee_ProjectEntities cpe = new Coffee_ProjectEntities())
{
foreach (TabPage item in metroTabControl1.TabPages)
{
FlowLayoutPanel flp = new FlowLayoutPanel();
flp.Dock = DockStyle.Fill;
foreach (var product in cpe.TblProducts)
{
if (product.ProductType == i)
{
Button btn = new Button();
btn.Size = new Size(100, 100);
btn.Image = Image.FromStream(new MemoryStream(product.Image));
btn.ImageAlign = ContentAlignment.TopCenter;
btn.TextAlign = ContentAlignment.BottomCenter;
btn.ImageAlign = ContentAlignment.TopCenter;
btn.Tag = product;
btn.Click += Btn_Click;
btn.Text = product.Description;
btn.BackColor = Color.White;
flp.Controls.Add(btn);
}
}
item.Controls.Add(flp);
i++;
}
}
}
public void TransactionCompletedMethod(object sebder, EventArgs e)
{
this.Refresh();
lblTotal.Text = String.Format("Total to Pay: {0:C}", totalToPay);
using (Coffee_ProjectEntities cpe = new Coffee_ProjectEntities())
{
if (ChosenProductsList.Count > 0)
{
TblTransaction transaction = new TblTransaction();
transaction.TransactionDate = DateTime.Now;
foreach (var item in ChosenProductsList)
{
transaction.TblTransactionItems.Add(new TblTransactionItem()
{
ProductID = item.ProductID
});
}
cpe.TblTransactions.Add(transaction);
try
{
cpe.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
PrintReciept();
}
public void ContentClickDisplay()
{
int selectedProductId = 0;
for (int i = 0; i < productGridView.Rows.Count; i++)
{
if (productGridView.Rows[i].Selected == true)
{
selectedProductId = (int)productGridView.Rows[i].Cells[0].Value;
}
}
using (Coffee_ProjectEntities cpe = new Coffee_ProjectEntities())
{
var recievedImage = from m in cpe.TblProducts
select m;
foreach (var item in recievedImage)
{
if (item.ProductID == selectedProductId)
{
lblDescription.Visible = true;
lblPrice.Visible = true;
txtDescription.Visible = true;
byte[] imagedBytes = item.Image;
MemoryStream memoryStream = new MemoryStream(imagedBytes);
selectedImage.Image = Image.FromStream(memoryStream);
txtDescription.Text = item.Description;
lblPrice.Text = String.Format("{0:C}", item.Price);
break;
}
}
}
}
public void CreateTabbedPanel()
{
using (Coffee_ProjectEntities cpe = new Coffee_ProjectEntities())
{
foreach (var item in cpe.TblProductTypes)
{
metroTabControl1.TabPages.Add(item.ProductType.ToString(), item.ProductDescription);
}
}
}
public void DisplayAllData()
{
using (Coffee_ProjectEntities cpe = new Coffee_ProjectEntities())
{
DataTable tempTable = new DataTable();
tempTable.Columns.Add("Id", typeof(int));
tempTable.Columns.Add("Product Type", typeof(int));
tempTable.Columns.Add("Decription", typeof(string));
tempTable.Columns.Add("Price", typeof(string));
var items = cpe.TblProducts.Select(it => it);
foreach (var item in items)
{
tempTable.Rows.Add(item.ProductID, item.ProductType, item.Description, item.Price);
}
productGridView.DataSource = tempTable;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
using (Coffee_ProjectEntities cpe = new Coffee_ProjectEntities())
{
TblProduct newProduct = new TblProduct()
{
Description = txtDescription.Text,
Price = Convert.ToDecimal(txtPrice.Text),
Image = imageBytes,
ProductType = (int)cmbCategory.SelectedValue
};
cpe.TblProducts.Add(newProduct);
cpe.SaveChanges();
lblSaving.Visible = false;
MessageBox.Show("Item Saved Successfully", "Item Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void Add_Product_Load(object sender, EventArgs e)
{
Thread.CurrentThread.CurrentUICulture = new CultureInfo("rs-PK");
using (Coffee_ProjectEntities cpe = new Coffee_ProjectEntities())
{
DataTable temptabel = new DataTable();
temptabel.Columns.Add("ProductType", typeof(int));
temptabel.Columns.Add("ProductDescription", typeof(string));
var items = cpe.TblProductTypes.Select(eb => eb);
foreach (var item in items)
{
temptabel.Rows.Add((int)item.ProductType, (string)item.ProductDescription);
}
cmbCategory.DataSource = temptabel;
cmbCategory.DisplayMember = "ProductDescription";
cmbCategory.ValueMember = "ProductType";
}
}
private void GenerateGraph()
{
try
{
using (Coffee_ProjectEntities cpe = new Coffee_ProjectEntities())
{
var query = from product in cpe.TblTransactionItems
group product by product.TblProduct.Description into g
select new { ProductId = g.Key, TotalUnitSold = g.Count() };
var list = query.ToList();
chart1.DataSource = list;
chart1.Series["Series1"].XValueMember = "ProductId";
chart1.Series["Series1"].YValueMembers = "TotalUnitSold";
chart1.Series["Series1"].Name = "Products";
chart1.DataBind();
chart1.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
