private void materialButton1_Click_1(object sender, EventArgs e) { var savecreditnote = new Models.creditnote() { amount = betterTextBox_total.decVal, bill_id = invoicenumber_text.intVal, date = Dashboard.Instance.nepaliCalender1.DATESTAMP, checkreturnbills = false, updated_at = DateTime.Now, created_at = DateTime.Now, }; db.creditnotes.Add(savecreditnote); var bill = db.bills.Find(invoicenumber_text.intVal); var customer = db.customers.Find(bill.customer_id); if (customer != null) { customer.due -= betterTextBox_total.decVal; db.Entry(customer).State = System.Data.Entity.EntityState.Modified; } bill.checkreturnbills = false; db.Entry(bill).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); foreach (var item in betterListView_salesreturn.Items.Cast <SalesReturns.Viewer>().ToList()) { item.save(savecreditnote.id); } SalesReturns.Printcreditnote print = new Printcreditnote(); print.print(savecreditnote); betterListView_salesreturn.Items.Clear(); invoicenumber_text.Clear(); betterTextBox_discount.Clear(); betterTextBox_total.Clear(); }
private void save_btn_Click(object sender, EventArgs e) { try { if (textBox1_name.Text.Trim() == "") { notificationMAnager1.show("please enter category", 1000); return; } var editcate = db.categories.Where(o => o.id == id).First(); editcate.name = textBox1_name.Text; editcate.updated_at = DateTime.Now; editcate.created_at = DateTime.Now; db.Entry(editcate).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); notificationMAnager1.show("successfully modify your category", 1000); this.Close(); if (edit != null) { edit(this, new DataSaveargs() { data = editcate }); } }catch (Exception ex) { notificationMAnager1.show("your category is not modify please try agarin", 1000); } }
private void label2_Click(object sender, EventArgs e) { try { employee emp = db.employees.Where(o => o.id == id).First(); { emp.name = EmpName.Text; emp.adress = EmpAdr.Text; emp.phone = EmpPhn.Text; emp.salary = Convert.ToDecimal(EmpSalary.Text); emp.email = EmpEmail.Text; emp.photo = EmpImage.ImageLoc; emp.startdate = nepaliCalender2EmpsrtDate.engdate; db.Entry(emp).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); notificationMAnager1.show("data are successully edited....", 2000); this.Close(); } } catch (Exception ex) { notificationMAnager1.show("some error data are not edited please try again", 2000); return; } }
private void label2_Click(object sender, EventArgs e) { if (expname.Text.Trim() == "" || expamount.Text.Trim() == "" || expdescription.Text.Trim() == "") { notificationMAnager1.show("please fill the data", 2000); return; } try { expence exp = db.expences.Where(o => o.id == id).First(); exp.name = expname.Text; exp.amount = Convert.ToDecimal(expamount.Text); exp.descriptions = expdescription.Text; exp.dates = nepaliCalender1.engdate; exp.day = nepaliCalender1.DATESTAMP; exp.created_at = DateTime.Now; exp.updated_at = DateTime.Now; db.Entry(exp).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); notificationMAnager1.show("data are successfully edited", 2000); this.Dispose(); } catch (Exception ex) { notificationMAnager1.show("some error please try again", 2000); } }
private void label2_Click(object sender, EventArgs e) { if (expname_txt.Text.Trim() == "") { notificationMAnager1.show("please fill the expenses category name", 2000); return; } try { expencecategory expense = db.expencecategories.Where(o => o.id == id).First(); expense.name = expname_txt.Text; db.Entry(expense).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); if (edit != null) { edit(this, new Custom.DataSaveargs { data = expense }); } notificationMAnager1.show("data are successfully saved", 2000); this.Dispose(); } catch (Exception ex) { notificationMAnager1.show(" please try again", 2000); } }
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 materialButton1_delete_Click(object sender, EventArgs e) { try { expencecategory exp = db.expencecategories.Where(o => o.id == this.id).First(); db.Entry(exp).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); notificationMAnager1.show("the data are successfully deleted", 2000); this.Parent.Controls.Remove(this); } catch (Exception ex) { notificationMAnager1.show("it has many sub type of expences first delete all sub type of expences", 4000); return; } }
private void label2_Click(object sender, EventArgs e) { if (venname_txt.Text.Trim() == "") { notificationMAnager1.show("please fill the name", 1000); return; } if (venaddr_txt.Text.Trim() == "") { notificationMAnager1.show("please fill the address", 1000); return; } if (venphn_txt.Text == "") { notificationMAnager1.show("please fill the phone", 1000); return; } try { vendor vendor = db.vendors.Where(o => o.id == id).First(); vendor.name = venname_txt.Text; vendor.adress = venaddr_txt.Text; vendor.panno = pannum_txt.Text; vendor.email = vanemail_txt.Text; vendor.vatno = vatnum_txt.Text; vendor.phoneno = venphn_txt.Text; vendor.due = Convert.ToDecimal(vendue_txt.Text); vendor.advance = Convert.ToDecimal(vanadvnc_txt.Text); vendor.created_at = DateTime.Now; vendor.updated_at = DateTime.Now; db.Entry(vendor).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); notificationMAnager1.show("successfully data has been saved", 10000); if (onDataEdited != null) { onDataEdited(this, new DataSaveargs() { data = vendor }); } } catch (Exception) { notificationMAnager1.show("please try again", 1000); } this.Close(); }
private void delete_btn_Click(object sender, EventArgs e) { try { expence exp = db.expences.Where(o => o.id == this.id).First(); db.Entry(exp).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); this.Parent.Controls.Remove(this); notificationMAnager1.show("data are successfully deleted", 2000); } catch (Exception ex) { notificationMAnager1.show("it has some problem please try again", 2000); return; } }
private void label2_Click(object sender, EventArgs e) { if (cusname.Text.Trim() == "") { notificationMAnager1.show("plese Enter customer name", 1000); return; } if (cusadr.Text.Trim() == "") { notificationMAnager1.show("plese Enter customer address", 1000); return; } if (cusphn.Text.Trim() == "") { notificationMAnager1.show("plese Enter customer phone", 1000); return; } try { customer c = db.customers.Where(o => o.id == id).First(); c.name = customername.Text; c.adress = customeradress.Text; c.email = customeremail.Text; c.phone = customerphoneno.Text; c.due = Convert.ToDecimal(cusdue_txt.Text); c.created_at = DateTime.Now; c.updated_at = DateTime.Now; db.Entry(c).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); if (onDataEdited != null) { onDataEdited(this, new DataSaveargs() { data = c }); } } catch (Exception) { notificationMAnager1.show("data are not saved ", 1000); } this.Close(); }
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); } }
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); } } } }
private void materialButton2_Click(object sender, EventArgs e) { if (billnum_txt.Text.Trim() == "") { notificationMAnager1.show("please fill the bill number", 1000); return; } supply Supply = new supply() { bill_no = billnum_txt.Text, paid = paid, discount = discount, due = due, dates = Dashboard.Instance.nepaliCalender1.engdate, tax = taxs, grosstotal = Grosstotal, total = nettotal, day = Dashboard.Instance.nepaliCalender1.DATESTAMP, created_at = DateTime.Now, updated_at = DateTime.Now }; if (SupplierCheck_btn.Checked) { if (combobox_supplier.SelectedIndex < 0) { MessageBox.Show("Please select A supplier"); return; } var selvendor = (vendor)combobox_supplier.getSelectedItem().data; Supply.vendor_id = selvendor.id; var supplier = db.vendors.First(o => o.id == selvendor.id); if (checkBox_useadvance.Checked) { if (advance_fltb.value >= supplier.advance.Value) { supplier.advance = 0; } else { supplier.advance -= advance_fltb.value; } } if (due > 0) { if (checkBox_useadvance.Checked) { if (advance_fltb.value >= due) { due = 0; } else { due -= advance_fltb.value; } } supplier.due += due; } db.Entry(supplier).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } db.supplies.Add(Supply); db.SaveChanges(); foreach (ListViewItem item in betterlistview1.Items) { var Item_id = Convert.ToInt32(item.SubItems[4].Text); var Rate = Convert.ToDecimal(item.SubItems[1].Text); var Quantity = Convert.ToDecimal(item.SubItems[2].Text); var Amount = Convert.ToDecimal(item.SubItems[3].Text); var Item = db.items.Find(Item_id); Item.stock += Quantity; Item.buyrate = Rate; db.Entry(Item).State = System.Data.Entity.EntityState.Modified; supplyitem supplyitem = new supplyitem() { rate = Rate, item_id = Item_id, quantity = Quantity, amount = Amount, supply_id = Supply.id }; db.supplyitems.Add(supplyitem); db.SaveChanges(); } betterlistview1.Items.Clear(); billnum_txt.Clear(); Grostotal_txt.Clear(); Discount_txt.Clear(); paid_txt.Clear(); tax_txt.Clear(); due_txt.Clear(); SupplierCheck_btn.Checked = false; }
private void materialButton2_Click(object sender, EventArgs e) { if (betterlistview1.Items.Count == 0) { notificationMAnager1.show("please select your items and enter quantity.", 2000); return; } if (due_txt.decVal > 0 && comboBox_customer.SelectedItem == null) { notificationMAnager1.show("Please select customer for dueable amount.", 3000); return; } bill savebill = new bill() { paid = paid_txt.decVal, due = due_txt.decVal, grosstotal = Grosstotal_txt.decVal, discount = Discount_txt.decVal, tax = tax_txt.decVal, dates = Dashboard.Instance.nepaliCalender1.engdate, total = nettotal_txt.decVal, day = Dashboard.Instance.nepaliCalender1.DATESTAMP, returns = return_fltb.decVal, checkreturnbills = true, created_at = DateTime.Now, updated_at = DateTime.Now }; if (checkBox1.Checked == true) { if (comboBox_customer.SelectedItem != null) { var selcustomer = (customer)comboBox_customer.SelectedItem; savebill.customer_id = selcustomer.id; if (Convert.ToDecimal(due_txt.Text) > 0) { var cus = db.customers.Find(selcustomer.id); cus.due += Convert.ToDecimal(due_txt.Text); db.Entry(cus).State = System.Data.Entity.EntityState.Modified; } } else { notificationMAnager1.show("please select old customer or add a new customer ", 2000); return; } } else { if (due_txt.decVal > 0 && comboBox_customer.SelectedItem == null) { notificationMAnager1.show("Please select customer for dueable amount.", 3000); return; } } db.bills.Add(savebill); db.SaveChanges(); foreach (var item in betterlistview1.Items.Cast <Bills_form.Viwer>().ToList()) { item.save(savebill.id); } betterlistview1.Items.Clear(); Grosstotal_txt.Clear(); Discount_txt.Clear(); tax_txt.Clear(); nettotal_txt.Clear(); paid_txt.Clear(); due_txt.Clear(); qty_fltb.Clear(); return_fltb.Clear(); comboBox_item.SelectedIndex = -1; comboBox_customer.SelectedIndex = -1; floattb_wholesalerate.Clear(); retailrate_fltb.Clear(); stock_qty.Clear(); }
private void label2_Click(object sender, EventArgs e) { if (itemeditname_txt.Text.Trim() == "") { notificationMAnager1.show("please enter your item name", 1000); return; } if (comboBox_category.SelectedItem == null) { notificationMAnager1.show("please select catrgory", 1000); return; } if (bettertextbox_barcode.Text.Trim() == "") { notificationMAnager1.show("Point Barcode Reader properly to the product or, if product has no Barcode then, type 'Na' in barcode field", 2000); bettertextbox_barcode.Focus(); return; } if (floattb_cost.value > price_fltb.value) { if (Comformation.ShowModal("Please Confirm Your Selling Rate", ", Your selling price is less then cost price please check and confirm", true) == DialogResult.OK) { ; } } if (floattb_wholesaleprice.value > price_fltb.value) { if (Comformation.ShowModal("Please Confirm Your wholesale Rate", ", are you sure your selling price is less then wholesale ?", true) == DialogResult.OK) { ; } } if (floattb_wholesaleprice.value == 0) { floattb_wholesaleprice.value = price_fltb.value; } else { floattb_wholesaleprice.value = floattb_wholesaleprice.value; } try { item a = db.items.Where(o => o.id == id).First(); a.name = itemeditname_txt.Text; a.category_id = (comboBox_category.SelectedItem as Models.category).id; a.stock = stock_fltb.value; a.rate = price_fltb.value; a.buyrate = floattb_cost.value; a.barcode = bettertextbox_barcode.Text; a.wholesaleprice = floattb_wholesaleprice.value; a.created_at = DateTime.Now; a.updated_at = DateTime.Now; db.Entry(a).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); if (onDataEdited != null) { onDataEdited(this, new DataSaveargs() { data = a }); } } catch (Exception) { notificationMAnager1.show("data can not be saved", 1000); } this.Close(); }