public HttpResponseMessage UpdatePredavacKurs([FromBody] PredavacKurs predavacKurs)
{
using (var connection = new SqlConnection(ConnectionString))
{
try
{
using (var sqlCmd = new SqlCommand("UPDATE Kurs.PredavacKurs SET PredavacID=@PredavacID, KursID=@KursID WHERE PredavacKursID=@id"))
{
connection.Open();
sqlCmd.Connection = connection;
sqlCmd.Parameters.AddWithValue("PredavacID", predavacKurs.PredavacID);
sqlCmd.Parameters.AddWithValue("KursID", predavacKurs.KursID);
sqlCmd.Parameters.AddWithValue("id", predavacKurs.PredavacKursID);
int rowAffected = sqlCmd.ExecuteNonQuery();
if (rowAffected == 0)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 400 BadRequest"));
}
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 400 Bad Request"));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, "Updated Successfully"));
}
public HttpResponseMessage GetPredavacKurs()
{
List <PredavacKurs> result = new List <PredavacKurs>();
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("select * from Kurs.PredavacKurs", connection)
{
CommandType = CommandType.Text
};
try
{
connection.Open();
using (SqlDataReader dataReader = sqlCmd.ExecuteReader())
{
while (dataReader.Read())
{
var predavacKurs = new PredavacKurs
{
PredavacKursID = Convert.ToInt32(dataReader["PredavacKursID"]),
KursID = Convert.ToInt32(dataReader["KursID"]),
PredavacID = Convert.ToInt32(dataReader["PredavacID"])
};
result.Add(predavacKurs);
}
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error retrieving data"));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public HttpResponseMessage CreatePredavacKurs([FromBody] PredavacKurs predavacKurs)
{
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("INSERT INTO Kurs.PredavacKurs VALUES(@KursID, @PredavacID)", connection);
sqlCmd.Parameters.AddWithValue("KursID", predavacKurs.KursID);
sqlCmd.Parameters.AddWithValue("PredavacID", predavacKurs.PredavacID);
try
{
connection.Open();
int i = sqlCmd.ExecuteNonQuery();
SqlCommand sqlPredavacKurs = new SqlCommand("SELECT TOP 1 * FROM Kurs.PredavacKurs ORDER BY PredavacKursID DESC", connection);
PredavacKurs last = new PredavacKurs();
using (SqlDataReader predavacKursRead = sqlPredavacKurs.ExecuteReader())
{
while (predavacKursRead.Read())
{
last.PredavacKursID = Convert.ToInt32(predavacKursRead["PredavacKursID"]);
last.KursID = Convert.ToInt32(predavacKursRead["KursID"]);
last.PredavacID = Convert.ToInt32(predavacKursRead["PredavacID"]);
}
}
var response = Request.CreateResponse(HttpStatusCode.Created, last);
response.Headers.Location = new Uri(Request.RequestUri + "/" + last.PredavacKursID);
return(response);
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 404 Bad request"));
}
}
}
