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); }