public List <PaySlipHead> getPaySlipHead(int HEADID, string HEADCODE, string DESC, int COMPID, int TRANSACTIONTYPEID, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.PAYSLIPHEADS_g(HEADID, HEADCODE, DESC, COMPID, TRANSACTIONTYPEID, USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
List <PaySlipHead> dbresult = dt != null ?
(from s in dt.AsEnumerable()
select new PaySlipHead
{
HEADID = s.Field <Int64>("HEADID"),
HEADCODE = s.Field <string>("HEADCODE"),
DESC = s.Field <string>("DESC"),
PAYROLLDESC = s.Field <string>("PAYROLLDESC"),
TRANSACTIONTYPEID = s.Field <int>("TRANSACTIONTYPE"),
TRANSACTIONTYPECODE = s.Field <string>("STATUSCODE"),
FORMULA = s.Field <string>("FORMULA"),
IsCalculation = s.Field <bool>("IsCalculation"),
ISAFFECTNATIONALPAY = s.Field <bool>("ISAFFECTNATIONALPAY"),
ISAFFECTPAYSLIP = s.Field <bool>("ISAFFECTPAYSLIP"),
PRINTONPS = s.Field <bool>("PRINTONPS"),
TYPEOFINPUTID = s.Field <int>("TYPEOFINPUTID"),
TYPEOFINPUTDESC = s.Field <string>("TYPEOFINPUTDESC"),
RATEID = s.Field <int>("RATEID"),
RATEDESC = s.Field <string>("RATEDESC"),
ISACTIVE = s.Field <bool>("ISACTIVE"),
}).ToList() : null;
return(dbresult);
}
catch (Exception ex)
{
throw ex;
}
}
public List <RateMaster> getRatemaster(int RATEID, string RATECODE, int COMPID, int BASEFACTORID, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.RATEMASTER_g(RATEID, RATECODE, COMPID, BASEFACTORID, USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
List <RateMaster> dbresult = dt != null ?
(from s in dt.AsEnumerable()
select new RateMaster
{
RATEID = s.Field <int>("RATEID"),
RATECODE = s.Field <string>("RATECODE"),
DESCRIPTION = s.Field <string>("DESCRIPTION"),
RATE = s.Field <decimal>("RATE"),
BASEFACTORID = s.Field <int>("BASEFACTORID"),
BASEFACTORDESC = s.Field <string>("STATUSCODE"),
ISACTIVE = s.Field <bool>("ISACTIVE"),
}).ToList() : null;
return(dbresult);
}
catch (Exception ex)
{
throw ex;
}
}
public List <EmployeePaySlipMapping> getEmployeePaySlipMapping(int MID, int EMPID, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.EMPLOYEEPAYMAPPING_g(MID, EMPID, USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
List <EmployeePaySlipMapping> dbresult = dt != null ?
(from s in dt.AsEnumerable()
select new EmployeePaySlipMapping
{
MID = s.Field <Int64>("MID"),
HEADID = s.Field <Int64>("HEADID"),
HEADCODE = s.Field <string>("HEADCODE"),
HEADDESC = s.Field <string>("HEADDESC"),
TRANSACTIONTYPE = s.Field <int>("TRANSACTIONTYPE"),
STATUSCODE = s.Field <string>("STATUSCODE"),
STATUSDESC = s.Field <string>("STATUSDESC"),
EMPID = s.Field <Int64>("EMPID"),
CALSEQUENCE = s.Field <int>("CALSEQUENCE"),
AMOUNT = s.Field <decimal>("AMOUNT"),
IsCalculation = s.Field <bool>("IsCalculation"),
FORMULA = s.Field <string>("FORMULA"),
ISACTIVE = s.Field <bool>("ISACTIVE")
}).ToList() : null;
return(dbresult);
}
catch (Exception ex)
{
throw ex;
}
}
// #region Methods
//Method for checking login authentication and getting user information
public LoginSessionDetails getLoginInfo(LoginModels objLogOnModel)
{
try
{
XElement LOGXML = null;
xdoc = DBXML.USERMAST_g(0, objLogOnModel.UserName.Trim(), objLogOnModel.password.Trim(), 0, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
LoginSessionDetails lst = new LoginSessionDetails();
lst = dt != null && dt.Rows.Count > 0 ?
dt.AsEnumerable().Select(s => new LoginSessionDetails
{
USERID = s.Field <Int64>("USERID"),
LOGINID = s.Field <string>("LOGINID"),
Email = s.Field <string>("Email"),
FNAME = s.Field <string>("FNAME"),
MNAME = s.Field <string>("MNAME"),
LNAME = s.Field <string>("LNAME"),
SVRKEY = s.Field <string>("SVRKEY"),
SVRDATE = s.Field <DateTime>("SVRDATE"),
ISADMIN = Convert.ToInt32(s.Field <bool>("ISADMIN")) == 1 ? true : false
}).ToList().FirstOrDefault() : null;
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public Result.Result Save(COUNTRYMAST obj, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.COUNTRYMAST_c(obj.IFLAG, obj.COUNTRYID, obj.COUNTRYCODE, obj.SHORTNAME, obj.COUNTRYNAME1, obj.ISACTIVE, USERID, LOGXML);
return(ReadBIErrors(Convert.ToString(SqlExe.GetXml(xdoc))));
}
catch (Exception ex)
{
throw ex;
}
}
public Result.Result Save(List <ProcessPayslip> objList, int USERID, int COMPID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.PROCESSPAYSLIP_c("I", COMPID, objList != null ? objList.FirstOrDefault().EMPID:0, CreateTransXMl(objList), USERID, LOGXML);
return(ReadBIErrors(Convert.ToString(SqlExe.GetXml(xdoc))));
}
catch (Exception ex)
{
throw ex;
}
}
public List <ProcessPayslip> getEmpCurrentPaySlip(Int64 EMPID, Int64 COMPID, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.PROCESSPAYSLIP_g(EMPID, COMPID, USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
List <ProcessPayslip> dbresult = dt != null ?
(from s in dt.AsEnumerable()
select new ProcessPayslip
{
EMPCODE = s.Field <string>("EMPCODE"),
FIRSTNAME = s.Field <string>("FIRSTNAME"),
LASTNAME = s.Field <string>("LASTNAME"),
MAPPINGID = s.Field <Int64>("MAPPINGID"),
HEADID = s.Field <Int64>("HEADID"),
EMPID = s.Field <Int64>("EMPID"),
CALSEQUENCE = s.Field <int>("CALSEQUENCE"),
MAPAMOUNT = s.Field <decimal>("MAPAMOUNT"),
HEADCODE = s.Field <string>("HEADCODE"),
HEADDESC = s.Field <string>("HEADDESC"),
TRANSACTIONTYPE = s.Field <int>("TRANSACTIONTYPE"),
TRANSACTIONTYPEDESC = s.Field <string>("TRANSACTIONTYPEDESC"),
IsCalculation = s.Field <bool>("IsCalculation"),
ISAFFECTNATIONALPAY = s.Field <bool>("ISAFFECTNATIONALPAY"),
ISAFFECTPAYSLIP = s.Field <bool>("ISAFFECTPAYSLIP"),
PRINTONPS = s.Field <bool>("PRINTONPS"),
TYPEOFINPUTID = s.Field <int>("TYPEOFINPUTID"),
TYPEOFINPUTDESC = s.Field <string>("TYPEOFINPUTDESC"),
RATEID = s.Field <int>("RATEID"),
RATEDESC = s.Field <string>("RATEDESC"),
PERIODID = s.Field <int>("PERIODID"),
PERIODTRANS = s.Field <int>("PERIODTRANS"),
PROCESSID = s.Field <Int64>("PROCESSID"),
QTY = s.Field <decimal>("QTY"),
RATE = s.Field <decimal>("RATE"),
AMOUNT = s.Field <decimal>("AMOUNT"),
ISOVERRIDE = s.Field <bool>("ISOVERRIDE"),
REFERENCE = s.Field <string>("REFERENCE"),
ISPROCESSED = s.Field <bool>("ISPROCESSED"),
ISCLOSED = s.Field <bool>("ISCLOSED"),
TOTALGROSSINCOME = s.Field <decimal>("TOTALGROSSINCOME"),
TOTALDEDUCTION = s.Field <decimal>("TOTALDEDUCTION"),
NETPAY = s.Field <decimal>("NETPAY"),
}).ToList() : null;
return(dbresult);
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
public Result.Result Save(PaySlipHead obj, int USERID, int COMPID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.PAYSLIPHEADS_c(obj.IFLAG, obj.HEADID, obj.HEADCODE == null ? "" : obj.HEADCODE, obj.TRANSACTIONTYPEID, obj.FORMULA == null?"":obj.FORMULA, obj.IsCalculation,
obj.DESC == null ? "" : obj.DESC, obj.PAYROLLDESC == null ? "" : obj.PAYROLLDESC, obj.ISACTIVE, obj.ISAFFECTNATIONALPAY, obj.ISAFFECTPAYSLIP, obj.PRINTONPS, obj.TYPEOFINPUTID, obj.RATEID, COMPID, USERID, LOGXML);
return(ReadBIErrors(Convert.ToString(SqlExe.GetXml(xdoc))));
}
catch (Exception ex)
{
throw ex;
}
}
public Result.Result Save(EmployeePaySlipMapping obj, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.EMPLOYEEPAYMAPPING_c(obj.IFLAG, obj.MID, obj.HEADID, obj.EMPID, obj.CALSEQUENCE, obj.AMOUNT, obj.IsCalculation,
obj.FORMULA == null ?"":obj.FORMULA, obj.ISACTIVE, USERID, LOGXML);
return(ReadBIErrors(Convert.ToString(SqlExe.GetXml(xdoc))));
}
catch (Exception ex)
{
throw ex;
}
}
public Result.Result Save(RateMaster obj, int USERID, int COMPID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.RATEMASTER_c(obj.IFLAG, obj.RATEID, obj.RATECODE == null ? "" : obj.RATECODE, obj.DESCRIPTION == null ? "" : obj.DESCRIPTION, obj.RATE,
obj.ISACTIVE, COMPID, obj.BASEFACTORID, USERID, LOGXML);
return(ReadBIErrors(Convert.ToString(SqlExe.GetXml(xdoc))));
}
catch (Exception ex)
{
throw ex;
}
}
public Result.Result Save(userMaster obj, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.USERMAST_c(obj.IFLAG, obj.USERID, obj.LOGINID, obj.Email, obj.MobileNo == null?"":obj.MobileNo, obj.MobileVerify,
obj.EmailVerify, obj.FNAME == null ? "" : obj.FNAME, obj.MNAME == null?"":obj.MNAME, obj.LNAME == null ?"":obj.LNAME, obj.DOB,
obj.ADDRESS == null?"":obj.ADDRESS, obj.PASSWORD, obj.SVRKEY == null?"":obj.SVRKEY, obj.SVRDATE,
obj.SecondaryEmailID == null ?"":obj.SecondaryEmailID, obj.ISACTIVE, obj.ISADMIN, obj.COUNTRYNAME == null ?"":obj.COUNTRYNAME, USERID, LOGXML);
return(ReadBIErrors(Convert.ToString(SqlExe.GetXml(xdoc))));
}
catch (Exception ex)
{
throw ex;
}
}
public object fillRateMaster(int RATEID, string RATECODE, int COMPID, int BASEFACTORID, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.RATEMASTER_g(RATEID, RATECODE, COMPID, BASEFACTORID, USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
var dbResult = (from row in dt.AsEnumerable()
select new
{
id = row.Field <int>("RATEID"),
text = row.Field <string>("RATECODE") + " " + row.Field <string>("DESCRIPTION")
}).ToList();
return(dbResult);
}
catch (Exception ex)
{
throw ex;
}
}
public object fillStatusMasterlist(int STATUSID, int TYPEID, string DESC, int USERID, XElement LOGXML = null)
{
try
{
Xdoc = DBXML.StatusMaster_g(STATUSID, TYPEID, DESC, USERID, LOGXML);
dt = SqlExe.GetDT(Xdoc);
var dbResult = (from row in dt.AsEnumerable()
select new
{
id = row.Field <int>("STATUSID"),
text = row.Field <string>("STATUSCODE")
}).ToList();
return(dbResult);
}
catch (Exception ex)
{
throw ex;
}
}
public object fillCountryList(int COUNTRYID, string COUNTRCODE, string COUNTRNAME, string DESC, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.COUNTRYMAST_g(COUNTRYID, COUNTRCODE, COUNTRNAME, USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
var dbResult = (from row in dt.AsEnumerable()
select new
{
id = row.Field <int>("COUNTRYID"),
text = row.Field <string>("COUNTRYNAME")
}).ToList();
return(dbResult);
}
catch (Exception ex)
{
throw ex;
}
}
public object fillPaySlipHead(int HEADID, string HEADCODE, string DESC, int COMPID, int TRANSACTIONTYPEID, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.PAYSLIPHEADS_g(HEADID, HEADCODE, DESC, COMPID, TRANSACTIONTYPEID, USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
var dbResult = (from row in dt.AsEnumerable()
select new
{
id = row.Field <Int64>("HEADID"),
text = row.Field <string>("HEADCODE"),
transType = row.Field <string>("STATUSCODE"),
FORMULA = row.Field <string>("FORMULA"),
IsCalculation = row.Field <bool>("IsCalculation")
}).ToList();
return(dbResult);
}
catch (Exception ex)
{
throw ex;
}
}
public Result.Result Save(Company obj, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.COMPANY_c(obj.IFLAG, obj.COMPID, obj.COMPCODE == null ? "" : obj.COMPCODE, obj.COMPNAME == null ? "" : obj.COMPNAME,
obj.ADDR1COMPLEXNAME == null ? "" : obj.ADDR1COMPLEXNAME,
obj.ADDR1STREETNO == null ? "" : obj.ADDR1STREETNO,
obj.ADDR1STREETNAME == null ? "" : obj.ADDR1STREETNAME,
obj.ADDR1POSTALCODE == null ? "" : obj.ADDR1POSTALCODE,
obj.ADDR1COUNTRYNAME == null ? "" : obj.ADDR1COUNTRYNAME,
obj.ADDR1STATENAME == null ? "" : obj.ADDR1STATENAME,
obj.ADDR1CITYNAME == null ? "" : obj.ADDR1CITYNAME,
obj.ADDR2SAMEASADDR1,
obj.ADDR2COMPLEXNAME == null ? "" : obj.ADDR2COMPLEXNAME,
obj.ADDR2STREETNO == null ? "" : obj.ADDR2STREETNO,
obj.ADDR2STREETNAME == null ? "" : obj.ADDR2STREETNAME,
obj.ADDR2POSTALCODE == null ? "" : obj.ADDR2POSTALCODE,
obj.ADDR2COUNTRYNAME == null ? "" : obj.ADDR2COUNTRYNAME,
obj.ADDR2STATENAME == null ? "" : obj.ADDR2STATENAME,
obj.ADDR2CITYNAME == null ? "" : obj.ADDR2CITYNAME,
obj.PRIMARYPHONE == null ? "" : obj.PRIMARYPHONE,
obj.SECONDARYPHONE == null ? "" : obj.SECONDARYPHONE,
obj.FAX == null ? "" : obj.FAX,
obj.EMAILID == null ? "" : obj.EMAILID,
obj.WEBSITE == null ? "" : obj.WEBSITE,
obj.ESTABLISHEDIN, obj.MANPOWERWORKING, obj.REGNO == null ? "" : obj.REGNO,
obj.ISACTIVE,
obj.PROCESSMONTHLY,
obj.STARTINGMONTH,
obj.MONTHSINTAXYEAR,
obj.FIRSTMONTHENDDATE,
USERID, LOGXML);
return(ReadBIErrors(Convert.ToString(SqlExe.GetXml(xdoc))));
}
catch (Exception ex)
{
throw ex;
}
}
public List <Company> getPayFrequency(int COMPID, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.PAYFREQUENCY_g(COMPID, 0, 0, "", USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
List <Company> dbresult = dt != null ?
(from s in dt.AsEnumerable()
select new Company
{
MID = s.Field <int>("MID"),
PROCESSMONTHLY = s.Field <bool>("PROCESSMONTHLY"),
STARTINGMONTH = s.Field <int>("STARTINGMONTH"),
FIRSTMONTHENDDATE = s.Field <DateTime>("FIRSTMONTHENDDATE"),
MONTHSINTAXYEAR = s.Field <int>("MONTHSINTAXYEAR"),
COMPID = s.Field <int>("COMPID"),
ISACTIVE = s.Field <bool>("MISACTIVE"),
ISCLOSED = s.Field <bool>("MISCLOSED"),
PayFreqTransList = s.Field <string>("TRANSDETAILS") != null ?
(from m in XDocument.Parse(s.Field <string>("TRANSDETAILS")).Elements("TRANSACTION").Elements("TRANS")
select new FREQUENCYPERIODTRANS
{
TID = m.Attributes("TID").FirstOrDefault().Value == null ? 0 : Convert.ToInt32(m.Attributes("TID").FirstOrDefault().Value),
MONTHID = m.Attributes("MONTHID").FirstOrDefault().Value == null ? 0 : Convert.ToInt32(m.Attributes("MONTHID").FirstOrDefault().Value),
MONTHENDDATE = Convert.ToDateTime(m.Attributes("MONTHENDDATE").FirstOrDefault().Value),
STATUS = m.Attributes("STATUS").FirstOrDefault().Value == null ? "" : Convert.ToString(m.Attributes("STATUS").FirstOrDefault().Value),
ISACTIVE = Convert.ToInt32(m.Attributes("ISACTIVE").FirstOrDefault().Value) == 0 ? false : true,
ISCLOSED = Convert.ToInt32(m.Attributes("ISCLOSED").FirstOrDefault().Value) == 0 ? false : true,
ISCURRENT = Convert.ToInt32(m.Attributes("ISCURRENT").FirstOrDefault().Value) == 0 ? false : true,
}).ToList() : null,
}).ToList() : null;
return(dbresult);
}
catch (Exception ex)
{
throw ex;
}
}
public List <userMaster> getLKUserList(int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.LK_USERMAST_g(USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
List <userMaster> dbresult = dt != null ?
(from s in dt.AsEnumerable()
select new userMaster
{
USERID = s.Field <Int64>("USERID"),
LOGINID = s.Field <string>("LOGINID"),
Email = s.Field <string>("Email"),
MobileNo = s.Field <string>("MobileNo"),
MobileVerify = s.Field <bool>("MobileVerify"),
EmailVerify = s.Field <bool>("EmailVerify"),
FNAME = s.Field <string>("FNAME"),
MNAME = s.Field <string>("MNAME"),
LNAME = s.Field <string>("LNAME"),
DOB = s.Field <DateTime>("DOB"),
ADDRESS = s.Field <string>("ADDRESS"),
PASSWORD = s.Field <string>("PASSWORD"),
SVRKEY = s.Field <string>("SVRKEY"),
SVRDATE = s.Field <DateTime>("SVRDATE"),
SecondaryEmailID = s.Field <string>("SecondaryEmailID"),
ISACTIVE = s.Field <bool>("ISACTIVE"),
ISADMIN = s.Field <bool>("ISADMIN"),
COUNTRYNAME = s.Field <string>("COUNTRYNAME")
}).ToList() : null;
return(dbresult);
}
catch (Exception ex)
{
throw ex;
}
}
public List <COUNTRYMAST> getCountry(int COUNTRYID, string COUNTRCODE, string COUNTRNAME, string DESC, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.COUNTRYMAST_g(COUNTRYID, COUNTRCODE, COUNTRNAME, USERID, LOGXML);
DataTable dt = SqlExe.GetDT(xdoc);
List <COUNTRYMAST> dbresult = dt != null ?
(from s in dt.AsEnumerable()
select new COUNTRYMAST
{
COUNTRYID = s.Field <int>("COUNTRYID"),
COUNTRYNAME = s.Field <string>("COUNTRYNAME"),
COUNTRYCODE = s.Field <string>("COUNTRYCODE"),
SHORTNAME = s.Field <string>("SHORTNAME"),
ISACTIVE = s.Field <bool>("ISACTIVE")
}).ToList() : null;
return(dbresult);
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
public Result.Result Save(Employee obj, int COMPID, int USERID, XElement LOGXML = null)
{
try
{
xdoc = DBXML.EMPLOYEE_c(
obj.IFLAG,
obj.EMPID,
obj.EMPCODE == null ? "" : obj.EMPCODE,
obj.NTITLE == null ? "" : obj.NTITLE,
obj.FIRSTNAME == null ? "" : obj.FIRSTNAME,
obj.MIDDLENAME == null ? "" : obj.MIDDLENAME,
obj.LASTNAME == null ? "" : obj.LASTNAME,
obj.NICKNAME == null ? "" : obj.NICKNAME,
obj.STARTDATE,
obj.DOB,
obj.NATIONALID == null ? "" : obj.NATIONALID,
obj.PASSPORTNO == null ? "" : obj.PASSPORTNO,
obj.COUNTRYOFISSUE == null ? "" : obj.COUNTRYOFISSUE,
obj.GENDER == null ? "" : obj.GENDER,
obj.MARITALSTATUS == null ? "" : obj.MARITALSTATUS,
obj.DEPENDENT == null ? "" : obj.DEPENDENT,
obj.YEARSOFSERVICE == null ? "" : obj.YEARSOFSERVICE,
obj.ADDR1COMPLEXNAME == null ? "" : obj.ADDR1COMPLEXNAME,
obj.ADDR1STREETNO == null ? "" : obj.ADDR1STREETNO,
obj.ADDR1STREETNAME == null ? "" : obj.ADDR1STREETNAME,
obj.ADDR1POSTALCODE == null ? "" : obj.ADDR1POSTALCODE,
obj.ADDR1COUNTRYNAME == null ? "" : obj.ADDR1COUNTRYNAME,
obj.ADDR1STATENAME == null ? "" : obj.ADDR1STATENAME,
obj.ADDR1CITYNAME == null ? "" : obj.ADDR1CITYNAME,
obj.ADDR2SAMEASADDR1,
obj.ADDR2COMPLEXNAME == null ? "" : obj.ADDR2COMPLEXNAME,
obj.ADDR2STREETNO == null ? "" : obj.ADDR2STREETNO,
obj.ADDR2STREETNAME == null ? "" : obj.ADDR2STREETNAME,
obj.ADDR2POSTALCODE == null ? "" : obj.ADDR2POSTALCODE,
obj.ADDR2COUNTRYNAME == null ? "" : obj.ADDR2COUNTRYNAME,
obj.ADDR2STATENAME == null ? "" : obj.ADDR2STATENAME,
obj.ADDR2CITYNAME == null ? "" : obj.ADDR2CITYNAME,
obj.WORKPHONE == null ? "" : obj.WORKPHONE,
obj.HOMEPHONE == null ? "" : obj.HOMEPHONE,
obj.CELLNO == null ? "" : obj.CELLNO,
obj.FAXNO == null ? "" : obj.FAXNO,
obj.SPOUSENAME == null ? "" : obj.SPOUSENAME,
obj.SPOUSENO == null ? "" : obj.SPOUSENO,
obj.EMAILID == null ? "" : obj.EMAILID,
obj.DAILYRATE,
obj.WEEKLYRATE,
obj.MONTHLYRATE,
obj.HOURLYRATE,
obj.PREVIUSYEARLYPAY,
obj.LASTINCREAMENTDATE,
obj.TERMINATIONDATE,
obj.AVGHOURPERDAY,
obj.HOURPERWEEK,
obj.DAYSPERMONTH,
obj.WEEKDAYS == null ? "" : obj.WEEKDAYS,
obj.ANNUALSTANDARDLEAVE,
obj.ANNUALSICKLEAVE,
obj.ANNUALOPTIONALLEAVE,
COMPID,
obj.ISACTIVE,
USERID,
LOGXML);
return(ReadBIErrors(Convert.ToString(SqlExe.GetXml(xdoc))));
}
catch (Exception ex)
{
throw ex;
}
}
