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