public string GetLastCode() { try { return(new QueryManager().Max <string>("Code", string.Format("[@{0}]", mObjTravelExpensesTableDAO.GetUserTableName()))); } catch (Exception lObjException) { LogService.WriteError(string.Format("[TravelExpensesService - GetLastCode]: {0}", lObjException.Message)); throw lObjException; } }
public IList <Employees> GetByRiseId(int pIntRiseId) { try { return(new QueryManager().GetObjectsList <Employees>("U_IdRise", pIntRiseId.ToString(), string.Format("[@{0}]", mObjEmployeesTableDAO.GetUserTableName()))); } catch (Exception lObjException) { LogService.WriteError(string.Format("[EmployeesService - GetByRiseId: {0}]", lObjException.Message)); throw lObjException; } }
public string GetCode(int pIntRiseId) { try { return(new QueryManager().GetValue("Code", "U_IdRise", pIntRiseId.ToString(), string.Format("[@{0}]", mObjRiseTableDAO.GetUserTableName()).ToString())); } catch (Exception lObjException) { LogService.WriteError(string.Format("[RiseService - GetCode]: {0}", lObjException.Message)); throw lObjException; } }
public string GetLastCode() { try { return(new QueryManager().Max <string>("Code", string.Format("[@{0}]", mObjContractsTableDAO.GetUserTableName()))); } catch (Exception lObjException) { LogService.WriteError(string.Format("[GetLastCode - Remove: {0}]", lObjException.Message)); throw lObjException; } }
public List <TransitHoursRecordsDTO> GetByRiseId(int pIntRiseId) { try { return(ToTransitHoursDTO(new QueryManager().GetObjectsList <TransitHoursRecords>("U_IdRise", pIntRiseId.ToString(), string.Format("[@{0}]", mObjTransitHoursRecordsTableDAO.GetUserTableName())).ToList())); } catch (Exception lObjException) { LogService.WriteError(string.Format("[TransitHoursRecordsService - GetByRiseId]: {0}", lObjException.Message)); throw lObjException; } }