public ACAEmployeeDetail GetEmployeeDetail(string employeeId, string year) { StringBuilder sb = new StringBuilder(); ACAEmployeeDetail det = new ACAEmployeeDetail(); sb.AppendLine(" select * FROM ACA_EMPLOYEEDETAIL where "); sb.AppendLine(" formyear='" + year + "'"); sb.AppendLine(" and empId='" + employeeId + "'"); DataTable dt = DataManager.GetData(sb.ToString(), DataConfig.GetDataConnection(DataConfig.aca_conn)); foreach (DataRow dr in dt.Rows) { det.EmployeeId = dr["empId"].ToString(); det.Fname = dr["firstname"].ToString(); det.Lname = dr["lastname"].ToString(); det.Name = dr["firstname"].ToString() + " " + dr["lastname"].ToString(); det.Employeetype = dr["employeetype"].ToString(); det.ssn = dr["ss"].ToString(); det.address = dr["address1"].ToString() + dr["address2"].ToString(); det.city = dr["city"].ToString().Replace("-", " "); det.state = dr["state"].ToString(); det.zipcode = dr["zipcode"].ToString(); det.country = dr["country"].ToString(); } return(det); }
public List <ACAEmployeeDetail> GetPayrollEmp(string year) { StringBuilder sb = new StringBuilder(); List <ACAEmployeeDetail> detls = new List <ACAEmployeeDetail>(); sb.AppendLine(" select * FROM ACA_1095C where formyear='" + year + "' "); sb.AppendLine(" and relationship ='E' order by empId"); DataTable dt = DataManager.GetData(sb.ToString(), DataConfig.GetDataConnection(DataConfig.aca_conn)); foreach (DataRow dr in dt.Rows) { ACAEmployeeDetail det = new ACAEmployeeDetail(); det.EmployeeId = dr["EMPID"].ToString(); detls.Add(det); } return(detls); }