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