public List <dbvaluta> Get()
{
List <dbvaluta> Resvaluta = new List <dbvaluta>();
var conn = GetConnection();
conn.Open();
string query = "select * from valuta p";
var cmd = new MySqlCommand(query, conn);
cmd.CommandTimeout = 60 * 5;
var reader = cmd.ExecuteReader();
while (reader.Read())
{
dbvaluta db = new dbvaluta();
db.vkode = !reader.IsDBNull(0) ? reader.GetString(0) : "";
db.vname = !reader.IsDBNull(1) ? reader.GetString(1) : "";
db.vprice = !reader.IsDBNull(2) ? reader.GetString(2) : "";
Resvaluta.Add(db);
}
return(Resvaluta);
}
public void Delete(dbvaluta Response)
{
var conn = GetConnection();
conn.Open();
string query = "delete FROM test.valuta WHERE vKode = '@VKODE'; ";
query = query.Replace("@VKODE", Response.vkode);
var cmd = new MySqlCommand(query, conn);
cmd.CommandTimeout = 60 * 5;
var reader = cmd.ExecuteReader();
}
public void Put(dbvaluta Response)
{
var conn = GetConnection();
conn.Open();
string query = "UPDATE test.valuta SET vname = '@VNAME', vprice = '@VPRICE' WHERE vKode = '@VKODE'; ";
query = query.Replace("@VKODE", Response.vkode);
query = query.Replace("@VNAME", Response.vname);
query = query.Replace("@VPRICE", Response.vprice);
var cmd = new MySqlCommand(query, conn);
cmd.CommandTimeout = 60 * 5;
var reader = cmd.ExecuteReader();
}
public void Post([FromBody] dbvaluta Response)
{
var conn = GetConnection();
conn.Open();
string query = "INSERT INTO test.valuta(vkode, vname, vprice) VALUES('@vkode', '@vname', '@vprice'); ";
query = query.Replace("@vkode", Response.vkode);
query = query.Replace("@vname", Response.vname);
query = query.Replace("@vprice", Response.vprice);
var cmd = new MySqlCommand(query, conn);
cmd.CommandTimeout = 60 * 5;
var reader = cmd.ExecuteReader();
}
public void Delete([FromBody] dbvaluta Request)
{
var client = new RestClient("https://localhost:44369/api/valuta");
client.Timeout = -1;
var request = new RestRequest(Method.DELETE);
request.AddHeader("valuta", "demoasdf1234");
request.AddHeader("Content-Type", "application/json");
var json = JsonConvert.SerializeObject(Request,
Newtonsoft.Json.Formatting.None,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore
});
request.AddParameter("application/json", json, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
Console.WriteLine(response.Content);
}
