delrosariomichael/DHELTASSys — pull request #1 by delrosariomichael (2014-02-11 06:40:10+00:00)
Title: BenefitsModuleBL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
//Imports
using System.Data;
using DHELTASSys.DataAccess;

namespace DHELTASSys.modules
{
public class BenefitsModuleBL
{
//Getters & Setters
private int emp_id;
public int Emp_id
{
get { return emp_id; }
set { emp_id = value; }
}
private int company_id;
public int Company_id
{
get { return company_id; }
set { company_id = value; }
}
private int benefit_id;
public int Benefit_id
{
get { return benefit_id; }
set { benefit_id = value; }
}
private string benefit_type;
public string Benefit_type
{
get { return benefit_type; }
set { benefit_type = value; }
}
private string benefit_info;
public string Benefit_info
{
get { return benefit_info; }
set { benefit_info = value; }
}

private string dependent_name;
public string Dependent_name
{
get { return dependent_name; }
set { dependent_name = value; }
}
private string contact_number;
public string Contact_number
{
get { return contact_number; }
set { contact_number = value; }
}
private string relation;
public string Relation
{
get { return relation; }
set { relation = value; }
}

//Processes
//Employee Benefits
public void AddEmployeeBenefits()
{
string manageEmployeeBenefitsQuery = "EXECUTE AddEmployeeBenefits '" + Emp_id + "','" + Benefit_id + "'";
DHELTASSysDataAccess.Modify(manageEmployeeBenefitsQuery);
}

public DataTable ViewEmployeeBenefits()
{
string viewBenefitsQuery = "EXECUTE ViewEmployeeBenefits '" + Emp_id + "'";
DataTable dtEmployeeBenefits = DHELTASSysDataAccess.Select(viewBenefitsQuery);
return dtEmployeeBenefits;
}

//Benefits
public DataTable ViewBenefits()
{
string viewBenefitsQuery = "EXECUTE ViewBenefits '" + company_id + "'";
DataTable dtBenefits = DHELTASSysDataAccess.Select(viewBenefitsQuery);
return dtBenefits;
}

public void AddBenefits()
{
string addBenefitsQuery = "EXECUTE AddBenefits '" + Benefit_type + "','" + Benefit_info + "','" + Company_id + "'";
DHELTASSysDataAccess.Modify(addBenefitsQuery);
}

//Dependents
public void AddDependents() {
string addDepenedentsQuery = "EXECUTE AddDependents '" + Dependent_name + "','" + Relation + "','" + Contact_number + "','" + Emp_id + "'";
}
}
}

/*V1.0 Created By MikeDR
*Created Getters & Setters
*Created Process(Add Employee Benefits,View Employee Benefits,View Benefits,Add Benefits,Add Dependents)
*/