public PensionerUser PensionerInfo(string eid)
{
DataTable dt = com.DefaultSearch("Pensioner", "EmployeID", eid);
PensionerUser pen = new PensionerUser(dt);
return(pen);
}
public bool UpdateRetirement(PensionerUser pu)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns.Add();
dt.Rows.Add(new object[] { pu.Id, pu.Addition, pu.FinalReserve, pu.PensionRate, pu.Pension1 });
bool s1 = mem.InsertPensioner(dt);
DataTable du = new DataTable();
du.Columns.Add();
du.Columns.Add();
du.Columns.Add();
du.Columns.Add();
du.Rows.Add(new object[] { pu.Type, pu.Pension1, pu.RetirementDate, pu.Id });
bool s2 = mem.UpdateRetiredEmployee(du);
return(s1 && s2);
}
catch (Exception ee) {
MessageBox.Show(ee.ToString());
return(false);
}
}
public PensionerUser PensionCal(DateTime penregdate, DateTime retdate, double salary)
{
try
{
Rate r = new Rate();
DateTime ds = penregdate;
DateTime dr = retdate;
TimeSpan t = dr - ds;
int years = t.Days / 365;
int type;
if (years >= 30)
{
r.Id = 3;
type = 2;
}
else if (years >= 25)
{
r.Id = 2;
type = 2;
}
else if (years >= 20)
{
r.Id = 1;
type = 2;
}
else
{
r.Id = 5;
type = 3;
}
//Database sql
DataTable dt = com.DefaultSearch("Rates", "ID", r.Id);
r.Rate1 = Convert.ToDouble(dt.Rows[0][2].ToString());
PensionerUser pu = new PensionerUser();
pu.PensionRate = r.Rate1;
pu.Type = type;
pu.Pension = r.Rate1 * salary;
return(pu);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(null);
}
}
public PensionerUser ReserveCal(DateTime retdate, int type, double totalcontribution)
{
try
{
Rate r = new Rate();
DataTable dt = com.DefaultSearch("Rates", "ID", "4");
r.Rate1 = Convert.ToDouble(dt.Rows[0][2].ToString());
DateTime dr = retdate;
DateTime n = DateTime.Now.Date;
TimeSpan t = n - dr;
int latency = Convert.ToInt32(t.Days);
double Addition; //Calculations
//MessageBox.Show("Latency is "+latency.ToString()+" Rate is " + rate.ToString() + " Addition is " + Addition.ToString());
if (type == 2)
{
Addition = totalcontribution * latency * r.Rate1 / 365;
Addition = Math.Round(Addition, 2);
}
else
{
Addition = 0;
Addition = Math.Round(Addition, 2);
}
PensionerUser pu = new PensionerUser();
double FinalReserve = totalcontribution + Addition;
pu.Addition = Addition;
pu.FinalReserve = FinalReserve;
pu.AdditionRate = r.Rate1;
return(pu);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(null);
}
}
public void PensionRateCal()
{
if (RetDate.Value.Year > DateTime.Now.Year || (RetDate.Value.Month > DateTime.Now.Month && RetDate.Value.Year == DateTime.Now.Year))
{
MessageBox.Show("Do not Enter Future Periods");
return;
}
try
{
PensionerUser pp = mem.PensionCal(DateTime.ParseExact(l5.Text.ToString(), "yyyy-MM-dd", CultureInfo.InvariantCulture), RetDate.Value, Convert.ToDouble(lBSalary.Text));
lPension.Text = pp.Pension.ToString();
l10.Text = pp.PensionRate.ToString();
typeselect.SelectedValue = pp.Type.ToString();
Refresh();
}
catch (Exception ee) {
MessageBox.Show(ee.ToString());
}
}
public void ReserveCal()
{
if (RetDate.Value.Year > DateTime.Now.Year || (RetDate.Value.Month > DateTime.Now.Month && RetDate.Value.Year == DateTime.Now.Year))
{
MessageBox.Show("Do not Enter Future Periods");
return;
}
try
{
PensionerUser pu = mem.ReserveCal(RetDate.Value, Convert.ToInt32(typeselect.SelectedValue.ToString()), Convert.ToDouble(l6.Text.ToString()));
l8.Text = pu.Addition.ToString();
l9.Text = pu.FinalReserve.ToString();
l7.Text = pu.AdditionRate.ToString();
Refresh();
}
catch (Exception ee) {
MessageBox.Show(ee.ToString());
}
}
private void Update_Click(object sender, EventArgs e)
{
try
{
PensionerUser pu = new PensionerUser(l1.Text.ToString(), Convert.ToDouble(l8.Text.ToString()), Convert.ToDouble(l9.Text.ToString()), Convert.ToDouble(l10.Text.ToString()), Convert.ToDouble(lPension.Text.ToString()));
pu.Type = Convert.ToInt32(typeselect.SelectedValue.ToString());
pu.RetirementDate = RetDate.Value;
if (mem.UpdateRetirement(pu))
{
MessageBox.Show("Update Successful");
}
else
{
MessageBox.Show("Update Failed");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}