/// <summary>
/// get an employee and its deppendent information give employee's unique ID
/// </summary>
/// <param name="sql"></param>
/// <param name="uniqueID"></param>
/// <returns></returns>
public EmployeeInformation GetByUniqueID(string uniqueID)
{
if (string.IsNullOrEmpty(uniqueID))
{
return(new EmployeeInformation());
}
string sql = "EmployeeInformation..SelEmployeeDataByID";
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@UniqueId", uniqueID);
DataSet ds = _DB.Execute(sql, CommandType.StoredProcedure, 600, param);
List <EmployeeInformation> listOfEmployee = new List <EmployeeInformation>();
if (ds.Tables[0].Rows.Count > 0)
{
listOfEmployee = BuildEmployeeInformation.GetListOfEmployee(ds);
}
if (listOfEmployee.Count > 0)
{
return(listOfEmployee.First());
}
return(new EmployeeInformation());
}
/// <summary>
/// Get all the employee and its dependent information available in Database
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public List <EmployeeInformation> Get()
{
string sql = "EmployeeInformation..SelEmployeeData";
DataSet ds = _DB.Execute(sql);
List <EmployeeInformation> listOfEmployee = BuildEmployeeInformation.GetListOfEmployee(ds);
return(listOfEmployee);
}