public List <Company> getCompany(int COMPID, string COMPCODE, string COMPNAME, string DESC, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.COMPANY_g(COMPID, COMPCODE, COMPNAME, DESC, USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
List <Company> dbresult = dt != null ?
(from s in dt.AsEnumerable()
select new Company
{
COMPID = s.Field <int>("COMPID"),
COMPCODE = s.Field <string>("COMPCODE"),
COMPNAME = s.Field <string>("COMPNAME"),
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"),
ADDR2SAMEASADDR1 = s.Field <bool>("ADDR2SAMEASADDR1"),
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"),
PRIMARYPHONE = s.Field <string>("PRIMARYPHONE"),
SECONDARYPHONE = s.Field <string>("SECONDARYPHONE"),
FAX = s.Field <string>("FAX"),
EMAILID = s.Field <string>("EMAILID"),
WEBSITE = s.Field <string>("WEBSITE"),
ESTABLISHEDIN = s.Field <DateTime>("ESTABLISHEDIN"),
MANPOWERWORKING = s.Field <int>("MANPOWERWORKING"),
REGNO = s.Field <string>("REGNO"),
PROCESSMONTHLY = s.Field <bool>("PROCESSMONTHLY"),
MONTHSINTAXYEAR = s.Field <int>("MONTHSINTAXYEAR"),
FIRSTMONTHENDDATE = s.Field <DateTime>("FIRSTMONTHENDDATE"),
STARTINGMONTH = s.Field <int>("STARTINGMONTH"),
ISACTIVE = s.Field <bool>("ISACTIVE"),
MONTHID = s.Field <int>("MONTHID"),
MONTHENDDATE = s.Field <DateTime>("MONTHENDDATE").ToString("dd-MMM-yyyy"),
}).ToList() : null;
return(dbresult);
}
catch (Exception ex)
{
throw ex;
}
}
