public RequestControllerModule()
{
Post["ReDoMeApi/Request/Create"] = parameters =>
{
try
{
SendLogMessage("called ReDoMeApi/Request/Create", System.Diagnostics.EventLogEntryType.SuccessAudit);
var jsonString = this.Request.Body.AsString();
Request request = ReDoMeAPI.Request.FromJson(jsonString);
request.state = RequestState.New;
//if (User != Tracking.Options.MainOptions.WEBAPIUser || Password != Tracking.Options.MainOptions.WEBAPIPassword)
// throw new Exception("Invalid password or login");
Int64 Req_ID = Database.createRequest(request);
if (Req_ID == 0)
{
ErrorAnswer answer = new ErrorAnswer("creating request error");
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
return(ReDoMeAPIResponse.CreateResponse(Req_ID.ToString(), HttpStatusCode.OK));
}
catch (Exception exc)
{
string Err = $"Error Request/Create: {exc.Message}";
SendLogMessage(Err, System.Diagnostics.EventLogEntryType.Error);
ErrorAnswer answer = new ErrorAnswer(exc.Message);
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
finally
{
SendLogMessage("ended ReDoMeApi/Request/Create", System.Diagnostics.EventLogEntryType.SuccessAudit);
}
};
Post["ReDoMeApi/Request/AddPhotos"] = parameters =>
{
try
{
SendLogMessage("called ReDoMeApi/Request/AddPhotos", System.Diagnostics.EventLogEntryType.SuccessAudit);
if (!this.Request.Query.req_id.HasValue)
{
throw new Exception("Missing parameter req_id");
}
Int64 Req_ID = this.Request.Query.req_id;
var jsonString = this.Request.Body.AsString();
PhotoList photos = ReDoMeAPI.PhotoList.FromJson(jsonString);
//if (User != Tracking.Options.MainOptions.WEBAPIUser || Password != Tracking.Options.MainOptions.WEBAPIPassword)
// throw new Exception("Invalid password or login");
if (!Database.addPhotosToRequest(Req_ID, photos))
{
ErrorAnswer answer = new ErrorAnswer("adding photos error");
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
return(ReDoMeAPIResponse.CreateResponse("OK", HttpStatusCode.OK));
}
catch (Exception exc)
{
string Err = $"Error Request/AddPhotos: {exc.Message}";
SendLogMessage(Err, System.Diagnostics.EventLogEntryType.Error);
ErrorAnswer answer = new ErrorAnswer(exc.Message);
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
finally
{
SendLogMessage("ended ReDoMeApi/Request/AddPhotos", System.Diagnostics.EventLogEntryType.SuccessAudit);
}
};
Get["ReDoMeApi/Request/GetOffers"] = parameters =>
{
try
{
SendLogMessage("called ReDoMeApi/Request/GetOffers", System.Diagnostics.EventLogEntryType.SuccessAudit);
if (!this.Request.Query.req_id.HasValue)
{
throw new Exception("Missing parameter req_id");
}
int Req_ID = this.Request.Query.req_id;
//if (User != Tracking.Options.MainOptions.WEBAPIUser || Password != Tracking.Options.MainOptions.WEBAPIPassword)
// throw new Exception("Invalid password or login");
OfferList offers = Database.getOffersForRequest(Req_ID);
if (offers == null)
{
ErrorAnswer answer = new ErrorAnswer("server error");
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
return(ReDoMeAPIResponse.CreateResponse(offers.ToJson(), HttpStatusCode.OK));
}
catch (Exception exc)
{
string Err = $"Error Request/GetOffers: {exc.Message}";
SendLogMessage(Err, System.Diagnostics.EventLogEntryType.Error);
ErrorAnswer answer = new ErrorAnswer(exc.Message);
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
finally
{
SendLogMessage("ended ReDoMeApi/Request/GetOffers", System.Diagnostics.EventLogEntryType.SuccessAudit);
}
};
Get["ReDoMeApi/Request/GetPhotos"] = parameters =>
{
try
{
SendLogMessage("called ReDoMeApi/Request/GetPhotos", System.Diagnostics.EventLogEntryType.SuccessAudit);
if (!this.Request.Query.req_id.HasValue)
{
throw new Exception("Missing parameter req_id");
}
int Req_ID = this.Request.Query.req_id;
//if (User != Tracking.Options.MainOptions.WEBAPIUser || Password != Tracking.Options.MainOptions.WEBAPIPassword)
// throw new Exception("Invalid password or login");
PhotoList photos = Database.getRequestPhotos(Req_ID);
if (photos == null)
{
ErrorAnswer answer = new ErrorAnswer("server error");
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
return(ReDoMeAPIResponse.CreateResponse(photos.ToJson(), HttpStatusCode.OK));
}
catch (Exception exc)
{
string Err = $"Error Request/GetPhotos: {exc.Message}";
SendLogMessage(Err, System.Diagnostics.EventLogEntryType.Error);
ErrorAnswer answer = new ErrorAnswer(exc.Message);
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
finally
{
SendLogMessage("ended ReDoMeApi/Request/GetPhotos", System.Diagnostics.EventLogEntryType.SuccessAudit);
}
};
Get["ReDoMeApi/Request/SetScore"] = parameters =>
{
try
{
SendLogMessage("called ReDoMeApi/Request/SetScore", System.Diagnostics.EventLogEntryType.SuccessAudit);
if (!this.Request.Query.req_id.HasValue)
{
throw new Exception("Missing parameter req_id");
}
if (!this.Request.Query.score.HasValue)
{
throw new Exception("Missing parameter score");
}
int Req_ID = this.Request.Query.req_id;
int Score = this.Request.Query.score;
//if (User != Tracking.Options.MainOptions.WEBAPIUser || Password != Tracking.Options.MainOptions.WEBAPIPassword)
// throw new Exception("Invalid password or login");
if (!Database.setScoreForRequest(Req_ID, Score))
{
ErrorAnswer answer = new ErrorAnswer("server error");
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
return(ReDoMeAPIResponse.CreateResponse("OK", HttpStatusCode.OK));
}
catch (Exception exc)
{
string Err = $"Error Request/SetScore: {exc.Message}";
SendLogMessage(Err, System.Diagnostics.EventLogEntryType.Error);
ErrorAnswer answer = new ErrorAnswer(exc.Message);
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
finally
{
SendLogMessage("ended ReDoMeApi/Request/SetScore", System.Diagnostics.EventLogEntryType.SuccessAudit);
}
};
Get["ReDoMeApi/Request/GetAllNew"] = parameters =>
{
try
{
SendLogMessage("called ReDoMeApi/Request/GetAllNew", System.Diagnostics.EventLogEntryType.SuccessAudit);
//if (User != Tracking.Options.MainOptions.WEBAPIUser || Password != Tracking.Options.MainOptions.WEBAPIPassword)
// throw new Exception("Invalid password or login");
RequestList requests = Database.getRequests(RequestState.New);
if (requests == null)
{
ErrorAnswer answer = new ErrorAnswer("server error");
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
return(ReDoMeAPIResponse.CreateResponse(requests.ToJson(), HttpStatusCode.OK));
}
catch (Exception exc)
{
string Err = $"Error Request/GetAllNew: {exc.Message}";
SendLogMessage(Err, System.Diagnostics.EventLogEntryType.Error);
ErrorAnswer answer = new ErrorAnswer(exc.Message);
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
finally
{
SendLogMessage("ended ReDoMeApi/Request/GetAllNew", System.Diagnostics.EventLogEntryType.SuccessAudit);
}
};
Get["ReDoMeApi/Request/GetAll"] = parameters =>
{
try
{
SendLogMessage("called ReDoMeApi/Request/GetAll", System.Diagnostics.EventLogEntryType.SuccessAudit);
//if (User != Tracking.Options.MainOptions.WEBAPIUser || Password != Tracking.Options.MainOptions.WEBAPIPassword)
// throw new Exception("Invalid password or login");
RequestList requests = Database.getRequests(RequestState.Any);
if (requests == null)
{
ErrorAnswer answer = new ErrorAnswer("server error");
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
return(ReDoMeAPIResponse.CreateResponse(requests.ToJson(), HttpStatusCode.OK));
}
catch (Exception exc)
{
string Err = $"Error Request/GetAll: {exc.Message}";
SendLogMessage(Err, System.Diagnostics.EventLogEntryType.Error);
ErrorAnswer answer = new ErrorAnswer(exc.Message);
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
finally
{
SendLogMessage("ended ReDoMeApi/Request/GetAll", System.Diagnostics.EventLogEntryType.SuccessAudit);
}
};
Get["ReDoMeApi/Request/GetByClient"] = parameters =>
{
try
{
SendLogMessage("called ReDoMeApi/Request/GetByClient", System.Diagnostics.EventLogEntryType.SuccessAudit);
if (!this.Request.Query.client.HasValue)
{
throw new Exception("Missing parameter Client");
}
string clientVkId = this.Request.Query.client;
//if (User != Tracking.Options.MainOptions.WEBAPIUser || Password != Tracking.Options.MainOptions.WEBAPIPassword)
// throw new Exception("Invalid password or login");
RequestList requests = Database.getRequestsByClient(clientVkId);
if (requests == null)
{
ErrorAnswer answer = new ErrorAnswer("server error");
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
return(ReDoMeAPIResponse.CreateResponse(requests.ToJson(), HttpStatusCode.OK));
}
catch (Exception exc)
{
string Err = $"Error Request/GetByClient: {exc.Message}";
SendLogMessage(Err, System.Diagnostics.EventLogEntryType.Error);
ErrorAnswer answer = new ErrorAnswer(exc.Message);
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
finally
{
SendLogMessage("ended ReDoMeApi/Request/GetByClient", System.Diagnostics.EventLogEntryType.SuccessAudit);
}
};
Get["ReDoMeApi/Request/GetByBarber"] = parameters =>
{
try
{
SendLogMessage("called ReDoMeApi/Request/GetByBarber", System.Diagnostics.EventLogEntryType.SuccessAudit);
if (!this.Request.Query.barber.HasValue)
{
throw new Exception("Missing parameter Barber");
}
string barberVkId = this.Request.Query.barber;
//if (User != Tracking.Options.MainOptions.WEBAPIUser || Password != Tracking.Options.MainOptions.WEBAPIPassword)
// throw new Exception("Invalid password or login");
RequestList requests = Database.getRequestsByMaster(barberVkId);
if (requests == null)
{
ErrorAnswer answer = new ErrorAnswer("server error");
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
return(ReDoMeAPIResponse.CreateResponse(requests.ToJson(), HttpStatusCode.OK));
}
catch (Exception exc)
{
string Err = $"Error Request/GetByBarber: {exc.Message}";
SendLogMessage(Err, System.Diagnostics.EventLogEntryType.Error);
ErrorAnswer answer = new ErrorAnswer(exc.Message);
return(ReDoMeAPIResponse.CreateResponse(answer.ToJson(), HttpStatusCode.OK));
}
finally
{
SendLogMessage("ended ReDoMeApi/Request/GetByBarber", System.Diagnostics.EventLogEntryType.SuccessAudit);
}
};
}
//---------------------------------------------
static public OfferList getOffersForRequest(int _req_id)
{
OfferList offerList = new OfferList();
offerList.items = new List <Offer>();
SqlConnection connection = new SqlConnection(Options.MainOptions.ConnectionString);
try
{
connection.Open();
//string sqlExpression = "SELECT B.[BRA_ID], B.[BRA_NAME] FROM [WORKER_DOCTOR] DW, [WORKER_BRANCH] WB, [BRANCH] B WHERE DW.[DOCT_ID] = @DOCT_ID AND DW.[WORK_ID] = WB.[WORK_ID] AND WB.[BRA_ID] = B.[BRA_ID] AND DW.[MEDORG_ID] = @MEDORG_ID AND DW.[MEDORG_ID] = B.[MEDORG_ID] AND WB.[MEDORG_ID] = B.[MEDORG_ID] AND [TIME_PER_ID] IS NOT NULL GROUP BY B.[BRA_ID], B.[BRA_NAME] ";
string sqlExpression =
@"SELECT offer_id, req_id, bar_vk_id, sal_id, offer_cost, offer_fordate, offer_selected, offer_comment
FROM offer
WHERE req_id = @REQ_ID";
SqlCommand command = new SqlCommand(sqlExpression, connection);
command.Parameters.Add(new SqlParameter("REQ_ID", _req_id));
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Offer item = new Offer();
item.id = reader.GetInt64(0);
item.req_id = reader.GetInt64(1);
if (!reader.IsDBNull(2))
{
item.bar_vk_id = reader.GetString(2);
}
if (!reader.IsDBNull(3))
{
item.sal_id = reader.GetInt32(3);
}
item.cost = reader.GetDouble(4);
item.date = reader.GetDateTime(5);
item.selected = reader.GetBoolean(6);
if (!reader.IsDBNull(7))
{
item.comment = reader.GetString(7);
}
offerList.items.Add(item);
}
}
reader.Close();
connection.Close();
}
catch (Exception e)
{
SendLogMessage(e.Message, System.Diagnostics.EventLogEntryType.Error, e);
throw e;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
foreach (Offer offer in offerList.items)
{
offer.photos = getOfferPhotos(offer.id);
}
return(offerList);
}
