public bool RegisterMember(MemberUser mu) { try { DataTable dt = new DataTable(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Rows.Add(new Object[] { mu.Nic, mu.Name, mu.Dob, mu.ServiceStartDate, mu.PensionSchemeRegisteredDate, mu.University, mu.Post, mu.Acadamic, mu.Salary, mu.Bank, mu.PaymentActNo, mu.BasicSalary, mu.Allowances, mu.Password, mu.Email }); return(mem.InsertMember(dt)); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public MemberUser SearchByID(string id) { DataTable dt = mem.FilterMember("ID", id); MemberUser mb = new MemberUser(dt); return(mb); }
private void SelectNotification(object sender, MouseEventArgs e) { MessageBox.Show(listView1.SelectedItems[0].Text.ToString()); MemberUser mu = mem.SearchByID(listView1.SelectedItems[0].Text.ToString()); mem.MemberFormOpen(mu); }
public void MemberFormOpen(MemberUser mu) { if (String.IsNullOrEmpty(mu.Nic)) { MessageBox.Show("Member Removed"); return; } int u, p, d, t, b; u = mu.University; p = mu.Post; d = mu.DependentStatus; t = mu.Type; b = mu.Bank; Member mb = new Member(u, p, d, t, b); mb.textBox1.Text = mu.Nic; mb.textBox2.Text = mu.Name; mb.textBox4.Text = mu.Dob.ToString("yyyy-MM-dd"); mb.textBox5.Text = mu.Pension.ToString(); mb.textBox6.Text = mu.PaymentActNo; mb.AcadamicC.SelectedItem = mu.Acadamic.ToString(); mb.textBox11.Text = mu.Salary.ToString(); mb.textBox12.Text = mu.TotalContribution.ToString(); mb.textBox13.Text = mu.ServiceStartDate.ToString("yyyy-MM-dd"); mb.textBox14.Text = mu.PensionSchemeRegisteredDate.ToString("yyyy-MM-dd"); mb.ValidityC.SelectedItem = mu.SystemValidity.ToString(); mb.textBox18.Text = mu.BasicSalary.ToString(); mb.textBox19.Text = mu.Allowances.ToString(); mb.Email.Text = mu.Email; if (mu.Type != 1) { mb.RetDate.Text = mu.RetirementDate.ToString("yyyy-MM-dd"); } else { mb.RetDate.Text = "Not Retired"; } mb.Show(); mb.Refresh(); mb.SelectedValues(); if (Convert.ToInt32(mb.TypeSelect.SelectedValue.ToString()) == 2) { mb.lFinalReserve.Text = this.PensionerInfo(mu.Nic).FinalReserve.ToString(); } else { mb.lFinalReserve.Text = "0"; } //mb.TotalReserve(); //mb.RetDateMethod(); }
private void SubmitEmployee_Click(object sender, EventArgs e) { if (Convert.ToInt32((NIC.Text.ToString()).Length) != 10) { MessageBox.Show("Invalid NIC"); return; } if (DOB.Value.Year > DateTime.Now.Year || (DOB.Value.Month > DateTime.Now.Month && DOB.Value.Year == DateTime.Now.Year)) { MessageBox.Show("Do not Enter Future Periods"); return; } if (ServiceStartDate.Value.Year > DateTime.Now.Year || (ServiceStartDate.Value.Month > DateTime.Now.Month && ServiceStartDate.Value.Year == DateTime.Now.Year)) { MessageBox.Show("Do not Enter Future Periods"); return; } if (PensionReg.Value.Year > DateTime.Now.Year || (PensionReg.Value.Month > DateTime.Now.Month && PensionReg.Value.Year == DateTime.Now.Year)) { MessageBox.Show("Do not Enter Future Periods"); return; } try { double salary; salary = (Convert.ToDouble(TBasicSalary.Text.ToString())) + (Convert.ToDouble(TAllowances.Text.ToString())); MemberUser mu = new MemberUser(NIC.Text.ToString(), MemName.Text.ToString(), DOB.Value, ServiceStartDate.Value, PensionReg.Value, Convert.ToInt32(Uni.SelectedValue.ToString()), Convert.ToInt32(Post.SelectedValue.ToString()), Academic, salary, Convert.ToInt32(Bank.SelectedValue.ToString()), ActNo.Text.ToString(), Convert.ToDouble(TBasicSalary.Text.ToString()), Convert.ToDouble(TAllowances.Text.ToString()), mem.HashCode("password123"), Email.Text.ToString()); MemberBUO mbu = new MemberBUO(); if (mbu.RegisterMember(mu)) { MessageBox.Show("Update Successful"); } else { MessageBox.Show("Update Failed"); } cb.FillComboBox(DType, "dependenttype", "DependentType", "DependentTypeID"); cleartxt(); cb.FillComboBox(CEID, "Employee", "ID", "ID"); } catch (Exception ex) { MessageBox.Show("Invalid Entry"); } cb.FillComboBox(CEID, "Employee", "ID", "ID"); }
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { MemberUser mu = new MemberUser(this.dataGridView1.CurrentRow); mem.MemberFormOpen(mu); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
//Retirement private void button3_Click(object sender, EventArgs e) { if (Convert.ToInt32(TypeSelect.SelectedValue.ToString()) == 1) { MemberUser mu = new MemberUser(); mu.Nic = this.textBox1.Text.ToString(); mu.Name = this.textBox2.Text.ToString(); mu.University = Convert.ToInt32(this.UniversitySelect.SelectedValue.ToString());//this.textBox3.Text.ToString(); mu.Acadamic = Convert.ToBoolean(this.AcadamicC.SelectedItem.ToString()); mu.PensionSchemeRegisteredDate = Convert.ToDateTime(this.textBox14.Text.ToString()); mu.TotalContribution = Convert.ToDouble(this.textBox12.Text.ToString()); mu.Salary = Convert.ToDouble(this.textBox18.Text.ToString()); mem.RetirementFormOpen(mu); this.Hide(); } else { MessageBox.Show("Already Retired"); } }
public void RetirementFormOpen(MemberUser pu) { try { NewPen np = new NewPen(); np.l1.Text = pu.Nic; np.l2.Text = pu.Name; np.l3.Text = pu.University.ToString();//this.textBox3.Text.ToString(); np.l4.Text = pu.Acadamic.ToString(); np.l5.Text = pu.PensionSchemeRegisteredDate.ToString("yyyy-MM-dd"); np.l6.Text = pu.TotalContribution.ToString(); np.lBSalary.Text = pu.Salary.ToString(); np.RetDate.Value = DateTime.Today; np.Show(); np.PensionRateCal(); } catch (Exception ee) { MessageBox.Show(ee.ToString()); } }
public bool UpdateEmployee(MemberUser mu) { try { DataTable dt = new DataTable(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Rows.Add(new Object[] { mu.Nic, mu.Name, mu.Dob, mu.ServiceStartDate, mu.PensionSchemeRegisteredDate, mu.Type, mu.University, mu.Post, mu.Acadamic, mu.SystemValidity, mu.DependentStatus, mu.Salary, mu.Pension, mu.Bank, mu.PaymentActNo, mu.BasicSalary, mu.Allowances, mu.Email }); return(mem.UpdateEmployee(dt)); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
private void Update_Click(object sender, EventArgs e) { try { if (postType != Convert.ToBoolean(AcadamicC.SelectedItem.ToString())) { MessageBox.Show("Invalid Post"); return; } MemberUser mu = new MemberUser(textBox1.Text.ToString(), textBox2.Text.ToString(), (Convert.ToDateTime(textBox4.Text.ToString())), (Convert.ToDateTime(textBox13.Text.ToString())), (Convert.ToDateTime(textBox14.Text.ToString())), Convert.ToInt32(TypeSelect.SelectedValue.ToString()), Convert.ToInt32(UniversitySelect.SelectedValue.ToString()), Convert.ToInt32(PostSelect.SelectedValue.ToString()), Convert.ToBoolean(AcadamicC.SelectedItem.ToString()), Convert.ToBoolean(ValidityC.SelectedItem.ToString()), Convert.ToInt32(DependentStatus.SelectedValue.ToString()), Convert.ToDouble(textBox12.Text.ToString()), (Convert.ToDouble(textBox18.Text.ToString()) + Convert.ToDouble(textBox19.Text.ToString())), Convert.ToDouble(textBox5.Text.ToString()), Convert.ToInt32(BankSelect.SelectedValue.ToString()), textBox6.Text.ToString(), Convert.ToDouble(textBox18.Text.ToString()), Convert.ToDouble(textBox19.Text.ToString()), Email.Text.ToString()); if (mem.UpdateEmployee(mu)) { MessageBox.Show("Update Successfull"); } else { MessageBox.Show("Update Failed"); } //UpdateEmployee(); } catch (NullReferenceException ee) { MessageBox.Show("All Fields must be filled"); } }