public TimesResponse GetAdminTimes(TimesRequest request) { var response = new TimesResponse { ResponseStatus = ResponseStatus.Success }; var settingsProvider = new SettingsProvider(); try { if (request.ActionType == ActionType.Select) { response.Times = settingsProvider.GetTimes(request); } else { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = "Not update action"; } } catch (Exception ex) { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = ex.Message; } return(response); }
public List <Time> GetTimes(TimesRequest request) { var conn = GetConnection(ConnectionNames.CSPSqlDatabase); var commandWrapper = GetStoredProcCommand("dbo.Get_Times", conn); IDataReader reader = null; List <Time> tmp = new List <Time>(); try { conn.Open(); reader = commandWrapper.ExecuteReader(); FillTimes(reader, tmp, 0, int.MaxValue); MakeDboLog(request.ToString(), reader.ToString(), "dbo.Get_Times"); return(tmp); } finally { if (reader != null) { reader.Close(); } commandWrapper.Dispose(); conn.Close(); } }
public TimesRequest GetTimesRequest() { var request = new TimesRequest() { ActionType = Requests.ActionType.Select }; return(request); }