private void vendors_nsme_Click(object sender, EventArgs e) { using (var db = new HamroSuperMarketEntities()) { if (textBox_name.Text.Trim() == "") { notificationMAnager1.show("Please Enter Category Name", 1000); return; } try { category category = new category { name = textBox_name.Text, created_at = DateTime.Now, updated_at = DateTime.Now }; db.categories.Add(category); db.SaveChanges(); listBox1.Items.Add(category); textBox_name.Clear(); } catch (Exception ex) { notificationMAnager1.show(" your category is not save please try again", 1000); } } }
public Customers_Details(int id) { InitializeComponent(); using (var db = new HamroSuperMarketEntities()) { customer c = db.customers.First(o => o.id == id); this.id = id; customername.Text = c.name; customeraddress.Text = c.adress; customerphone.Text = c.phone; customeremail.Text = c.email; customerdue.Text = c.due.ToString(); foreach (bill b in db.bills.Where(o => o.customer_id == id).ToList()) { betterListView1.Items.Add(new ListViewItem( new string[] { b.id.ToString(), b.total.ToString(), b.paid.ToString(), b.due.ToString(), RetailControls.Helpers.DateStampToString(b.day.Value) } )); } } }
private void comboBox_categories_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox_categories.SelectedIndex > -1) { betterListView1.Items.Clear(); using (var db = new HamroSuperMarketEntities()) { if (comboBox_categories.SelectedIndex == 0) { foreach (item n in db.items.ToList()) { ItemViwer itemviwer = new ItemViwer(n, betterListView1.Items.Count + 1); betterListView1.Items.Add(itemviwer); } } else { var sel = comboBox_categories.SelectedItem as category; foreach (item n in db.items.Where(o => o.category_id == sel.id).ToList()) { ItemViwer itemviwer = new ItemViwer(n, betterListView1.Items.Count + 1); betterListView1.Items.Add(itemviwer); } } } } }
public Item_List() { InitializeComponent(); using (var db = new HamroSuperMarketEntities()) { List <ItemViwer> itemViwers = new List <ItemViwer>(); List <string> strs = new List <string>(); var i = 1; foreach (item n in db.items.ToList()) { itemViwers.Add(new ItemViwer(n, i++)); strs.Add(n.name); } betterListView1.Items.AddRange(itemViwers.ToArray()); searchbox.AutoCompleteCustomSource.AddRange(strs.ToArray()); //foreach (var cats in db.categories.ToList()) //{ comboBox_categories.Items.AddRange(db.categories.ToArray()); //} foreach (ListViewItem lstItem in betterListView1.Items) // listView has ListViewItem objects { valorSum += ((Convert.ToDecimal(lstItem.SubItems[3].Text)) * (Convert.ToDecimal(lstItem.SubItems[5].Text))); label_totalmrp.Text = valorSum.ToString("0.##"); totalwholesale += ((Convert.ToDecimal(lstItem.SubItems[4].Text)) * (Convert.ToDecimal(lstItem.SubItems[5].Text)));; label_totalwholesale.Text = totalwholesale.ToString("0.##"); totalcost += ((Convert.ToDecimal(lstItem.SubItems[6].Text)) * (Convert.ToDecimal(lstItem.SubItems[5].Text)));; label_totalcost.Text = totalcost.ToString("0.##"); } this.id = id; } }
private void textBox1_KeyDown(object sender, KeyEventArgs e) { if (e.KeyData == Keys.Enter) { count = 0; listView1.Items.Clear(); if (textBox1.Text.Trim() == "") { notificationMAnager1.show("Please Enter Customer name to search", 1000); return; } using (var db = new HamroSuperMarketEntities()) { var customers = db.customers.Where(o => o.name.Contains(textBox1.Text) || o.phone == textBox1.Text.Trim()).ToList(); if (customers.Count == 0) { notificationMAnager1.show("No Customers Found", 1000); return; } foreach (customer c in customers) { CustomerViwer customerviwer = new CustomerViwer(c); listView1.Items.Add(customerviwer); } } } }
private void materialButton1_Click(object sender, EventArgs e) { using (HamroSuperMarketEntities db = new HamroSuperMarketEntities()) { advance advance = db.advances.Where(o => o.id == this.id).First(); db.Entry(advance).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } }
private void materialButton2_Click(object sender, EventArgs e) { using (var db = new HamroSuperMarketEntities()) { foreach (customer c in db.customers.ToList()) { CustomerViwer customerviwer = new CustomerViwer(c); listView1.Items.Add(customerviwer); } } }
private void supplier_txt_SelectedIndexChanged(object sender, EventArgs e) { if (combobox_supplier.SelectedIndex > -1) { var sel = (vendor)combobox_supplier.getSelectedItem().data; using (var db = new HamroSuperMarketEntities()) { var sup = db.vendors.Find(sel.id); advance_fltb.value = sup.advance.Value; } } }
private void textBox1_TextChanged_1(object sender, EventArgs e) { listView1.Items.Clear(); using (var db = new HamroSuperMarketEntities()) { foreach (Models.vendor n in db.vendors.Where(o => o.name.Contains(search_txt.Text)).ToList()) { VenViwer venViwer = new VenViwer(n); listView1.Items.Add(venViwer); } } }
private void Addcate_FormClosed(object sender, FormClosedEventArgs e) { comboBox_categories.Items.Clear(); comboBox_categories.Items.Add("All"); using (var db = new HamroSuperMarketEntities()) { foreach (var cats in db.categories.ToList()) { comboBox_categories.Items.Add(cats); } } }
private void label2_Click(object sender, EventArgs e) { if (customername.Text.Trim() == "") { notificationMAnager1.show("Please enter and customer name ", 1000); return; } if (customeradress.Text.Trim() == "") { notificationMAnager1.show("Please enter and customer address ", 1000); return; } if (customerphoneno.Text.Trim() == "") { notificationMAnager1.show("Please enter and customer address ", 1000); return; } try { using (var db = new HamroSuperMarketEntities()) { customer i = new customer() { name = customername.Text, adress = customeradress.Text, phone = customerphoneno.Text, email = customeremail.Text, due = Convert.ToDecimal(due_txt.Text), created_at = DateTime.Now, updated_at = DateTime.Now }; db.customers.Add(i); db.SaveChanges(); if (onDataSaved != null) { onDataSaved(this, new DataSaveargs() { data = i }); } notificationMAnager1.show("Customer added", 1000); this.Close(); this.Dispose(); } } catch (Exception ex) { notificationMAnager1.show("Data Cannot be Saved Pleasetry again", 1000); Console.WriteLine(ex.Message); } }
private void comboBox_item_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox_item.SelectedIndex > -1) { var sel = (comboBox_item.SelectedItem as Bills.ItemNameViwer).Item; using (var kdb = new HamroSuperMarketEntities()) { stock_qty.Text = kdb.items.Find(sel.id).stock.Value.ToString("00.00"); retailrate_fltb.Text = kdb.items.Find(sel.id).rate.Value.ToString("00.00"); floattb_wholesalerate.value = kdb.items.Find(sel.id).wholesaleprice.Value; } qty_fltb.Focus(); } }
private void textBox1_TextChanged(object sender, EventArgs e) { listView1.Items.Clear(); using (var db = new HamroSuperMarketEntities()) { var customers = db.customers.Where(o => o.name.Contains(textBox1.Text) || o.phone == textBox1.Text.Trim()).ToList(); foreach (customer c in customers) { CustomerViwer customerviwer = new CustomerViwer(c); listView1.Items.Add(customerviwer); } } }
public Expense_List() { InitializeComponent(); using (var db = new HamroSuperMarketEntities()) { foreach (expencecategory item in db.expencecategories.ToList()) { var cat = new expensecat_viwer() { id = item.id, category_name = item.name, Dock = DockStyle.Top, }; cat_loader.Controls.Add(cat); } } }
public Vendor_Details(int id) { InitializeComponent(); using (HamroSuperMarketEntities db = new HamroSuperMarketEntities()) { vendor v = db.vendors.First(o => o.id == id); this.id = id; venname_txt.Text = v.name; venaddr_txt.Text = v.adress; venphn_txt.Text = v.phoneno; venvat_txt.Text = v.vatno; venpan_txt.Text = v.panno; vendue_txt.Text = v.due.ToString(); venemail_txt.Text = v.email; venadvnc_txt.Text = v.advance.ToString(); } }
private void searchbox_KeyDown(object sender, KeyEventArgs e) { if (e.KeyData == Keys.Enter) { betterListView1.Items.Clear(); using (var db = new HamroSuperMarketEntities()) { List <ItemViwer> itemViwers = new List <ItemViwer>(); foreach (item n in db.items.Where(o => o.name.Contains(searchbox.Text)).ToList()) { itemViwers.Add(new ItemViwer(n, betterListView1.Items.Count + 1)); } betterListView1.Items.AddRange(itemViwers.ToArray()); //foreach (item n in db.items.Where(o => o.name.Contains(searchbox.Text)).ToList()) //{ // ItemViwer itemviwer = new ItemViwer(n,betterListView1.Items.Count+1); // betterListView1.Items.Add(itemviwer); //} } } }
private void DelToolStripMenuItem_Click(object sender, EventArgs e) { try { if (listView1.SelectedItems.Count > 0) { if (MessageBox.Show("Do You want To Delete this Customer", "Customers", MessageBoxButtons.YesNo) == DialogResult.Yes) { var sel = listView1.SelectedItems[0] as VenViwer; using (var db = new HamroSuperMarketEntities()) { var cus = db.vendors.Find(sel.id); db.Entry(cus).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } sel.Remove(); } } }catch (Exception ex) { notificationMAnager1.show("you can not delete this party records", 2000); } }
public void refresh() { using (HamroSuperMarketEntities db = new HamroSuperMarketEntities()) { var q = db.supplies; IQueryable <supply> supplies = q; if (radioButton_all.Checked) { supplies = q.Where(o => o.vendor_id == this.id); } else if (radioButton_due.Checked) { supplies = q.Where(o => o.vendor_id == this.id && o.due > 0); } else if (radioButton_paid.Checked) { supplies = q.Where(o => o.vendor_id == this.id && o.due > 0); } foreach (var item in supplies.ToList()) { betterListView1.Items.Add( new ListViewItem( new string[] { item.id.ToString(), item.bill_no.ToString(), item.total.ToString(), item.paid.ToString(), item.due.ToString(), RetailControls.Helpers.DateStampToString(item.day.Value) } ) ); } } }
private void delToolStripMenuItem_Click(object sender, EventArgs e) { if (betterListView1.SelectedItems.Count > 0) { if (MessageBox.Show("Do you Delete this item?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { try { using (var db = new HamroSuperMarketEntities()) { var sel = betterListView1.SelectedItems[0] as ItemViwer; var itm = db.items.Find(sel.id); db.Entry(itm).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); sel.Remove(); } } catch (Exception ex) { notificationMAnager1.show("this item you can not delete", 2000); } } } }
public SalesReport() { InitializeComponent(); db = new HamroSuperMarketEntities(); listBox_categories.Items.AddRange(db.categories.ToArray()); }