public HttpResponseMessage UpdatePohadjaniPredmet([FromBody] PohadjaniPredmet pohadjaniPredmet)
{
using (var connection = new SqlConnection(ConnectionString))
{
try
{
using (var sqlCmd = new SqlCommand("UPDATE Predmet.PohadjaniPredmet SET PredmetId=@PredmetID,Ocena=@Ocena,BrojBodova=@BrojBodova,StudentID=@StudentID" +
"WHERE PohadjaniPredmetID=@PohadjaniPredmetID"))
{
connection.Open();
sqlCmd.Connection = connection;
sqlCmd.Parameters.AddWithValue("PohadjaniPredmetID", pohadjaniPredmet.PohadjaniPredmetID);
sqlCmd.Parameters.AddWithValue("PredmetID", pohadjaniPredmet.PredmetID);
sqlCmd.Parameters.AddWithValue("Ocena", pohadjaniPredmet.Ocena);
sqlCmd.Parameters.AddWithValue("BrojBodova", pohadjaniPredmet.BrojBodova);
sqlCmd.Parameters.AddWithValue("StudentID", pohadjaniPredmet.StudentID);
int rowAffected = sqlCmd.ExecuteNonQuery();
if (rowAffected == 0)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 400 BadRequest"));
}
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 400 BadRequest"));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, "Updated Successfully"));
}
public HttpResponseMessage GetPohadjaniPredmeti()
{
List <PohadjaniPredmet> result = new List <PohadjaniPredmet>();
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("select * from Predmet.PohadjaniPredmet", connection)
{
CommandType = CommandType.Text
};
try
{
connection.Open();
using (var dataReader = sqlCmd.ExecuteReader())
{
while (dataReader.Read())
{
var pohadjaniPredmet = new PohadjaniPredmet
{
PohadjaniPredmetID = Convert.ToInt32(dataReader["PohadjaniPredmetID"]),
PredmetID = Convert.ToInt32(dataReader["PredmetID"]),
Ocena = Convert.ToInt32(dataReader["Ocena"]),
BrojBodova = Convert.ToInt32(dataReader["BrojBodova"]),
StudentID = Convert.ToInt32(dataReader["StudentID"])
};
result.Add(pohadjaniPredmet);
}
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error retrieving data"));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public HttpResponseMessage CreatePohadjaniPredmet([FromBody] PohadjaniPredmet pohadjaniPredmet)
{
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("INSERT INTO Predmet.PohadjaniPredmet VALUES(@PredmetID,@Ocena,@BrojBodova,@StudentID)", connection);
sqlCmd.Parameters.AddWithValue("PredmetID", pohadjaniPredmet.PredmetID);
sqlCmd.Parameters.AddWithValue("Ocena", pohadjaniPredmet.Ocena);
sqlCmd.Parameters.AddWithValue("BrojBodova", pohadjaniPredmet.BrojBodova);
sqlCmd.Parameters.AddWithValue("StudentID", pohadjaniPredmet.StudentID);
try
{
connection.Open();
int i = sqlCmd.ExecuteNonQuery();
SqlCommand sqlKurs = new SqlCommand("SELECT TOP 1 * FROM Predmet.PohadjaniPredmet ORDER BY PohadjaniPredmetID DESC", connection);
PohadjaniPredmet last = new PohadjaniPredmet();
using (var dataReader = sqlKurs.ExecuteReader())
{
while (dataReader.Read())
{
last.PohadjaniPredmetID = Convert.ToInt32(dataReader["PohadjaniPredmetID"]);
last.PredmetID = Convert.ToInt32(dataReader["PredmetID"]);
last.Ocena = Convert.ToInt32(dataReader["Ocena"]);
last.BrojBodova = Convert.ToInt32(dataReader["BrojBodova"]);
last.StudentID = Convert.ToInt32(dataReader["StudentID"]);
}
}
var response = Request.CreateResponse(HttpStatusCode.Created, last);
response.Headers.Location = new Uri(Request.RequestUri + "/" + last.PohadjaniPredmetID);
return(response);
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 404 Bad request"));
}
}
}
