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