public void LoadForm() { ServicesController sc = new ServicesController(); List <Service> services = sc.ShowAll(); servicesDataGridView.Rows.Clear(); servicesDataGridView.Columns.Clear(); servicesDataGridView.Refresh(); //setup //columns servicesDataGridView.Columns.Add("serviceId", "ID"); servicesDataGridView.Columns.Add("name", "Service Name"); servicesDataGridView.Columns.Add("day", "Service Day"); servicesDataGridView.Columns["serviceId"].Visible = false; //rows if (services.Count > 0) { foreach (Service service in services) { servicesDataGridView.Rows.Add( service.id, service.name, service.DayFullName() ); } } else { MessageBox.Show("No servicse are currently registered in the system. Please add a service!", "No Service Found!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }
private void GivingFrm_Load(object sender, EventArgs e) { servicesCmbBx.SelectedIndexChanged -= new System.EventHandler(this.ServicesCmbBx_SelectedIndexChanged); ServicesController sc = new ServicesController(); services = sc.ShowAll(); if (services.Count > 0) { UpdateDateTimePicker(services[0]); Dictionary <Service, string> serviceLibrary = new Dictionary <Service, string>(); foreach (Service service in services) { serviceLibrary.Add(service, service.name); } servicesCmbBx.DataSource = new BindingSource(serviceLibrary, null); servicesCmbBx.DisplayMember = "Value"; servicesCmbBx.ValueMember = "Key"; servicesCmbBx.SelectedIndexChanged += new System.EventHandler(this.ServicesCmbBx_SelectedIndexChanged); //servicesCmbBx.SelectedIndex = 0; } else { MessageBox.Show("No service registered. Please Create a service type first!.", "Service Unavailable", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.Close(); } LoadGivings(); }
public void LoadForm() { //loads UI for Update or Add this.Text = IsUpdate ? "Edit Offering" : "Add Offering"; this.submitBtn.Text = IsUpdate ? "Submit" : "Create"; this.AcceptButton = submitBtn; //loads memebers MembersController mc = new MembersController(); List <Member> members = mc.ShowAll(); if (members.Count > 0) { List <KeyValuePair <int, string> > membersLibrary = new List <KeyValuePair <int, string> >(); foreach (Member member in members) { membersLibrary.Add(new KeyValuePair <int, string>(member.id, member.firstName + " " + member.lastName)); } membersCmbBx.DataSource = membersLibrary.ToList <KeyValuePair <int, string> >();//new BindingSource(membersLibrary, null); membersCmbBx.DisplayMember = "Value"; membersCmbBx.ValueMember = "Key"; if (IsUpdate) { membersCmbBx.SelectedValue = currentGiving.member.id; } else { membersCmbBx.SelectedIndex = 0; } } //loads services ServicesController sc = new ServicesController(); List <Service> services = sc.ShowAll(); if (services.Count > 0) { List <KeyValuePair <int, string> > servicesLibrary = new List <KeyValuePair <int, string> >(); foreach (Service service in services) { servicesLibrary.Add(new KeyValuePair <int, string>(service.id, service.name)); } serviceCmbBox.DataSource = servicesLibrary.ToList <KeyValuePair <int, string> >();//new BindingSource(membersLibrary, null); serviceCmbBox.DisplayMember = "Value"; serviceCmbBox.ValueMember = "Key"; if (IsUpdate) { serviceCmbBox.SelectedValue = currentGiving.service.id; } else { serviceCmbBox.SelectedValue = addedService.id; } } //load date givingDateDateTimePicker.Value = IsUpdate ? currentGiving.givingDate : addedDate; }
public void Update(string name, int day) { ServicesController sc = new ServicesController(); Service service = sc.Update(this.id, new Param("name", name), new Param("day", day) ); this.name = service.name; this.day = service.day; }
public Service(string name, int day) { ServicesController sc = new ServicesController(); sc.Add( new Param("name", name), new Param("day", day) ); Service s = sc.GetLastAdded(); this.id = s.id; this.name = s.name; this.day = s.day; }
private void EditServiceToolStripMenuItem_Click(object sender, EventArgs e) { if (servicesDataGridView.Rows.Count == 0) { return; } Service s = new ServicesController().Show((int)servicesDataGridView.SelectedRows[0].Cells["serviceId"].Value); AddUpdateServiceFrm addFrm = new AddUpdateServiceFrm(true, s); addFrm.FormClosing += new FormClosingEventHandler(this.ServicesUpdated); addFrm.ShowDialog(); }
public Giving(DataRow r) { try { MembersController mc = new MembersController(); ServicesController sc = new ServicesController(); SessionsController sesC = new SessionsController(); this.id = Convert.ToInt32(r["givingId"]); this.member = mc.Show(Convert.ToInt32(r["memberId"])); this.givingDate = Convert.ToDateTime(r["givingDate"]); this.entryDate = Convert.ToDateTime(r["entryDate"]); this.service = sc.Show(Convert.ToInt32(r["serviceId"])); this.session = sesC.Show(Convert.ToInt32(r["sessionId"])); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public void Delete() { ServicesController sc = new ServicesController(); sc.Delete(this.id); }