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");
}
}
