public List <Employee> getEmployee(int EMPID, string EMPCODE, int COMPID, string DESC, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.EMPLOYEE_g(EMPID, EMPCODE, COMPID, DESC, USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
List <Employee> dbresult = dt != null ?
(from s in dt.AsEnumerable()
select new Employee
{
EMPID = s.Field <Int64>("EMPID"),
COMPID = s.Field <int>("COMPID"),
EMPCODE = s.Field <string>("EMPCODE"),
NTITLE = s.Field <string>("TITLE"),
FIRSTNAME = s.Field <string>("FIRSTNAME"),
MIDDLENAME = s.Field <string>("MIDDLENAME"),
LASTNAME = s.Field <string>("LASTNAME"),
NICKNAME = s.Field <string>("NICKNAME"),
STARTDATE = s.Field <DateTime>("STARTDATE"),
DOB = s.Field <DateTime>("DOB"),
NATIONALID = s.Field <string>("NATIONALID"),
PASSPORTNO = s.Field <string>("PASSPORTNO"),
COUNTRYOFISSUE = s.Field <string>("COUNTRYOFISSUE"),
GENDER = s.Field <string>("GENDER"),
MARITALSTATUS = s.Field <string>("MARITALSTATUS"),
DEPENDENT = s.Field <string>("DEPENDENT"),
YEARSOFSERVICE = s.Field <string>("YEARSOFSERVICE"),
ADDR1COMPLEXNAME = s.Field <string>("ADDR1COMPLEXNAME"),
ADDR1STREETNO = s.Field <string>("ADDR1STREETNO"),
ADDR1STREETNAME = s.Field <string>("ADDR1STREETNAME"),
ADDR1POSTALCODE = s.Field <string>("ADDR1POSTALCODE"),
ADDR1COUNTRYNAME = s.Field <string>("ADDR1COUNTRYNAME"),
ADDR1STATENAME = s.Field <string>("ADDR1STATENAME"),
ADDR1CITYNAME = s.Field <string>("ADDR1CITYNAME"),
ADDR2COMPLEXNAME = s.Field <string>("ADDR2COMPLEXNAME"),
ADDR2STREETNO = s.Field <string>("ADDR2STREETNO"),
ADDR2STREETNAME = s.Field <string>("ADDR2STREETNAME"),
ADDR2POSTALCODE = s.Field <string>("ADDR2POSTALCODE"),
ADDR2COUNTRYNAME = s.Field <string>("ADDR2COUNTRYNAME"),
ADDR2STATENAME = s.Field <string>("ADDR2STATENAME"),
ADDR2CITYNAME = s.Field <string>("ADDR2CITYNAME"),
WORKPHONE = s.Field <string>("WORKPHONE"),
HOMEPHONE = s.Field <string>("HOMEPHONE"),
CELLNO = s.Field <string>("CELLNO"),
FAXNO = s.Field <string>("FAXNO"),
SPOUSENAME = s.Field <string>("SPOUSENAME"),
SPOUSENO = s.Field <string>("SPOUSENO"),
EMAILID = s.Field <string>("EMAILID"),
DAILYRATE = s.Field <decimal>("DAILYRATE"),
WEEKLYRATE = s.Field <decimal>("WEEKLYRATE"),
MONTHLYRATE = s.Field <decimal>("MONTHLYRATE"),
HOURLYRATE = s.Field <decimal>("HOURLYRATE"),
PREVIUSYEARLYPAY = s.Field <decimal>("PREVIUSYEARLYPAY"),
LASTINCREAMENTDATE = s.Field <DateTime>("LASTINCREAMENTDATE"),
TERMINATIONDATE = s.Field <DateTime>("TERMINATIONDATE"),
AVGHOURPERDAY = s.Field <decimal>("AVGHOURPERDAY"),
HOURPERWEEK = s.Field <decimal>("HOURPERWEEK"),
DAYSPERMONTH = s.Field <decimal>("DAYSPERMONTH"),
WEEKDAYS = s.Field <string>("WEEKDAYS"),
ANNUALSTANDARDLEAVE = s.Field <decimal>("ANNUALSTANDARDLEAVE"),
ANNUALSICKLEAVE = s.Field <decimal>("ANNUALSICKLEAVE"),
ANNUALOPTIONALLEAVE = s.Field <decimal>("ANNUALOPTIONALLEAVE"),
ISACTIVE = s.Field <bool>("ISACTIVE")
}).ToList() : null;
return(dbresult);
}
catch (Exception ex)
{
throw ex;
}
}
