private void DeleteBtn_Click(object sender, EventArgs e) { if (givingDataGridView.Rows.Count == 0) { return; } int id = Convert.ToInt32(givingDataGridView.SelectedRows[0].Cells["givingId"].Value); GivingsController gc = new GivingsController(); Giving giving = gc.Show(id); DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete Oferring of " + giving.member.firstName + "\n NOTE: this action cannot be undone!", "Delete Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (dialogResult == DialogResult.No) { return; } else if (dialogResult == DialogResult.Yes) { giving.Delete(); MessageBox.Show("Offering Type Deleted from records!", "Offering Type Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadGivings(); } }
private void GivingDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e) { GivingsController gc = new GivingsController(); Giving g = gc.Show((int)givingDataGridView.SelectedRows[0].Cells["givingId"].Value); if (g != null) { LoadGivingItems(g); } }
public GivingItem(DataRow r) { GivingsController gc = new GivingsController(); GivingTypesController gtc = new GivingTypesController(); this.id = Convert.ToInt32(r["givingItemId"]); this.giving = gc.Show(Convert.ToInt32(r["givingId"])); this.givingType = gtc.Show(Convert.ToInt32(r["givingTypeId"])); this.amount = Convert.ToDouble(r["amount"]); this.note = r["note"].ToString(); }
public void Update(Member member, DateTime givingDate, Service service) { GivingsController gc = new GivingsController(); gc.Update(id, new Param("memberId", member.id), new Param("givingDate", givingDate), new Param("serviceId", service.id) ); this.member = member; this.givingDate = givingDate; }
private void EditBtn_Click(object sender, EventArgs e) { if (givingDataGridView.Rows.Count == 0) { return; } GivingsController gc = new GivingsController(); Giving giving = gc.Show(Convert.ToInt32(givingDataGridView.SelectedRows[0].Cells["givingId"].Value)); AddUpdateGivingFrm addGivingFrm = new AddUpdateGivingFrm(true, giving); addGivingFrm.FormClosing += new FormClosingEventHandler(this.GivingUpdated); addGivingFrm.ShowDialog(); }
public override void Add(params Param[] @params) { if (@params.Length != 4) { return; } GivingsController gc = new GivingsController(); GivingTypesController gtc = new GivingTypesController(); if (gc.Show((int)@params[0].value) == null || gtc.Show((int)@params[1].value) == null) { MessageBox.Show("Offering or Offering Type not found!", "Offering Item Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } base.Add(@params); }
public Giving(Member member, DateTime givingDate, Service service, Session session) { GivingsController gc = new GivingsController(); gc.Add(new Param("memberId", member.id), new Param("givingDate", givingDate), new Param("entryDate", DateTime.Now), new Param("serviceId", service.id), new Param("sessionId", session.id) ); Giving g = gc.GetLastAdded(); MembersController mc = new MembersController(); this.member = g.member; this.givingDate = g.givingDate; this.entryDate = g.entryDate; this.service = g.service; this.session = g.session; }
public void LoadGivings() { GivingsController givingsController = new GivingsController(); if ((Service)servicesCmbBx.SelectedValue == null) { return; } givings = currentSession.user.isAdmin? givingsController.ShowAllWithinScope((Service)servicesCmbBx.SelectedValue, givingDateDateTimePicker.Value): givingsController.ShowAllWithinScope((Service)servicesCmbBx.SelectedValue, givingDateDateTimePicker.Value, currentSession); //givings = givingsController.ShowAll(); ResetGivingTable(); //rows double total = 0; if (givings.Count > 0) { foreach (Giving giving in givings) { givingDataGridView.Rows.Add( giving.id, giving.member.FullName(), giving.givingDate.ToString("MMMM dd, yyyy"), giving.entryDate.ToString("MMMM dd, yyyy") ); total += giving.totalAmount(); } givingDataGridView.ClearSelection(); givingDataGridView.Rows[givings.Count - 1].Selected = true; LoadGivingItems(givings[givings.Count - 1]); } else { ResetGivingItemsTable(); //selectedGiving = null; // MessageBox.Show("No offering are currently registered in the system. Please add an offering!", "No Offering Found!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } totalOfferingTxt.Text = total.ToString("C", CultureInfo.CurrentCulture); }
private void LoadGivingItems(Giving g) { selectedGiving = g; giverNameTxt.Text = g.member.FullName(); givingItemsDateTimePicker.Value = g.givingDate; List <GivingItem> givingItems = g.givingItems(); ResetGivingItemsTable(); //rows if (givingItems.Count > 0) { foreach (GivingItem givingItem in givingItems) { givingItemsDataGridView.Rows.Add( givingItem.id, givingItem.givingType.title, givingItem.amount, givingItem.note ); } givingItemsDataGridView.ClearSelection(); givingItemsDataGridView.Rows[givingItems.Count - 1].Selected = true; } totalTxt.Text = g.totalAmount().ToString("C", CultureInfo.CurrentCulture); GivingsController givingsController = new GivingsController(); givings = givingsController.ShowAll(); double total = 0; foreach (Giving giving in givings) { total += giving.totalAmount(); } totalOfferingTxt.Text = total.ToString("C", CultureInfo.CurrentCulture); }
public void Delete() { GivingsController gc = new GivingsController(); gc.Delete(id); }