public Employee Get(String EmployeeID) { Section_DL objSectionDL = new Section_DL(Connection); EmployeeRole_DL objEmpRole = new EmployeeRole_DL(Connection); Employee objEmp = new Employee(); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@EmpID", EmployeeID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_EmployeeByID", paramList); if (dt.Rows.Count > 0) { objEmp.EmployeeID = Convert.ToString(dt.Rows[0]["EmpID"]); objEmp.EmployeeName = Convert.ToString(dt.Rows[0]["EmpName"]); objEmp.EmployeeRole = objEmpRole.Get(Convert.ToInt64(dt.Rows[0]["EmpRoleID"])); objEmp.EmpStatus = Convert.ToBoolean(dt.Rows[0]["EmpStatus"]); objEmp.EmpType = Convert.ToString(dt.Rows[0]["EmpType"]); objEmp.OTRatePerHour = Convert.ToDecimal(dt.Rows[0]["OTRatePerHour"]); objEmp.RatePerHour = Convert.ToDecimal(dt.Rows[0]["RatePerHour"]); objEmp.Section = Convert.ToInt64(dt.Rows[0]["SectionID"]); } return(objEmp); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public EmployeeCollec Get() { Section_DL objSectionDL = new Section_DL(Connection); EmployeeRole_DL objEmpRole = new EmployeeRole_DL(Connection); EmployeeCollec objEmployeeCollec = new EmployeeCollec(); try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_Employee"); for (int i = 0; i < dt.Rows.Count; i++) { Employee objEmp = new Employee(); objEmp.EmployeeID = Convert.ToString(dt.Rows[i]["EmpID"]); objEmp.EmployeeName = Convert.ToString(dt.Rows[i]["EmpName"]); objEmp.EmployeeRole = objEmpRole.Get(Convert.ToInt64(dt.Rows[i]["EmpRoleID"])); objEmp.EmpStatus = Convert.ToBoolean(dt.Rows[i]["EmpStatus"]); objEmp.EmpType = Convert.ToString(dt.Rows[i]["EmpType"]); objEmp.OTRatePerHour = Convert.ToDecimal(dt.Rows[i]["OTRatePerHour"]); objEmp.RatePerHour = Convert.ToDecimal(dt.Rows[i]["RatePerHour"]); objEmp.Section = Convert.ToInt64(dt.Rows[i]["SectionID"]); objEmployeeCollec.Add(objEmp); } return(objEmployeeCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }