AllTimesForClientResponse IClientsService.GetAllTimesForClient(AllTimesForClientRequest request) { var response = new AllTimesForClientResponse { ResponseStatus = ResponseStatus.Success }; var clientsProvider = new ClientsProvider(); try { if (request.ActionType == ActionType.Select) { response.Times = clientsProvider.GetAllClientTimes(request); response.DateFrom = request.DateFrom; response.DateTo = request.DateTo; response.ClientId = request.ClientId; } 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 <ClientTime> GetAllClientTimes(AllTimesForClientRequest request) { var conn = GetConnection(ConnectionNames.CSPSqlDatabase); var commandWrapper = GetStoredProcCommand("dbo.Get_All_ClientTimes", conn); AddInParameter(commandWrapper, "@CustomerNumber", DbType.Int32, request.ClientId); AddInParameter(commandWrapper, "@DateFrom", DbType.DateTime, request.DateFrom); AddInParameter(commandWrapper, "@DateTo", DbType.DateTime, request.DateTo); IDataReader reader = null; List <ClientTime> tmp = new List <ClientTime>(); try { conn.Open(); reader = commandWrapper.ExecuteReader(); FillClientTimes(reader, tmp, 0, int.MaxValue); MakeDboLog(request.ToString(), reader.ToString(), "dbo.Get_All_ClientTimes"); return(tmp); } finally { if (reader != null) { reader.Close(); } commandWrapper.Dispose(); conn.Close(); } }
public AllTimesForClientRequest GetAllTimesForClientRequest(int clientId, DateTime startDate, DateTime endDate) { var request = new AllTimesForClientRequest { ClientId = clientId, DateFrom = startDate, DateTo = endDate, ActionType = DataBaseCommunication.Mappers.Requests.ActionType.Select }; return(request); }