private void materialButton_save_Click(object sender, EventArgs e) { if (loaded) { this.Fiscalyear.name = betterTextBox_name.Text; this.Fiscalyear.startdate = nepaliCalender_startdate.Datestamp; this.Fiscalyear.enddate = nepaliCalender_endate.Datestamp; this.Fiscalyear.updated_at = DateTime.Now; db.Entry(this.Fiscalyear).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { this.Fiscalyear = new Model.fiscalyear() { name = betterTextBox_name.Text, startdate = nepaliCalender_startdate.Datestamp, enddate = nepaliCalender_endate.Datestamp, created_at = DateTime.Now, updated_at = DateTime.Now, admin_id = INFO.admin_id }; db.fiscalyears.Add(this.Fiscalyear); db.SaveChanges(); loaded = true; } }
private void materialButton1_update_Click(object sender, EventArgs e) { try { var editdata = db.menuitems.Find(id); editdata.name = betterTextBox1_name.Text; editdata.price = (betterTextBox1_price.decVal); editdata.unit = betterTextBox_units.Text; editdata.category_id = ((comboBox1_category.SelectedItem as Model.category).id); editdata.admin_id = INFO.admin_id; editdata.qty = betterTextBox1_qty.decVal; editdata.estimated_by = betterTextBox_Estimateby.Text; editdata.updated_at = DateTime.Now; db.Entry(editdata).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); edit?.Invoke(editdata); this.Close(); } catch (Exception ex) { CustomControls.Alert.show("delete your estimated items", "please delete first your all estimate items and and add your new estimated items", 5000); return; } }
private void materialButton_Edit_Click(object sender, EventArgs e) { if (Counter.counterstatus == 1) { CustomControls.Alert.show("Counter Viwer", "This Counter Is Currently Running, You Cannot Edit it.", 3000); } else { var edit = new Edit(this.Counter.id); edit.edit += (counter) => { db.Entry(this.Counter).Reload(); }; label_counter.Text = this.Counter.name; if (this.Counter.counterstatus == 1) { pictureBox.Image = Properties.Resources.Rms_connection_on; } else { pictureBox.Image = Properties.Resources.Rms_Connection_off; } CustomControls.Modal.Show(edit); } }
private void materialButton_addnew_Click(object sender, EventArgs e) { if (betterTextBox_counterno.Text.Trim() == "") { INFO.ShowAlert(Text, "Please Enter Counter Name", 3000); betterTextBox_counterno.Focus(); return; } //try //{ this.Counter.name = betterTextBox_counterno.Text; this.Counter.updated_at = DateTime.Now; this.Counter.created_at = DateTime.Now; db.Entry(this.Counter).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); edit?.Invoke(Counter); this.Close(); //} ////catch (Exception) //{ // CustomControls.Alert.show("Error", "data is not edited", 1500); //} }
private void materialButton_save_Click(object sender, EventArgs e) { var edit = db.purchaseitems.Find(id); edit.name = betterTextBox_name.Text; edit.qty = betterTextBox_currentstock.decVal; edit.unit = betterTextBox_unit.Text; edit.purchasecategory = ((comboBox_cate.SelectedItem as Model.purchasecategory)); db.Entry(edit).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); editdata?.Invoke(edit); this.Close(); }
private void checkBox_enabled_CheckedChanged(object sender, EventArgs e) { if (init) { if (this.user.name == "Admin") { CustomControls.Alert.show("Manage Users", "This is primary Account You Cannot Edit This Account", 4000); return; } this.user.enabled = checkBox_enabled.Checked; db.Entry(this.user).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); checkColor(); } }
private void materialButton_changeStatus_Click_1(object sender, EventArgs e) { int opencountercount = db.counters.Count(o => o.counterstatus == 2); if (opencountercount > 0) { CustomControls.Comformation.show("Day Management", "Please Ensure That all Counter Have been Closed"); return; } if (this.Systemsetting == null) { this.Systemsetting = new Model.systemsetting(); this.Systemsetting.currentdate = nepaliCalender.Datestamp; this.Systemsetting.dateopened = true; db.systemsettings.Add(this.Systemsetting); } else { if (this.Systemsetting.dateopened) { if (CustomControls.Comformation.show("Day Management", "Are You Sure, you want To Close Day") == DialogResult.Yes) { this.Systemsetting.dateopened = false; } else { return; } } else { if (CustomControls.Comformation.show("Day Management", "Check Following things-\n1.Date is Correct\nPress yes to Open Day ") == DialogResult.Yes) { this.Systemsetting.currentdate = nepaliCalender.Datestamp; this.Systemsetting.dateopened = true; } else { return; } } db.Entry(this.Systemsetting).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); refreshUI(); }
private void materialButton1_Click(object sender, EventArgs e) { try { if (saveondatabase) { db.Entry(Category).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } this.Parent.Controls.Remove(this); } catch (Exception ex) { MessageBox.Show("not deleted"); } }
private void materialButton_delete_Click(object sender, EventArgs e) { try { using (var db = new Model.ResturantManagementEntities()) { var i = db.menuitems.Where(o => o.id == this.id).Single(); db.Entry(i).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } this.Parent.Controls.Remove(this); } catch (Exception ex) { MessageBox.Show("not deleted"); } }
private void materialButton1_Click(object sender, EventArgs e) { var editcustomer = db.customers.Find(id); editcustomer.name = betterTextBox_name.Text; editcustomer.address = betterTextBox_address.Text; // editcustomer.panno=betterTextBox_panno.Text; editcustomer.phone = betterTextBox_phone.Text; editcustomer.email = betterTextBox_email.Text; // editcustomer.currentdue=betterTextBox_currentDue.decVal; //editcustomer.currentadvance=betterTextBox_currentAdvance.decVal; editcustomer.nationality = betterTextBox_nationality.Text; editcustomer.creadted_at = DateTime.Now; editcustomer.updated_at = DateTime.Now; editcustomer.admin_id = INFO.admin_id; db.Entry(editcustomer).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); edit?.Invoke(editcustomer); this.Close(); }
public void save() { var load = db.purchaseitems.Find(id); load.qty -= qty; db.Entry(load).State = System.Data.Entity.EntityState.Modified; var billitem = new Model.wastagepurchaseitem() { purchaseitem_id = id, qty = qty, date = date, unit = unit, created_at = DateTime.Now, upadated_at = DateTime.Now, admins_id = INFO.admin_id, fiscalyear_id = INFO.currentFiscalYear.id }; db.wastagepurchaseitems.Add(billitem); db.SaveChanges(); }
private void materialButton_save_Click(object sender, EventArgs e) { if (betterTextBox_password.Text.Trim() == "" || betterTextBox_retypepassword.Text.Trim() == "") { CustomControls.Alert.show("Password Change", "Password Cannot be blank", 3000); return; } if (betterTextBox_password.Text.Trim() != betterTextBox_retypepassword.Text.Trim()) { CustomControls.Alert.show("Password Change", "Please Rematch the password", 3000); return; } var user = db.admins.Find(this.admin_id); user.password = CustomControls.Encrypt.EncryptString(betterTextBox_password.Text.Trim(), "need12345"); db.Entry(user).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); this.Close(); }
private void materialButton_save_Click(object sender, EventArgs e) { if (betterListView1.Items == null) { CustomControls.Alert.show("Empty Items", "Please selcet item and enter price and quantity", 3000); return; } if (comboBox_party.SelectedIndex == -1) { CustomControls.Alert.show("Empty Items", "Please selcet Party in parties list", 3000); return; } Model.purchaseinvoice addnew = new Model.purchaseinvoice() { grosstotal = betterTextBox_grosstotal.decVal, discount = betterTextBox_discount.decVal, tax = betterTextBox_Tax.decVal, nettotal = betterTextBox_nettotal.decVal, due = betterTextBox_Due.decVal, paid = betterTextBox_paid.decVal, fiscalyear_id = INFO.currentFiscalYear.id, admin_id = INFO.admin_id, created_at = DateTime.Now, updated_at = DateTime.Now, date = INFO.currentdate, parties_id = (comboBox_party.SelectedItem as Model.party).id }; Model.party_ledgers party_Ledger = new party_ledgers() { date = INFO.currentdate, amount = betterTextBox_Due.decVal, due = 0, returnamount = 0, type = "CR", party_id = (comboBox_party.SelectedItem as Model.party).id, created_at = DateTime.Now, updated_at = DateTime.Now, }; db.party_ledgers.Add(party_Ledger); //if (checkBox_party.Checked) //{ // if (comboBox_party.SelectedIndex< 0) // { // CustomControls.Alert.show("", "select party", 2000); // return; // } //var venderdata = (party)comboBox_party.SelectedItem; //addnew.parties_id = venderdata.id; //var vender = db.parties.Where(o => o.id == venderdata.id).First(); //if (checkBox_advance.Checked) //{ // if (betterTextBox_advance.decVal > vender.advance) // { // vender.advance = 0; // } // else // { // vender.advance -= betterTextBox_advance.decVal; // } //} //if (betterTextBox_Due.decVal > 0) //{ // if (checkBox_advance.Checked) // { // if (betterTextBox_advance.decVal >= betterTextBox_Due.decVal) // { // betterTextBox_Due.decVal = 0; // } // else // { // betterTextBox_Due.decVal -= betterTextBox_advance.decVal; // } // } // vender.due += betterTextBox_Due.decVal; // db.Entry(vender).State = System.Data.Entity.EntityState.Modified; // db.SaveChanges(); //} db.purchaseinvoices.Add(addnew); db.SaveChanges(); purchase_id = addnew.id; foreach (ListViewItem item in betterListView1.Items) { var quantity = Convert.ToDecimal(item.SubItems[3].Text); var unit = item.SubItems[4].Text; var rate = Convert.ToDecimal(item.SubItems[5].Text); var total = Convert.ToInt32(item.SubItems[6].Text); var item_id = Convert.ToInt32(item.SubItems[7].Text); var purchase_item = db.purchaseitems.Find(item_id); purchase_item.qty += quantity; db.Entry(purchase_item).State = System.Data.Entity.EntityState.Modified; purchaseinvoiceitem newstock = new purchaseinvoiceitem() { purchaseitems_id = item_id, price = rate, qty = quantity, unit = unit, purchaseinvoice_id = purchase_id, admin_id = INFO.admin_id, updated_at = DateTime.Now, created_at = DateTime.Now, }; db.purchaseinvoiceitems.Add(newstock); db.SaveChanges(); } foreach (ListViewItem item in betterListView_Exp.Items) { var item_name = item.SubItems[0].Text; var amount = Convert.ToDecimal(item.SubItems[1].Text); purchseexpens exp = new Model.purchseexpens() { purchaseinvoice_id = purchase_id, name = item_name, amount = amount, date = INFO.currentdate, admin_id = INFO.admin_id, updated_at = DateTime.Now, created_at = DateTime.Now, fiscalyear_id = INFO.currentFiscalYear.id }; db.purchseexpenses.Add(exp); db.SaveChanges(); } betterListView1.Items.Clear(); betterListView_Exp.Items.Clear(); //if (checkBox_party.Checked) //{ // comboBox_party.SelectedIndex = -1; //} betterTextBox_rate.Clear(); betterTextBox_quantity.Clear(); betterTextBox_grosstotal.Clear(); betterTextBox_discount.Clear(); betterTextBox_Tax.Clear(); betterTextBox_Due.Clear(); betterTextBox_paid.Clear(); betterTextBox_Return.Clear(); }
private void materialButton_accecptAmount_Click(object sender, EventArgs e) { if (betterTextBox_accecpted.decVal == 0) { CustomControls.Alert.show("Counter Management", "Accecpted Value Cannot Be Zero", 5000); return; } if (CustomControls.Comformation.show("Counter Management", "Please Check Following Detail are Correct:\n" + "1. Counter Number is " + label_counterno.Text + "\n" + "2. Requested Amount is " + label_amount.Text + "\n" + "3. Accecpted Amount is " + betterTextBox_accecpted.Text) == DialogResult.Yes) { this.Counterstatus.approved = true; this.Counterstatus.status = 1; this.Counterstatus.approvedamount = betterTextBox_accecpted.decVal; this.Counterstatus.currentstock = betterTextBox_accecpted.decVal; this.Counterstatus.updated_at = DateTime.Now; db.Entry(this.Counterstatus).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); this.Parent.Controls.Remove(this); } //if (betterTextBox_accecpted.decVal == 0) //{ // CustomControls.Alert.show("Counter Management", "Accecpted Value Cannot Be Zero", 5000); // return; //} //if(CustomControls.Comformation.show("Counter Management", "Please Check Following Detail are Correct:\n" + // "1. Counter Number is " + label_counterno.Text + "\n" + // "2. Requested Amount is " + label_amount.Text+"\n" + // "3. Accecpted Amount is"+betterTextBox_accecpted.Text)== DialogResult.Yes) //{ // this.Counterstatus.approved = true; // this.Counterstatus.status = 1; // db.Entry(this.Counterstatus).State = System.Data.Entity.EntityState.Modified; // db.SaveChanges(); // var dayopen = new Model.counteropening() // { // date = this.Counterstatus.date, // admin_id = INFO.admin_id, // state = 1, // updated_at=DateTime.Now, // created_at=DateTime.Now, // amount = betterTextBox_accecpted.decVal, // counter_id=this.Counterstatus.counter_id // }; // var counterstock = new Model.counterstock() // { // date = this.Counterstatus.date, // admin_id = INFO.admin_id, // state = 1, // updated_at = DateTime.Now, // created_at = DateTime.Now, // amount = betterTextBox_accecpted.decVal, // counter_id = this.Counterstatus.counter_id, // }; // db.counteropenings.Add(dayopen); // db.counterstocks.Add(counterstock); // db.SaveChanges(); // this.Parent.Controls.Remove(this); //} }