private void btnSave_Click(object sender, EventArgs e) { revenue _revenue = new revenue(); if (IsEdit == true) { _revenue = _db.GetRevenueById(this.RecordId, databaseId); } _revenue.Users = Convert.ToInt32(txtUsers.Text); _revenue.PriceFixedUntil = rdPriceFixedUnitl.Value; _revenue.RevenueAmount = Convert.ToDecimal(txtRevenue.Text); _revenue.customerid = CustomerId; _revenue.Year = Convert.ToInt16(cboYear.Text); _revenue.isActive = true; _revenue.CreatedDate = DateTime.Now; _revenue.databaseID = databaseId; if (IsEdit == false) { _db.AddToRevenue(_revenue); _db.SaveChanges(); MessageBox.Show("Revenue Saved", "Revenue has been Created ", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { _db.SaveRevenue(_revenue); _db.SaveChanges(); MessageBox.Show("Revenue Saved", "Revenue has been updated ", MessageBoxButtons.OK, MessageBoxIcon.Information); } this.Close(); }
public void SaveRevenue(revenue _reve) { try { using (var ctx = new customerDbEntities()) { ctx.revenues.Add(_reve); ctx.Entry(_reve).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } }
public void addExpense(double amt, string lbl) { revenue newExpense = new revenue(); newExpense.amount = amt; newExpense.label = lbl; expenses.Add(newExpense); }
public void addIncome(double amt, string lbl) { revenue newIncome = new revenue(); newIncome.amount = amt; newIncome.label = lbl; incomes.Add(newIncome); }
public revenue GetRevenueById(int id, int databaseId) { revenue q = new revenue(); using (var myContext = new customerDbEntities()) { q = myContext.revenues.Where(w => w.id == id && w.databaseID == databaseId).FirstOrDefault(); } return(q); }
private void btnDeleteRevenue_Click(object sender, EventArgs e) { revenue _deleteRevenue = new revenue(); _deleteRevenue = CustomerDb.GetRevenueById(Revenueid, DatabaseId); DialogResult dialogResult = MessageBox.Show(this, "Are you sure you wish to Delete Revenue ", "Delete Revenue", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dialogResult == DialogResult.Yes) { CustomerDb.DeleteRevenue(_deleteRevenue); BindRevenue(CustomerId); } else if (dialogResult == DialogResult.No) { //do something else } BindRevenue(CustomerId); }
private void frmRevenue_Load(object sender, EventArgs e) { if (IsEdit) { revenue _revenue = new revenue(); _revenue = _db.GetRevenueById(this.RecordId, databaseId); txtUsers.Text = _revenue.Users.ToString(); txtRevenue.Text = _revenue.RevenueAmount.ToString(); cboYear.SelectedText = _revenue.Year.ToString(); if (_revenue.PriceFixedUntil != null) { rdPriceFixedUnitl.Value = (DateTime)_revenue.PriceFixedUntil; } } cboYear.DataSource = Enumerable.Range(2015, DateTime.Today.Year).ToList(); }
public void AddToRevenue(revenue newReve) { using (var myContext = new customerDbEntities()) { myContext.revenues.Add(newReve); try { myContext.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Console.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } }
private void txtrevenuecode_LostFocus(object sender, RoutedEventArgs e) { try { revenue rev = new revenue(); string a = "Update", b = Convert.ToString(Save.Content); if (b == a) { rev.REVENUE_CODE = txtrevenuecode.Text; rev.UPDATE_BY = login.u; rev.UPDATE_DATE = DateTime.Today; rev.Retrive(); txtname.Text = rev.NAME; COMBOBOX2.Text = rev.MISCELLANOUS; COMBOBOX3.Text = rev.PRINT_VOUCHER; txttaxstructure.Text = rev.TAX_STRUCTURE; txtmistaxstructure.Text = rev.MIS_TAX_STRUCTURE; COMBOBOX4.Text = rev.STATUS; } } catch (Exception) { } }
private void Save_Click(object sender, RoutedEventArgs e) { try { if (error != 0 || txtrevenuecode.Text == "" || txtname.Text == "" || txttaxstructure.Text == "" || txtmistaxstructure.Text == "") { // pop1.IsOpen = true; if (txtrevenuecode.Text == "") { txtrevenuecode.Text = ""; } if (txtname.Text == "") { txtname.Text = ""; } if (txttaxstructure.Text == "") { txttaxstructure.Text = ""; } if (txtmistaxstructure.Text == "") { txtmistaxstructure.Text = ""; } } else { revenue rev = new revenue(); rev.REVENUE_CODE = txtrevenuecode.Text; rev.NAME = txtname.Text; rev.MISCELLANOUS = COMBOBOX2.Text; rev.PRINT_VOUCHER = COMBOBOX3.Text; rev.TAX_STRUCTURE = txttaxstructure.Text; rev.MIS_TAX_STRUCTURE = txtmistaxstructure.Text; rev.STATUS = COMBOBOX4.Text; // ss rr ii u ii 11/15/2017 //rev.USER_NAME = login.u; rev.INSERT_BY = login.u; rev.INSERT_DATE = DateTime.Today; // add.IsEnabled = true; // Modify.IsEnabled = true; // Save.IsEnabled = false; // clear.IsEnabled = false; string a1 = "Save", b1 = Convert.ToString(Save.Content); if (b1 == a1) { //Save.Content = "Save"; //insert.Content = "Inserted Sucessfully"; //pop2.IsOpen = true; rev.Insert(); DataTable dt = rev.fill_revenuegrid(); dgrevenue.ItemsSource = dt.DefaultView; //MessageBox.Show("inserted sucessfully"); popup_insert.IsOpen = true; } string a = "Update", b = Convert.ToString(Save.Content); if (b == a) { //insert.Content = "Updated Sucessfully"; //pop2.IsOpen = true; rev.UPDATE(); DataTable dt = rev.fill_revenuegrid(); dgrevenue.ItemsSource = dt.DefaultView; //MessageBox.Show("updated sucessfully"); popup_update.IsOpen = true; } clearing(); this.NavigationService.Refresh(); txtrevenuecode.IsEnabled = false; txttaxstructure.IsEnabled = false; txtname.IsEnabled = false; txtmistaxstructure.IsEnabled = false; COMBOBOX2.IsEnabled = false; COMBOBOX3.IsEnabled = false; COMBOBOX4.IsEnabled = false; Save.Content = "Save"; // add.Background = new SolidColorBrush(Color.FromRgb(53, 71, 102)); // Modify.Background = new SolidColorBrush(Color.FromRgb(53, 71, 102)); } } catch (Exception) { MessageBox.Show("please Enter correct values"); } }