public HttpResponseMessage UpdateZvanjePredavaca([FromBody] ZvanjePredavaca zvanjePredavaca)
{
using (var connection = new SqlConnection(ConnectionString))
{
try
{
using (var sqlCmd = new SqlCommand("UPDATE Predavac.ZvanjePredavaca SET NazivZvanjaPredavaca=@NazivZvanjaPredavaca WHERE ZvanjePredavacaID=@id"))
{
connection.Open();
sqlCmd.Connection = connection;
sqlCmd.Parameters.AddWithValue("NazivZvanjaPredavaca", zvanjePredavaca.NazivZvanjaPredavaca);
sqlCmd.Parameters.AddWithValue("id", zvanjePredavaca.ZvanjePredavacaID);
int rowAffected = sqlCmd.ExecuteNonQuery();
if (rowAffected == 0)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Error 404 Not Found"));
}
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 400 Bad Request"));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, "Updated Successfully"));
}
public HttpResponseMessage GetZvanjaPredavaca()
{
List <ZvanjePredavaca> result = new List <ZvanjePredavaca>();
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("select * from Predavac.ZvanjePredavaca", connection)
{
CommandType = CommandType.Text
};
try
{
connection.Open();
using (SqlDataReader dataReader = sqlCmd.ExecuteReader())
{
while (dataReader.Read())
{
var zvanjePredavaca = new ZvanjePredavaca
{
ZvanjePredavacaID = Convert.ToInt32(dataReader["ZvanjePredavacaID"]),
NazivZvanjaPredavaca = Convert.ToString(dataReader["NazivZvanjaPredavaca"])
};
result.Add(zvanjePredavaca);
}
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error retrieving data"));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public HttpResponseMessage CreateZvanjePredavaca([FromBody] ZvanjePredavaca zvanjePredavaca)
{
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("INSERT INTO Predavac.ZvanjePredavaca VALUES(@NazivZvanjaPredavaca)", connection);
sqlCmd.Parameters.AddWithValue("NazivZvanjaPredavaca", zvanjePredavaca.NazivZvanjaPredavaca);
try
{
connection.Open();
int i = sqlCmd.ExecuteNonQuery();
SqlCommand sqlZvanjePredavaca = new SqlCommand("SELECT TOP 1 * FROM Predavac.ZvanjePredavaca ORDER BY ZvanjePredavacaID DESC", connection);
ZvanjePredavaca last = new ZvanjePredavaca();
using (SqlDataReader zvanjePredavacaRead = sqlZvanjePredavaca.ExecuteReader())
{
while (zvanjePredavacaRead.Read())
{
last.ZvanjePredavacaID = Convert.ToInt32(zvanjePredavacaRead["ZvanjePredavacaID"]);
last.NazivZvanjaPredavaca = Convert.ToString(zvanjePredavacaRead["NazivZvanjaPredavaca"]);
}
}
var response = Request.CreateResponse(HttpStatusCode.Created, last);
response.Headers.Location = new Uri(Request.RequestUri + "/" + last.ZvanjePredavacaID);
return(response);
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 404 Bad request"));
}
}
}
public HttpResponseMessage GetByID(int id)
{
ZvanjePredavaca zvanjePredavaca = null;
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("select * from Predavac.ZvanjePredavaca where ZvanjePredavacaID=" + id, connection)
{
CommandType = CommandType.Text
};
try
{
connection.Open();
using (SqlDataReader dataReader = sqlCmd.ExecuteReader())
{
while (dataReader.Read())
{
zvanjePredavaca = new ZvanjePredavaca
{
ZvanjePredavacaID = Convert.ToInt32(dataReader["ZvanjePredavacaID"]),
NazivZvanjaPredavaca = Convert.ToString(dataReader["NazivZvanjaPredavaca"])
};
}
}
if (zvanjePredavaca == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Error 404 Found"));
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error retrieving data"));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, zvanjePredavaca));
}