public static void Adaugare_camera() { Camere c = new Camere(); c.id = id_camere(); c.lux = Lux.liber_curata; c.sup = Superior.liber_curata; c.std = Standard.liber_curata; c.numar_camere = numar_camer(); using (MySqlConnection conn = GetConnection()) { conn.Open(); string query; query = "INSERT INTO Camere VALUES('" + c.id + "','" + c.lux.ToString() + "','" + c.sup.ToString() + "','" + c.std.ToString() + "','" + c.numar_camere + "');"; MySqlCommand cmd = new MySqlCommand(query, conn); MySqlDataReader myreader; myreader = cmd.ExecuteReader();//EXECUTE QUERY } }
public IHttpActionResult InsertCam(Camere camera) { var insert_results = hotel.spCRUDCamere(0, camera.Capacitate, camera.Pret, "Insert").ToList(); return(Ok(insert_results)); }