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;
}
}
