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