Object of type System.Int32 cannot be converted to type System.Boolean
public Model.PayrollEmpSalarySetup Get(string Record_Id) { Model.PayrollEmpSalarySetup iObject = null; DBManager dbManager = null; IDataReader iReader = null; string sql = string.Empty; try { sql = @"SELECT SALARY_SETUP_ID, EMP_NO, CREATE_DATE, FROM_DATE, TO_DATE, GROSS_SALARY, BASIC_SAL, HRA_SAL, MED_ALL_SAL, CONVEYANCE_SAL, OTHER_ALL_SAL, PF_SAL, PT_SAL, NET_SALARY, IS_ACTIVE, MARK_DELETED, LOGIN_ID, SYSTEM_IP,TRANS_TIME FROM dbo.PAYROLL_EMPLOYEE_SALARY_SETUP WITH(NOLOCK) WHERE MARK_DELETED=0 AND EMP_NO=" + Record_Id; switch (Constants.DBEngine) { case (int)DataProvider.SqlServer: dbManager = new DBManager(); dbManager.ConnectionString = Constants.ConnectionString; dbManager.ProviderType = DataProvider.SqlServer; break; } dbManager.Open(); dbManager.Command.CommandTimeout = Constants.CommandTimeOut; dbManager.Command.CommandText = sql; dbManager.Command.Connection = dbManager.Connection; iReader = dbManager.Command.ExecuteReader(); iObject = iReader.SingleOrDefault<Model.PayrollEmpSalarySetup>(); } catch (Exception Exp) { throw Exp; } finally { if (iReader != null) iReader.Close(); if (dbManager != null) dbManager.Close(); } return iObject; }
SingleOrDefault<T>()
Model.PayrollEmpSalarySetup
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)