Web Development

[HttpPost]
public void AddOperator(OperatorEntity entity)
{
    var bl = GetBusinessLayer();
    bl.Add(entity);
}

GET http://localhost:53175/api/Operator/AddOperator/ HTTP/1.1
Accept: application/json, text/json, text/x-json, text/javascript, application/xml, text/xml, text/plain
User-Agent: RestSharp/106.6.7.0
Host: localhost:53175
Accept-Encoding: gzip, deflate
Connection: Keep-Alive

System.Exception: 'An error occured calling the WebAPI. 
 The status code is 'MethodNotAllowed'. 
 The error message is {"Message":"The requested resource does not support http method 'DELETE'."}'

public async Task DeleteOperatorAsync(Guid id)
{
    await Task.Factory.StartNew(() =>
    {
        var webAPIExecutor = new WebAPIExecutor(ServerUrl, "/Operator/Delete/", Method.DELETE);
        webAPIExecutor.AddParameter(id, "id");
        webAPIExecutor.Execute();
    });
}

[HttpDelete]
public void Delete(Guid id)
{
    IBusinessLayer bl = new BusLayer();
    bl.DeleteOperator(id);
}

DELETE <a href="http://localhost:53175/api/Operator/Delete/">http://localhost:53175/api/Operator/Delete/</a> HTTP/1.1
Accept: application/json, text/json, text/x-json, text/javascript, application/xml, text/xml, text/plain
User-Agent: RestSharp/106.6.7.0
Content-Type: application/json
Host: localhost:53175
Content-Length: 38
Accept-Encoding: gzip, deflate

"77932bef-1b12-4204-9bd7-9a50f854a72a"

<div class = "carousel-inner">
               <div class = "carousel-item active">
                  <img src = "https://www.w3schools.com/bootstrap4/la.jpg" alt = "Los Angeles" height = "100">
               </ Div>
               <div class = "carousel-item">
                  <img src = "https://www.w3schools.com/bootstrap4/la.jpg" alt = "Chicago" height = "100">
               </ Div>
               <div class = "carousel-item">
                  <img src = "https://www.w3schools.com/bootstrap4/la.jpg" alt = "New York" height = "100">
               </ Div>
            </ Div>

<div class = "carousel-item active">
                  <img src = "advertisement / reklama1.jpg" alt = "ad1" height = "100">
               </ Div>
               <div class = "carousel-item">
                  <img src = "advertisement / reklama2.jpg" alt = "ad2" height = "100">
               </ Div>
               <div class = "carousel-item">
                  <img src = "advertisement / reklama3.jpg" alt = "reklama3" height = "100">
               </ Div>

ALTER PROCEDURE [dbo].[uspGetPivotedData]
AS
DECLARE @cols AS NVARCHAR(MAX),
    @query  AS NVARCHAR(MAX);
SET @cols = STUFF((SELECT distinct ',' + QUOTENAME(m.registration_date) 
            FROM Members m
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)') 
        ,1,1,'')
set @query = 'SELECT TransactionID,
                AmountOwed,
				FullName,
				Gender,
				phone,
				EmailAddress,
				Address,
				EventYear, 
                Description,
				Reg_Fee
				 ' + @cols + ' from 
               (
                SELECT t.TransactionID, 
					 t.AmountOwed,
					 m.FullName,
                     m.EmailAddress,
					 m.Gender, 
					 m.Phone, 
                     m.Address,
				     t.EventYear, 
                     p.Description,					
					 Reg_Fee,
                     m.registration_date,
					 t.AmountPaid
                     from dbo.Transactions AS t INNER JOIN dbo.Members AS m ON t .MemberID = m.MemberID INNER JOIN
                     dbo.PaymentTypes AS p ON t .TypeID = p.PaymentTypeID
          ) x
            pivot 
            (
                max(AmountPaid)
                for registration_date in (' + @cols + ')
            ) p '
            EXECUTE sp_executesql @query