public void delete(EventPartDTO e)
{
IDbConnection con = DBUtils.getConnection();
using (var comm = con.CreateCommand()) {
comm.CommandText = "DELETE FROM ParticipantEvent WHERE CodP=@c AND Distance=@d AND Style=@s";
IDbDataParameter paramCod = comm.CreateParameter();
paramCod.ParameterName = "@c";
paramCod.Value = e.CodPart;
comm.Parameters.Add(paramCod);
IDbDataParameter paramDist = comm.CreateParameter();
paramDist.ParameterName = "@d";
paramDist.Value = e.Distance;
comm.Parameters.Add(paramDist);
IDbDataParameter paramStyle = comm.CreateParameter();
paramStyle.ParameterName = "@s";
paramStyle.Value = e.Style;
comm.Parameters.Add(paramStyle);
var dataR = comm.ExecuteNonQuery();
//if (dataR == 0)
// throw new RepositoryException("No task deleted!");
}
}
private void notifyObserverAddEventPart(EventPartDTO ev)
{
foreach (ISwimObserver obs in loggedClients.Values)
{
Task.Run(() => obs.AddEventPartObserver(ev));
}
}
private void populate()
{
EventPartDTO ep = new EventPartDTO(50, "BACKSTROKE", 1);
EventPartDTO ep2 = new EventPartDTO(100, "BACKSTROKE", 2);
allEP[ep.CodPart] = ep;
allEP[ep2.CodPart] = ep2;
}
public void AddEventPartObserver(EventPartDTO ev)
{
Console.WriteLine("EventPartDTO received " + ev.Distance + " " + ev.Style);
try {
sendResponse(new AddEventPartObsResponse(ev));
} catch (Exception e) {
throw new SwimException("Sending error: " + e);
}
}
public virtual void addPart2Event(EventPartDTO e)
{
sendRequest(new AddPart2EventRequest(e));
Response response = readResponse();
if (response is ErrorResponse)
{
ErrorResponse err = (ErrorResponse)response;
throw new SwimException(err.Message);
}
}
/////////////////////////////////////////////////////////////////
private void userUpdate(object sender, SwimUserEventArgs suea)
{
if (suea.UserEventType == SwimUserEvent.AddEventPart)
{
foreach (EventPartDTO ev in events)
{
EventPartDTO x = (EventPartDTO)suea.Data;
if (ev.Distance == x.Distance && ev.Style == x.Style)
{
ev.CodPart = ev.CodPart + 1;
break;
}
}
dataGvParticipant.BeginInvoke(new UpdateDGViewEventCallback(this.UpdateObserverEvent), new Object[] { dataGvEvent, events });
}
if (suea.UserEventType == SwimUserEvent.AddParticipant)
{
participants.Add((Participant)suea.Data);
dataGvParticipant.BeginInvoke(new UpdateDGViewPartCallback(this.UpdateObserverPart), new Object[] { dataGvParticipant, participants });
}
}
public void save(EventPartDTO e)
{
IDbConnection con = DBUtils.getConnection();
using (var comm = con.CreateCommand()) {
comm.CommandText = "INSERT INTO ParticipantEvent (CodP, Distance, Style) VALUES (@codP,@d,@s)";
var paramCod = comm.CreateParameter();
paramCod.ParameterName = "@codP";
paramCod.Value = e.CodPart;
comm.Parameters.Add(paramCod);
var paramDist = comm.CreateParameter();
paramDist.ParameterName = "@d";
paramDist.Value = e.Distance;
comm.Parameters.Add(paramDist);
var paramStyle = comm.CreateParameter();
paramStyle.ParameterName = "@s";
paramStyle.Value = e.Style;
comm.Parameters.Add(paramStyle);
var result = comm.ExecuteNonQuery();
}
}
private Response handleRequest(Request request)
{
Response response = null;
if (request is LoginRequest)
{
Console.WriteLine("Login request ...");
LoginRequest logReq = (LoginRequest)request;
Organizer org = logReq.Organizer;
try {
lock (server) {
server.login(org, this);
}
return(new OkResponse());
} catch (SwimException e) {
connected = false;
return(new ErrorResponse(e.Message));
}
}
if (request is LogoutRequest)
{
Console.WriteLine("Logout request");
LogoutRequest logReq = (LogoutRequest)request;
Organizer org = logReq.Organizer;
try {
lock (server) {
server.logout(org, this);
}
connected = false;
return(new OkResponse());
} catch (SwimException e) {
return(new ErrorResponse(e.Message));
}
}
if (request is GetEventsNosPartRequest)
{
Console.WriteLine("GetEventsNosPartRequest request ...");
try {
lock (server) {
return(new GetEventsNosPartResponse(server.findEventsNosParticipants()));
}
} catch (SwimException e) {
return(new ErrorResponse(e.Message));
}
}
if (request is GetAllPart4EventRequest)
{
Console.WriteLine("Searching participants for event...");
GetAllPart4EventRequest partReq = (GetAllPart4EventRequest)request;
Event ev = partReq.Event;
try {
lock (server) {
return(new GetAllPart4EventResponse(server.findPartForEvent(ev)));
}
} catch (SwimException e) {
return(new ErrorResponse(e.Message));
}
}
if (request is GetAllPartRequest)
{
Console.WriteLine("Searching all participants...");
try {
lock (server) {
return(new GetAllPartResponse(server.findAllParticipants()));
}
} catch (SwimException e) {
return(new ErrorResponse(e.Message));
}
}
if (request is AddPart2EventRequest)
{
Console.WriteLine("Adding participant to event...");
AddPart2EventRequest partReq = (AddPart2EventRequest)request;
EventPartDTO ev = partReq.EventPartDTOent;
try {
lock (server) {
server.addPart2Event(ev);
}
return(new OkResponse());
} catch (SwimException e) {
return(new ErrorResponse(e.Message));
}
}
if (request is AddParticipantRequest)
{
Console.WriteLine("Adding participant...");
AddParticipantRequest partReq = (AddParticipantRequest)request;
Participant part = partReq.Participant;
try {
lock (server) {
server.addParticipant(part);
}
return(new OkResponse());
} catch (SwimException e) {
return(new ErrorResponse(e.Message));
}
}
return(response);
}
public EventPartDTO findOne(EventPartDTO e)
{
throw new NotImplementedException();
}
public AddPart2EventRequest(EventPartDTO ev)
{
this.ev = ev;
}
public void addPart2Event(EventPartDTO e)
{
server.addPart2Event(e);
}
public void AddEventPartObserver(EventPartDTO ev)
{
SwimUserEventArgs userArgs = new SwimUserEventArgs(SwimUserEvent.AddEventPart, ev);
OnUserEvent(userArgs);
}
public void addPart2Event(EventPartDTO e)
{
eventPartRepo.save(e);
notifyObserverAddEventPart(e);
}
public AddEventPartObsResponse(EventPartDTO ep)
{
this.eventPart = ep;
}
public void save(EventPartDTO e)
{
throw new NotImplementedException();
}
public void delete(EventPartDTO id)
{
throw new NotImplementedException();
}