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